A VCD rental shop requires a database system to assist in managing the hire and returns of VCDs. The application is chosen because the requirements and working of such systems are easy to understand and familiar to many people. The database maintains details of customers, films, VCD copies of films and rental transactions. The system must record transactions (i.e. when a VCD is rented and when it is returned), calculate how much rental costs and determine which rentals are overdue. Additionally, it must record the arrival in stock of new VCDs and the disposal of obsolete and faulty VCDs. VCDs are grouped into rental price categories; the category of a VCD will normally change during its lifetime in the shop it will become cheaper as it ages. The cost of rental is based on the rental price times the number of days it has been rented. The standard period of rental is two days; additional days are charged at a reduced rate. A VCD is considered overdue if it is not returned within one week. Reports are required showing rental histories for selected clients, usage reports for selected VCDs and popularity ranking for current films available for rent.

Question Draw an appropriate Entity-Relationship Diagram of the above, clearly indicating the entities, their attributes and their relationships. Please do this assignment well, we shall use this as our guide to learn the SQL Commands.