intermediate

Https — //www.kanopy.com/en/sfsu/watch/video/10910624 — 6-topic bundle

Comprehensive AI-generated study curriculum with 2 detailed note modules.

0 students cloned 3 views 2 notes

Course Syllabus

  1. Introduction to Database Systems
  2. Data Models and Conceptual Design
  3. Relational Model and Algebra
  4. Structured Query Language (SQL) Fundamentals
  5. Advanced SQL and Database Normalization
  6. Transaction Management and Concurrency Control

Study Notes

Introduction to Database Systems

A database system is a way to store, manage, and retrieve data efficiently. It's much more than just a collection of files; it includes software (the Database Management System, or DBMS) that handles all the heavy lifting.

Scrabble tiles spelling 'DATA' on a wooden table with a blurred plant background.
Photo by Markus Winkler on Pexels

Read full note →

Data Models and Conceptual Design

Relationships have cardinality, which tells you how many instances of one entity can relate to instances of another.
* One-to-one (1:1): A Husband has one Wife, and a Wife has one Husband.
* One-to-many (1:M): A Customer can place many Orders, but an Order is placed by one Customer.
* Many-to-many (M:N): A Student can enroll in many Courses, and a Course can have many Students.

Read full note →