Question: Provide a Screen shot of SQL Developer on the information below (with expalnations)

The ERD for this scenario would include entities for Customers, Videos, DVDs, Movie Titles, Distributors, and Rentals. The Customers entity would have attributes such as name, address, and phone number. The Videos and DVDs entities would have attributes such as video/DVD ID number, movie ID number, and distributor ID number. The Movie Titles entity would have attributes such as title, actors, actresses, directors, and academy awards. The Distributors entity would have attributes such as company name and types of movies offered. The Rentals entity would have attributes such as rental date, return date, and any charges for late or damaged fees. Relationships would include a customer renting one or more videos or DVDs, a video or DVD belonging to one movie title, a movie title being supplied by one or more distributors, and a distributor offering multiple types of movies. Additionally, movie title can have multiple actors, actresses, directors, and academy awards.

Explanationfor step 1

We have just made some basic analysis of the given data. We will be making the E-R diagram in the next step.

Step 2/2

Based on the business requirements provided, the ERD would include the following entities:

Customers

Videos/DVDs

Movie

Distributors

Transactions

The E-R diagram is

Explanationfor step 2

Foreign keys are used to establish relationships between tables in a relational database. They are used to link data in one table to the data in another table, by matching the value of the foreign key in one table to the primary key in another table.

It is also important to mention that a movie title can have multiple actors, actresses, directors, and awards, and in this case, we would need to create another table named Movie_Actors or similar, which will connect to the Movie title and Actors table, with the foreign key being the unique identification number of the movie title, and the primary key being the unique identification number of the actor, this table will help us to maintain the many-to-many relationship between movie title and actors, similar tables will be used for actresses, directors, and award