Data Analysis

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.

Be sure your work demonstrates the ability to apply critical thinking skills to illustrate sound reasoning. This includes the ability to identify entities, formulate inferences and identify relationships between entities, identify faulty reasoning, assess assumptions, formulate conclusions, and assess what you referred to while you worked on this Assignment.

Assignment Requirements

Generate the logical design diagram using Microsoft Visio.

Compose your Assignment in a Word document and be sure to identify yourself, your class, and unit Assignment at the top of your paper. Copy the design diagram(s) into your Word document. Be sure to use appropriate APA format and cite your textbook or other sources that you used in the assignment.