CSC455

Fall 2009

Lab 3

A new trend in DVD rentals is for customers to be allowed to have a certain number of DVDs checked out at a specific time for a fixed monthly rate. Netflix is an example of this type of company. Suppose there are two plans. The first allows customers to have up to three movies checked out at a time for $19.95/month. The second plan allows customers to have up to 8 movies checked out at a time for $35.95/month. Customers can search for movies based on Titles, Genres, or Ratings. Customers maintain a prioritized queue of movies they would like to rent. As soon as a movie is returned, the next available one in the queue is sent. The store also tracks customer ratings given to movies by customers upon return (e.g. 5 stars). Employees of the store are paid by the hour and punch time cards. As a way of monitoring inventory, each transaction (check-in, check-out) must be associated with a given employee.

Create an ER diagram to represent this scenario.