[Solved]Consider Movie Database Data Recorded Movie Industry Data Requirements Summarized Follows Q37165820

Consider a MOVIE database in which data is recorded about themovie industry. The data requirements are summarized asfollows:

a. Each movie is identified by title,unique movie code, year, length in minutes, and genres (such ashorror, action, drama, and so forth).

b. Each movie has a productioncompany. Production companies are identified by unique companycode, unique company name, and address. A production companyproduces one or more movies.

c. Each movie has one or moredirectors and one or more actors appear in it. Each movie has zeroor more quotable quotes, each of which is spoken by a particularactor appearing in the movie.

d. Actors are identified by uniqueactor code, name, and date of birth. Actor can appear in one ormore movies. Each actor has a role in the movie.

e. Directors are identified by uniquedirector code, name, and date of birth. A director can direct oneor more movies

Answer the following questions

1. Design an Entity-Relationship diagram for the MOVIEdatabase

2. Map the Entity-Relationship diagram for the MOVIE databaseinto a relational database, specify all primary keys and foreignkeys.

3. Normalize the tables up to third normal form

4. Create the database tables in Oracle.

5. Create data for at least 10 movies, 5 actors, 5 directors,and 5 production companies.

6. Write SQL queries for the following

i. Retrieve the titles of the movies which were released in2005

ii. Retrieve the names and addresses of all actors

iii. For each movie retrieve the movie title, genres, the actorname, and director name.

iv. Retrieve the titles of the movies produced by certaincompany.

Expert Answer

---

Answer to Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as fo… . . .