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 databse for a movie rental company. The following two tables contain the unnormalized data that you will use in the database. Please first draw the ER diagram to indentify 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. Movies Rental Database Description and its Unnormalized Data: UNNORMALIZED TABLE 1. Display the top four movies with the greatest number of copies available (movie_qty). Please display all fields from the movies in the output. Query Result Generated By ORACLE: Draw the Entity-Relationship Diagram for your database below Instructions: You are requested to design a databse for a movie rental company. The following two tables contain the unnormalized data that you will use in the database. Please first draw the ER diagram to indentify 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. Movies Rental Database Description and its Unnormalized Data: UNNORMALIZED TABLE 1. Display the top four movies with the greatest number of copies available (movie_qty). Please display all fields from the movies in the output. Query Result Generated By ORACLE
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
