Create the initial ER diagram for a video rental shop. Use (at least) the following description of operations on which to base your business rules.

The video rental shop classifies movie titles according to their type: Comedy, Western, Classical, Science Fiction, Cartoon, Action, Musical, and New Release. Each type contains many possible titles, and most titles within a type are available in multiple copies. For example, note the summary presented in Table PB.4:

Table PB.4 The Video Rental Type and Title Relationship

TYPE	TITLE	COPY
Musical	My Fair Lady My Fair Lady Oklahoma! Oklahoma! Oklahoma!	1 2 1 2 3
Cartoon	Dilly Dally & Chit Chat Cat Dilly Dally & Chit Chat Cat Dilly Dally & Chit Chat Cat	1 2 3
Action	Amazon Journey Amazon Journey	1 2

Keep the following conditions in mind as you design the video rental database:

• The movie type classification is standard; not all types are necessarily in stock.

• The movie list is updated as necessary; however, a movie on that list might not be ordered if the video shop owner decides that it the movie is not desirable for some reason.

• The video rental shop does not necessarily order movies from all of the vendor list; some vendors on the vendor list are merely potential vendors from whom movies may be ordered in the future.

• Movies classified as new releases are reclassified to an appropriate type after they have been in stock for more than 30 days. The video shop manager wants to have an end of period (week, month, year) report for the number of rentals by type.

• If a customer requests a title, the clerk must be able to find it quickly. When a customer selects one or more titles, an invoice is written. Each invoice may thus contain charges for one or more titles. All customers pay in cash.

• When the customer checks out a title, a record is kept of the checkout date and time and the expected return date and time. Upon the return of rented titles, the clerk must be able to check quickly whether the return is late and to assess the appropriate late return fee.

• The video-store owner wants to be able to generate periodic revenue reports by title and by type. The owner also wants to be able to generate periodic inventory reports and to keep track of titles on order.

• The video-store owner, who employs two (salaried) full time and three (hourly) part-time employees, wants to keep track of all employee work time and payroll data. Part-time employees must arrange entries in a work schedule, while all employees sign in and out on a work log.