Summary - Design

Move from an ER model to table design.

Summary - Design

Database design starts with the ER model, continues with cardinality and key choice. The balance of surrogate and natural keys, and the denormalization call, form the core of design.

-- ER -> tablolar
-- 1:N -> FOREIGN KEY
-- M:N -> junction table

Design steps are sequential.

Exercise Summary - Design

Summary task: create the members table with id SERIAL PRIMARY KEY and email TEXT UNIQUE.

Show example solution

CREATE TABLE members (
  id SERIAL PRIMARY KEY,
  email TEXT UNIQUE
);

Test yourself

Surrogate key type

id ____ PRIMARY KEY

Show answer

id SERIAL PRIMARY KEY

What table does an M:N relationship require?
- A procedure
- A view
- A trigger
- A junction table
Show answer

A junction table — An M:N relationship requires a junction table.
Summary - Design: match the terms

ER

model
1:N

foreign
M:N

junction
denormalize

merge

Next lesson: B-tree structure

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies