Question
NetFlicks (NF) needs to create a database to manage the operations of their online movie streaming service. NF has the following genres of Films for
NetFlicks (NF) needs to create a database to manage the operations of their online movie streaming service.
NF has the following genres of Films for streaming: Foreign, Educational. Each film is uniquely identified by a Film ID. Each film also has a title, a rating, and director(s). A film may have several directors. Each foreign film has a spoken language. Each educational film has an educational topic. A film may be both a foreign film and an educational film.
To allow customers to search for films based on their preferred actors, NF also records the information about actors: ID (identifier) and name. A film may have zero to many actor. Each actor performs a role in a film. An actor may perform in many films. To be recorded in the database, an actor must perform in at least one film.
NF carries one or more versions of each film (i.e. language version, directors cut, bonus features). Each film must have at least one version. Each version belongs to one film. Each version has a version number that is unique among the versions of the same film. Other information about a version includes its length, features, and language.
Analyze the Logical model provided (above), create a Relational Model, in 3rd normal form. Please draw entities, attributes and relationships.
\begin{tabular}{|l|} \hline \multicolumn{1}{|c|}{ Performer } \\ \hline Performer ID \\ Name \\ \hline \end{tabular} \begin{tabular}{|l|} \hline \multicolumn{1}{|c|}{ Version } \\ \hline Version Number \\ \{Feature } \\ Language \\ Length \\ \hline \end{tabular} \begin{tabular}{|l|} \hline \multicolumn{1}{|c|}{ Educational Film } \\ \hline Educational_Topic \\ \hline \end{tabular} \begin{tabular}{|l|} \hline \multicolumn{1}{|c|}{ Foreign Film } \\ \hline Spoken_Language \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started