Question

03 Consider the following entities and their relationships. Create RDB in 3 NF with [15 Marks

appropriate data types and Constraints,

Movies (M_mism, release_year, budget Actor (A_name, role, churges, 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 ne or more actors acting in it, in different roles.

Constraint Primary key, release_year > 2000, Address and Address should not Consider the above tables and execute the following queries

be same

1. List the names of movies with the highest budget 2. Display the details of producer who have produced more than one movie in au year. [25 Marks

04. Consider the above tables and execute the following queries

List the name of movies with the second highest budget List the names of actors who have acted in the maximum number of movies.

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. List the names of actors who have acted in at least one movie, in

has acted​

Answer 1

Answer:

sorry I have 0% IQ SORRY FRIEND

Answer 2

Explanation:

give the full answer I need tha answer