Reference no: EM133218326

Draw an ERD (with attributes)using Chen's Notation for a video store using the following rules: 

 a. Customers of the video store are assigned a unique customer number when they make their first rental. In addition to the customer number, other information such as name and the address are also recorded. 

b. Each videotape that the store owns is identified by a unique code. Other information about the video includes the date of purchase. 

c. When a customer selects a videotape to rent, the store needs to records the rent date, rent time, return date, and the total charges. The cost for each videorentedis500. A customer can rent several videos at a time. 

d. The store owns several videotape with the same movie title. Unique identifier will be assigned to each movie title. Other information on movies include a title and the year produced. 

e. Each movie title is associated with a list of actors and one or more directors. The store has a unique code to identify each actor and director. In addition to the actor and director record, other basic information on actors and directors are stored. By using his information, the store can easily find the movies according to the actor or the director.

Create a Relational Schema after.