$\backslash$table$[[$Lab $1$ Rubric$],[\backslash$table$[[$Criteria$],[$Business Rules$],[$The correct number of$],[$business rules are$],[$identified $(2$ per$],[$relationship$),$ as$],[$applicable$.]],$Ratings,$\backslash$table$[[$Pts$],[],[],[],[5$pts$]]],[\backslash$table$[[5$ pts$],[$Criteria$],[$Always Met$],[$Criteria is$],[$successfully$],[$met on$],[100\%$ of$],[$the$],[$questions$.]],\backslash$table$[[4$ pts$],[$Criteria$],[$Usually Met$],[$Criteria is$],[$successfully$],[$met on at$],[$least $75\%],[$but less$],[$than $100\%],[$of the$],[$questions$.]],\backslash$table$[[3$ pts$],[$Criteria$],[$Generally$],[$Met$],[$Criteria is$],[$successfully$],[$met on at$],[$least $50\%],[$but less$],[$than $75\%$ of$],[$the$],[$questions$.]],\backslash$table$[[2$ pts$],[$Criteria$],[$Sometimes$],[$Met$],[$Criteria is$],[$successfully$],[$met on at$],[$least $25\%],[$but less$],[$than $50\%$ of$],[$the$],[$questions$.]],\backslash$table$[[1$ pts$],[$Criteria$],[$Rarely Met$],[$Criteria is$],[$successfully$],[$met on at$],[$least $1\%$ but$],[$less than$],[25\%$ of the$],[$questions$.]],\backslash$table$[[0$ pts$],[$Criteria Not$],[$Met$],[$Criteria is$],[$not$],[$successfully$],[$met$.]]],[\backslash$table$[[$Entity Diagramming$],[$The correct tools,$],[$shapes$,$ and techniques$],[$are used to model$],[$entities and$],[$relationships$,$ as$],[$applicable$.]],\backslash$table$[[5$ pts$],[$Criteria$],[$Always Met$],[$Criteria is$],[$successfully$],[$met on$],[100\%$ of$],[$the$],[$questions$.]],\backslash$table$[[4$ pts$],[$Criteria$],[$Usually Met$],[$Criteria is$],[$successfully$],[$met on at$],[$least $75\%],[$but less$],[$than $100\%],[$of the$],[$questions$.]],\backslash$table$[[3$ pts$],[$Criteria$],[$Generally$],[$Met$],[$Criteria is$],[$successfully$],[$met on at$],[$least $50\%],[$but less$],[$than $75\%$ of$],[$the$],[$questions$.]],\backslash$table$[[2$ pts$],[$Criteria$],[$Sometimes$],[$Met$],[$Criteria is$],[$successfully$],[$met on at$],[$least $25\%],[$but less$],[$than $50\%$ of$],[$the$],[$questions$.]],\backslash$table$[[1$ pts$],[$Criteria$],[$Rarely Met$],[$Criteria is$],[$successfully$],[$met on at$],[$least $1\%$ but$],[$less than$],[25\%$ of the$],[$questions$.]],\backslash$table$[[0$ pts$],[$Criteria Not$],[$Met$],[$Criteria is$],[$not$],[$successfully$],[$met$.]],5$pts$],[\backslash$table$[[$Defining Relationships$],[$All relationships are$],[$properly defined with$],[$their appropriate$],[$cardinality$,$ optionality.$],[$and descriptive$],[$terminology $($e$.$g$.,$ has,$],[$takes$,$ earns, etc.$).]],\backslash$table$[[5$ pts$],[$Criteria$],[$Always Met$],[$Criteria is$],[$successfully$],[$met on$],[100\%$ of$],[$the$],[$questions$.]],\backslash$table$[[4$ pts$],[$Criteria$],[$Usually Met$],[$Criteria is$],[$successfully$],[$met on at$],[$least $75\%],[$but less$],[$than $100\%],[$of the$],[$questions$.]],\backslash$table$[[3$ pts$],[$Criteria$],[$Generally$],[$Met$],[$Criteria is$],[$successfully$],[$met on at$],[$least $50\%],[$but less$],[$than $75\%$ of$],[$the$],[$questions$.]],\backslash$table$[[2$ pts$],[$Criteria$],[$Sometimes$],[$Met$],[$Criteria is$],[$successfully$],[$met on at$],[$least $25\%],[$but less$],[$than $50\%$ of$],[$the$],[$questions$.]],\backslash$table$[[1$ pts$],[$Criteria$],[$Rarely Met$],[$Criteria is$],[$successfully$],[$met on at$],[$least $1\%$ but$],[$less than$],[25\%$ of the$],[$questions$.]],\backslash$table$[[0$ pts$],[$Criteria Not$],[$Met$],[$Criteria is$],[$not$],[$successfully$],[$met$.]],5$pts$],[\backslash$table$[[$Data Modeling$],[$Concepts$],[$Student demonstrated$],[$an understanding of$],[$basic data modeling$],[$concepts such as$],[$proper key field$],[$identification$,],[$appropriate integrity$],[$constraining with$],[$logical explanations,$],[$and the correct$],[$cardinality$/$optionality$],[$representations$.]],\backslash$table$[[5$ pts$],[$Criteria$],[$Always Met$],[$Criteria is$],[$successfully$],[$met on$],[100\%$ of$],[$the$],[$questions$.]],\backslash$table$[[4$ pts$],[$Criteria$],[$Usually Met$],[$Criteria is$],[$successfully$],$Objective

The objective for this assignment is to practice the concepts and process of Conceptual Modeling using an ER

Model.

Assignment

User $($Business$)$ Requirements

NetFlicks $($NF$)($not to be confused with Netflix$)$ needs to create a database to manage the operations of their

online movie streaming service.

NF assigns one or more genres to each of the films, for example Comedy, Romance, Action, and Educational.

Each film is uniquely identified by a Film ID$.$ Each film also has a title, a rating, a release year, and a version. A film

will have at least one director, at least one producer and at least one writer. The roles of writer, director, and

producer may be the same or different people.

To allow customers to search for films based on their preferred actors, NF also records the information about

actors: ID $($identifier$),$ first name and last name. A film may have zero to many actors. 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, for example language versions, directors cut, extended version.

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 include its length,

features, and language.

Assignment steps

Review the lecture material on Conceptual Modeling

Analyze the User $($Business$)$ Requirements

Following the crow's foot notation covered in the lectures, create an ER diagram based on the User

$($Business$)$ Requirements. It is highly recommended that students use

Draw.io or Lucid Chart to create their

ER Diagrams.

Submit final ER Diagram and any related documentation on Canvas.