Build Tables from an ER Model

PostgreSQL-specific syntax on this page. Each spot is marked with the MySQL form.

A conference schedule. The database is empty.

venuevenue_id, name

1 : N

talktalk_id, title

M : N

speakerspeaker_id, name

Every talk is in one venue. A talk can have many speakers; a speaker can give many talks.

Use integer for the ids and text for names and titles. Every talk must have a venue (total participation).

Create venue.
Create talk, with the foreign key of the 1 : N relationship.
Create speaker.
How many tables does the M : N relationship add?
Create talk_speaker for the M : N relationship.
Store this: venue 1 'Hall A'; talk 1 'Keys in Practice' in venue 1; speakers 1 'Dana Reyes' and 2 'Ola Nowak', who both give talk 1.

Something unclear, wrong or missing?

06.Build Tables from an ER Model