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, 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.

Q4. Consider the above tables and execute the following queries: [25 Marks]

1. List the names of movies with the second highest budget

2. List the names of actors who have acted in the maximum number of

movies.

3. List the names of movies, produced by more than one producer.

4. List the names of actors who are given with the maximum charges for their movie.

5. List the names of actors who have acted in at least one movie, in

which ‘Akshay’

has acted.