Skip to main content

Courses About Pricing Educators

Sign in Get started

Courses About Pricing Educators

Get started Sign in

Loading courses

Loading lessons

Designing Schemas: PostgreSQL: Uncharted

Courses PostgreSQLDesigning Schemas

Designing Schemas

Turn practical briefs into normalized table designs with keys, cardinalities, and junctions.

PostgreSQL
Unit 6 of 12
10 lessons
87 min
220 XP

Every lesson is open. Sign in when you are ready to begin.

Sign in to start

Lessons

10 total

1From Idea to EntitiesIdentify durable people, things, and events that deserve tables in a schema.InteractiveConcept7 min20 XPOpen
2Draw Your First ERDComplete a two-table entity relationship diagram with keys and a relationship.DiagramConcept9 min20 XPOpen
3One to ManyDraw a directed one-to-many relationship from a parent key to a child reference.DiagramConcept8 min20 XPOpen
4One to One, and WhenDistinguish genuine one-to-one relationships from one-to-many relationships.InteractiveConcept7 min20 XPOpen
5Many-to-Many Needs a JunctionResolve a many-to-many relationship with a junction table and two foreign keys.DiagramConcept9 min20 XPOpen
6Choosing ColumnsKeep source facts in a table while excluding a value that should be calculated.DiagramConcept8 min20 XPOpen
7Don't Repeat DataRecognize a column that duplicates a fact already owned by another table.InteractiveConcept7 min20 XPOpen
8Split a Messy TableTurn repeated customer, order, and menu facts into a linked four-table design.DiagramConcept10 min20 XPOpen
9Design from a StoryComplete an ERD for members, classes, and their many-to-many sign-ups.DiagramPractice10 min20 XPOpen
10Design Mastery CheckComplete a normalized library ERD with entities, keys, and cardinalities.DiagramMastery check12 min40 XPOpen

Working Across Tables Building Tables