Questions: 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. a. Draw an appropriate Entity – Relationship Diagram of the abov
Questions:
A VCD rental shop requires a
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.
a. Draw an appropriate Entity – Relationship Diagram of the above
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
