PostgreSQL Foundations·Practice drills 10

Drill 24: Make it smaller — Creating tables and relationships

Write a smaller version of the example that keeps the core idea.

Intermediate 5 min read Lesson 242 of 300 Challenge included
What you will be able to do
  • Write a smaller version of the example that keeps the core idea.

Practice task

Write a smaller version of the example that keeps the core idea.

schema.sqlSQL
create table courses (
  id integer generated always as identity primary key,
  slug text not null unique,
  title text not null
);

create table lessons (
  id integer generated always as identity primary key,
  course_id integer not null references courses(id) on delete cascade,
  title text not null,
  minutes integer not null
);
Your turn

Write your answer

Easy

Write a smaller version of the example that keeps the core idea.

TEXT · starter
Your answer…
Study tools

Make it yours.

Keep a private note for this lesson, then turn the key ideas into flashcards you can revisit.

Sign in to save notes and flashcards.Both are private to your account and stay with your progress.
Sign in
Finished reading?

Lock in what you just learned.

Mark this lesson complete to save your place and move one step closer to the certificate.

Lesson 242 of 300 · 0% of course