Slip 12 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Movies (M_name, release_year, budget) Actor (A_name, role, charges, A_address) Producer (producer_id, name, P_address) 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.
Solution:
0 Comments