Design
a relational database to store the following data:
You have a card that you bought that can be used to rent
movies from you local movie rental store.
The company wants to keep track of name and address information on all
of the people who purchase the card for marketing purposes. The company also wants to keep track of use
(each incident) incase there is a challenge and/or to use for marketing. The information you need to store is:
- Card
number
- Customer
who bought the card including id, name, address, phone, email
- Date
information for the card including date card bought and date it expires
- Amount
the card is worth when it is sold
- A
running total of the charges against the card
- Each
incident of use should include the movie id number of the movie rented,
the date/time of the rental, the number of days of the rental, the
classification, and the price
- Each
incident has to be able to be related to the card that was used to do the
rental