Question: this question is generated from table one and 2 that i submit Draw the Entity-Relationship Diagram for your database below Instructions: You are requested to

this question is generated from table one and 2 that i submit

Draw the Entity-Relationship Diagram for your database below Instructions: You are requested to design a database for a movie rental company. The following two tables contain the unnormalized data that you will use in the databse. Please first draw the ER diagram to identify 4 entries and their relationships. Then normalize the data and create the databse in your Oracle SQL account. Finally, write six SQL statements according to the detailed instructions given in Part II. Movie Rental Database Description and its Unnormalized Data: UNNORMALIZED TABLE 1. Display the title, category, movie_qty and the average movie_value of those movies that were rented by customers using cash as payment. Draw the Entity-Relationship Diagram for your database below Instructions: You are requested to design a database for a movie rental company. The following two tables contain the unnormalized data that you will use in the databse. Please first draw the ER diagram to identify 4 entries and their relationships. Then normalize the data and create the databse in your Oracle SQL account. Finally, write six SQL statements according to the detailed instructions given in Part II. Movie Rental Database Description and its Unnormalized Data: UNNORMALIZED TABLE 1. Display the title, category, movie_qty and the average movie_value of those movies that were rented by customers using cash as payment
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
