Code Lab BetaBUILD. RUN. DISCOVER.
Code Lab is in development. New lessons and improvements are on the way. Progress can be deleted.
Loading…
Code Lab is in development. New lessons and improvements are on the way. Progress can be deleted.
Loading…
Code Lab is in development. New lessons and improvements are on the way. Progress can be deleted.
SQL / POSTGRESQL / Learn / LESSON 09
Capstone: members, books, and loans (or enrollments). Set PK/FK and insert a few valid rows. Aim for a small working schema.
Small example:
CREATE TABLE members (...); CREATE TABLE books (...); CREATE TABLE loans (...);
The database starts empty. Grading checks the schema/data you create across variants.
Expected verify columns: table_name, member_id, book_id · row order is checked
Expected final state (displayed data):
Loading…Capstone: members, books, and loans (or enrollments). Set PK/FK and insert a few valid rows. Aim for a small working schema.
QUERY STANDBY
›