|< < 24 > >|

Entity/Relationship Model → Relational Schema

Many-to-many Relationship

The Movie/Category relationship from IMDB

create table Movie( movie_id int not null primary key, name varchar not null, year int not null, ... ); create table MovieCategory( movie_category_id not null primary key, name varchar not null, description varchar not null, ... ); create table MovieClassification( movie_id int not null references Movie, movie_category_id int not null references MovieCategory, primary key(movie_id, movie_category_id) );

|< < 24 > >|