Logical model using the conceptual data model

 

Continue to normalize the design and create a logical model using the conceptual data model created in the last unit and leveraging the same Movies Dataset.
In a Word document, write the following:
1. For each of the entities, define all of the attributes. Define the data type and nullability of each attribute. Explain your choices.
2. For each of the entities, define the primary key. Define the data type and nullability. Explain your choices.
3. For each of the entities, define any foreign keys. Define the data type and nullability of each key. Explain your choices.
4. Create a logical model diagram using Microsoft Visio. Refer to the learning activity for an example. Please embed the Visio diagram in your Word document so that you are only submitting a single document for this Assignment.
What did you refer to while working on this Assignment? Annotate those as your references at the end of the paper.

Our customer support team is here to answer your questions. Ask us anything!