After College, our first IT assignment is to help a used CD, DVD and video games store called ElectronicRecycler. The store does the following:

a) rent used CDs, DVDs or video games,

b) sell (sale) used CDs, DVDs or video games to customers and

c) buy (purchase) used CDs, DVDs or video games from customers looking to get rid of their stuff.

We need to keep track of the following information:

Customers, with a customer_id, first name, last name, address, zip code, phone, email, interests.

Each Purchase (store buys the items from a customer), which has a purchase_id, date, amount, and of course all the items purchased, by which employee and from which customer.

Each Sale (store sells the items to a customer), which has a sale_id, date, amount, all the items sold, to which customer, and by which employee.

Each Rental (store rents the items to a customer), which has a rental_id, date, what items in the inventory were rented, which employee did the rental, when they are due, the rental amount required from customer and a paid? field.

A list of employees of the store (employee_id, name, address, phone, email, rank, salary).

An inventory list, which has the type of medium (CD, DVD or video-game), the title. If its a CD, then the name of the artist, and the type of music, as well as the music label. If its a DVD, then the movie genre, the director, the hero, the heroine, the year of the movie. If its a video-game then the type of platform (example, playstation 2, xbox), the genre and the age rating. Multiple copies of each title need to be tracked, and linked to business transactions (sales, rentals, purchases).

: Draw an ER diagram, as per conventions in class