Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Marketing The New Profit Frontier

Authors: Ed Burnett

1st Edition

0964535629, 978-0964535626

More Books

Students also viewed these Databases questions