Question: 3. Modify the Video Store ER model below to accommodate the following additional requirements: You know, we really need to keep a history of all

3. Modify the Video Store ER model below to accommodate the following additional requirements: "You know, we really need to keep a history of all our rentals. Each time a customer rents a DVD, we would like to keep the rental date/time and the return date/time. All our DVDs are due back the next day, so we don't need to keep a due date. Keeping this rental history will allow us to analyze the pattern of our rentals. We will be able to determine how many DVDs each customer rents and how many times a customer has returned a DVD late. We will also know how many times a particular DVD has been used and will then know when to retire each DVD. We will also be able to analyze our customers' movie preferences." acop: of DVD #number format MOVIE = id title o category rented by STAR BILLING rents CUSTOMER #membership number last name first name o address ophone number ACTOR #code (+; stage name oreal name birth data 3. Modify the Video Store ER model below to accommodate the following additional requirements: "You know, we really need to keep a history of all our rentals. Each time a customer rents a DVD, we would like to keep the rental date/time and the return date/time. All our DVDs are due back the next day, so we don't need to keep a due date. Keeping this rental history will allow us to analyze the pattern of our rentals. We will be able to determine how many DVDs each customer rents and how many times a customer has returned a DVD late. We will also know how many times a particular DVD has been used and will then know when to retire each DVD. We will also be able to analyze our customers' movie preferences." acop: of DVD #number format MOVIE = id title o category rented by STAR BILLING rents CUSTOMER #membership number last name first name o address ophone number ACTOR #code (+; stage name oreal name birth data
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
