Question: Draw an ERD to model a 3 NF database design for the data set Movies. Use a composite key as your primary key in at

Draw an ERD to model a 3NF database design for the data set Movies. Use a composite key as your primary key in at least one of your relations. In your ERD:
a) include any junction tables you need,
b) use crows foot notation to indicate the types of relationships between entities,
c) include all attributes, indicating an appropriate data type assigned to each attribute, and
d) assign and indicate all primary and foreign keys.
Submit your ERD as an attached file to this question. (Leave the textbox blank.) If you draw your ERD by hand and scan to upload, make sure your handwriting and the photo/scan quality is legible.
title year runtime rating starring
V for Vendetta 2005132 R Hugo Weaving (male, V), Natalie Portman (female, Evey)
Black Swan 2010108 R Natalie Portman (female, Nina Sayers)
Black Panther 2018134 PG-13 Chadwick Boseman (male, TChalla)
Freaky Friday 197695 min. G Jodie Foster (female, Annabel)
Freaky Friday 200397 PG Jamie Lee Curtis (female, Tess Coleman), Lindsay Lohan (female, Anna Coleman)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!