Question: could you code a video rental store with classes in c + + including database.h & database.cpp with its respective mysql script Manage rental and
could you code a video rental store with classes in c including database.h & database.cpp with its respective mysql script
Manage rental and return of movie DVDs and game disks. C
a Rent one or more DVDs andor disks to a customer.
b Record the return of one or more DVDs andor disks.
c Report the status of a specific DVD or disk title checkout status on shelf; rented if so to whom and when due; on hold if so for whom
Manage list of customers C and M as noted
a Add a new customer C
b Modify information stored about a customer C
c Delete a customer. M
Manage list of titles of movies and titles of games available for rental M and C as noted
a Add a new title M
b Delete a title M
c Respond to inquiries about a particular title general information about it plus whether a copy is available for rental now. C
Manage inventory of individual DVDs disks available for rental. M
a Add one or more newly acquired DVDs or disks.
b Delete a lost, damaged, or no longer needed DVD or disk.
Manage records of outstanding late charges owed by a customer. C and M as noted
a Add a late charge if a customer returns a DVD or disk late. The customer may drop off returns without interacting with a clerk, so late charges incurred may have to be recorded now and collected the next time the customer comes in for a rental. However, if the customer is present it should be possible to collect the charge on the spot. The charge is computed and added automatically when the DVD or disk is returned during b above and the clerk is asked if the customer is present and wishes to pay the charge now. C
b Indicate that the customer has unpaid late charges when the customer attempts to rent an item. This is done automatically when a customers id is entered during a above, and the clerk is told to ask the customer whether heshe wishes to pay the late charges now. A customer who chooses not to pay can still rent the itemC
c Record the payment of one or more late charges owed by a particular customer. The customer has the option of paying all outstanding late charges, or just specific ones This is available as part of a and b above, and is also directly available if a customer comes in and asks to pay late charges. C
d Respond to customer inquiries about late charges the title rented, when it was due, and when it was returned. This option is available whenever the clerk attempts to collect outstanding late charges c above and is also directly available if a customer comes in and asks about outstanding late charges. C
e Cancel a specific late charge. M
Accept a customer reservation for a title for which all copies are currently rented, to be filled later on a first come, first served basis. C
a Enter a reservation for a specific title.
b Place a newlyreturned item on hold for the first customer who has a reservation for itDone automatically during b above when a DVD or disk is returned and there are one or more outstanding reservations for the title. The clerk is told the name and phone number of the customer for which the item is on hold so as to be able to phone the customer to let himher know that the item is in
c Cancel a reservation. This may be initiated by the customer at any time, or may need to be done if the customer for whom an item is being placed on hold cannot be contacted or doesn't want the item in which case it is put on hold for the next customer on the list, or returned to general stock if there is none.
Produce a customer report for management upon request, showing the following
information, with the following reported for each customer: M
a Name and other basic information eg address, phone
b Total number of DVDsdisks the customer currently has out
c Information about currently overdue DVDs or disks. There should be one line of information for each item, including its title and when it was supposed to be due.
d Information about fines currently owed. There should be one line of information for each fine, including the title of the item that was returned late, the date on which it was due, the date on which it was actually returned, and the amount of the fine. In addition, if the customer owes one or more fines, the total amount of all fines should be shown.
The manager must be able to choose whether to produce such a report for
All customers.
Only customers that have one or more overdue items
Only for customers that owe one or more late fees.
Produce a title report for management upon request, showing all titles, with the following
information for each title: M
a Name and other basic information.
Total number of copies currently owned should equal sum of next three items, each of which should also be separately reported
Number of copies currently rented out
Number of copies on hold for some customer
Number currently in stock
b Number of reservations pending for the item
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
