Q3 Consider the following entities and their relationships. Create a RDB in 3 NF with
appropriate data types and Constraints.
[15 Marks)
Movies (M_name, release_year, budget)
Actor (A_name, role, charges, A_address)
Producer (producer_id, name, Paddress)
Relationship - Each actor has acted in one or more movie. Each producer has produced
many movies but each movie can be produced by more than one producers. Each movie has
one or more actors acting in it, in different roles.
Constraint: Primary key, release_year > 2000, A_address and P address should not
be same.
Consider the above tables and execute the following queries:
1.
List the names of movies with the highest budget.
2. Display the details of producer who have produced more than one movie in a year.
Answers
Answered by
0
Answer:
SORRY I HAVE 0% IQ SORRY FRIEND
Similar questions