2023-05-04 - Schema Desgin and SQL

• back to Le Wagon's Bootcamp log.
• link to the lecture

main topics

• Relational Database
• Schema design

When there's a Many-to-One (N:1) relationship, the relation is stored in the N entity.

Example: city and inhabitant. The inhabitant stores the city they live.

In a Many-to-Many (N:N) relationship, a new table is created.