Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. (10 points) Design ER model for the following requirement. If there is any not well defined requirement, please write down your own reasonable assumption
1. (10 points) Design ER model for the following requirement. If there is any not well defined requirement, please write down your own reasonable assumption in your report. Movies have title, year they were made, length, and type. Stars act in movies, and we would like to keep track of their names and addresses. Studios own movies, and contract stars to appear in their movies. We would like to keep track of studios' names and addresses and the current contract among studio, stars and movies. We would like to keep track of which movies are sequels, e.g., T2 is a sequel of Terminator. We need to record the salary a star was paid to star in a movie, e.g., Arnold was paid 10M to star in Terminator, and 100M to star in T2. 2. (10 points) Convert the above ER diagram to relation tables. You don't need to provide the real SQL statement, just the relational model, like this R(A1, A2, A3). You need to: Underline the primary key Specify the foreign keys. Use the format like this: (A1,A2) references TableX(A3,A4). Merge the many-to-exactly one relationship with the relation of the many side Merge the one-to-exactly one relationship with the relation of the left one side
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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