Chapter 9, Problem 5P

Explanation of Solution

Design of video rental database:

The below is the design of video rental database that includes the support of all rental activities such as customer payment, work schedule of the employee, checkout which employee has processed the videos for the customers.

Explanation:

• Every movie is classified based on the type and the relationship between MOVIE and TYPE is N:1.
• One movie gets rented many times and the relationship between the MOVIE and RENTAL is 1:N.
• Every customer needs to pay for the rental made and the relationship between CUSTOMER and RENTAL is 1:N.
• Employee gathers details and writes about the rental made and the relationship between EMPLOYEE and RENTAL is 1:N.
• Every employee sign a work log and the relationship between the EMPLOYEE and WORK_LOG is 1:N
• Every schedule of the Employee gets enters and the relationship between the EMPLOYEE and Schedule is 1:N...