SQL: Schema Design (it#1) - Metro-state/ICS311-group-project GitHub Wiki

Iteration 1: Basic schema without normalization

[A] Minimal (mandatory) data for every movie

movies
PK en_name
PK year
int_name

[B] Meta data of the movie

movie_meta
PK meta_id
FK en_name
FK year
country
plot
genre
trivia
keywords

[C] Extended data (People)

movie_meta

https://i.imgur.com/CdFH8sV.png