Flashcards: Mastering Relational Database Design — 10 cards

Relational Database Model — core concept?

Organizes data into related tables using keys.

Table — definition?

Collection of related data organized in rows and columns.

Tables and Keys — purpose?

Define data structure and relationships.

Primary Key — role?

Unique identifier for each record in a table.

Relationship Types — examples?

One-to-one, one-to-many, many-to-many.

Foreign Key — purpose?

Establishes relationship by referencing another table's primary key.

One-to-One — relationship?

Each record relates to only one record.

One-to-Many — relationship?

One record relates to many records.

Many-to-Many — implementation?

Via junction tables.

Normalization — goal?

Reduce redundancy and dependency in data.