Question: Each actor / actress in the actor / actress union has a unique number ( example: A 1 2 3 4 , B 1 2

Each actor/actress in the actor/actress union has a unique number (example: A1234, B1235). Each movie in the movie database has a unique number (example: M08A, M08B). We want to store for each actor, their name, date of bith, sex, and amount of money earned per movie. We want to store for each movie, its title, time in minutes, rating (The possible choices for the field rating are: \( G, P G, P G 13, R, X, N R \)), and the amount of money paid to each actor/actress.
Be sure to clearly define what each field refers to. What is the correct decomposition into \(3 N F \)? Be sure to clearly indicate the primary key(s) of each table.
Each actor / actress in the actor / actress union

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!