SQL: Schema Requirements - Metro-state/ICS311-group-project GitHub Wiki

[A] Minimal (mandatory) data for every movie

We will manage the following minimal data in the database. 1 and 3 are the primary key.

[1] Movie Name (in Native Lanaguage)
[2] Movie Name in English (in English Language)
[3] Year Made (YYYY format) (It is possible that a movie with the same name can be made in two different years)

[B] Meta data of the movie

This metadata can be optional

[4] Language (We will use English name of the language from ISO standard ISO639-2 https://www.loc.gov/standards/iso639-2/php/code_list.php)
[5] Country (the name of the country in which the movie is made) (https://en.wikipedia.org/wiki/ISO_ 3166-1 We will use this standard)
[6] plot (brief description/summary about the movie)
[7] genre (we can use NETFLIX list of genres)
[8] trivia (any tidbit about the movie; assume that there can be more than one trivia about the movie)
[9] keywords (any keywords that can not be covered by the other meta data; Assume there can be more than one keyword for each movie)

[C] Extended data (People)

We will also manage the people (cast as well as the production team) in our database.

[10] Director (there can be more than one director for a given movie; It is rare, but can happen)
[11] Producer (there can be more than one producer for a given movie; It is rare, but can happen)
[12] Music Director (there can be more than one music director for the movie)
[13] Lead Actor (male)
[14] Lead Actress (female)
[15] Actors (male) (Supporting Roles)
[16] Actresses (female) Supporting Roles)

[D] Extended data (Songs)

Some of the movies (especially, the movies produced in India) will have songs. These songs are not sung by the actors, but by the people called "playback singers". The actors only lip-sync for those song sequences. This data is optional data as some movies may not have any songs.

[17] Title of the Song
[18] Lyrics of the entire Song
[19] Playback Singers for each song (there can be more than one singer for each song)
[20] Lyricist (Assume that there will be one writer for each song)
[22] Audio link to the song (there can be more than one link to the audio recording of the song)
[23] Video link to the song (there can be more than one link to the song; For example, youtube links)

[E] Multi-media and References (Movie)

In addition to the above, we will manage some additional data

[24] movie_poster (there can be more than one poster for a given movie)
[25] photo_stills (there can be more than one photo, still image, for a given movie)