Please help me with Relational Table and and also convert to an ER Diagram. Like I have uploaded the example of ER Diagram. You can draw the diagram and table in paper and explain it to me$.$

Description:

Before Netflix existed, there were stores where you rented a movie in either a video cassette $($VHS$)$ format or a compact disc format $($DVD$).$ But then, in $1997,$ Netflix was founded by Reed Hastings and Marc Randolph as a DVD$-$by$-$mail rental service. The company initially offered a subscription service where users could rent DVDs and receive them by mail. Netflix distinguished itself from traditional video rental stores by eliminating the need for customers to leave their homes to rent movies.

Imagine you are back in the nineties and the early $2000$s; imagine that VideoFlick is a video rental store that rents out movies in VHS tape format. You are given a dataset of video rental records kept by several employees. After each employee rents out a movie to a customer, they enter the transaction information into an Excel sheet. Even though VideoFlick is a one$-$branch store, they are trying to expand by opening more stores. The company$$s leadership realized that keeping records using an Excel sheet is not an efficient way of storing information. So$,$ they decided to hire programmers to design and build an information system that would help employees enter the information for each transaction quickly and help in business decision$-$making by applying data mining algorithms to the database. The programmers decided first to build a relational SQL database that would allow the creation of a graphical user interface and a data analysis application.

The programming team was given the Excel sheet attached to this document as an example of how employees used to keep records. Each movie has a number as a unique identifier. Also, each movie has multiple copies with copy numbers. The combination of movie number and copy number creates a unique identifier for each VHS tape in the store. Each customer might rent multiple movies, and they would all be counted as one transaction. The rental fee for each movie rented is per day. If the return date is the same as the rental date, this is considered one day. If it is the next day, this is regarded as two days. The customer must pay the fee when they return the movie or movies they rented. The transaction is closed only after the customer has returned the movie. If the movie were returned late, an additional fee would be applied. Each transaction has a unique identifier. Also, each transaction stores employee information, customer information, and rented movies information.

What to do

$1-$ Study the dataset for a while.

$2-$ Given the background and the description of the data provided above and also given what you have read and heard during the lectures. If you were to create a relational data model from the above Excel sheet you would need to identify the following:

A$-$ Entities.

B$-$ Attributes$/$Properties$.$

C$-$ Relations between the entities.

D$-$ Draw the entities, attributes, and their relationships.

E$-$ In a few sentences after the diagram you have provided explain the role of each entity and the relationship.