Based on this description did I create the Class Diagram Correctly? Please open the attachment.
General Manager (GM) of Bobcat Movie Rentals has hired your team as consultant to design and implement a
database for the company. Initial meeting with the GM provided following information:
Bobcat Movie Rentals has several stores throughout the USA. For each store, it is essential to record the store’s
telephone number and address that consists of the street, city, state and zip code. Each store is given a store
number, which is unique throughout the company. Each store has employees, which also includes a Store
Manager. The Store Manager at each store is responsible for the day-to-day operation of the store. Data
maintained for each employee includes name, home address, home phone, gender, hire date, position and salary.
Each employee is assigned an employee number, which is unique throughout the company. Each employee is
assigned to one store.
Each store has a stock of movie DVDs. The data stored for each movie DVD includes the catalog number, copy
number, title, category, daily rental charge, cost, status, and the name of the director. The catalog number
uniquely identifies each movie title. In most cases, there are several copies of each movie title at a store, and the
individual DVD copies are identified using the copy number. A movie is assigned a category such as Action,
Drama, Comedy, Horror, Sci-Fi, or Children. The status indicates whether a specific copy of a movie is available
Before renting a movie DVD at any store, a customer must register as a member at a store. After registration, a
member is allowed to rent DVDs. The data recorded about each member include the first name, last name, middle
initial, address, phone number and the date on which the member registered at a store. It is essential to keep track
of the store at which the customer registered as a member. Each member is assigned a member number, which is
unique throughout all stores of the company. The data recorded for each rental transaction on a paper form
includes the rental number, the customer’s name and member number, the catalog number and copy number of
each movie DVD rented, actual daily rental charge for each movie DVD, and the dates the DVD(s) is rented out
and returned. The rental number is unique throughout the company. On a rental transaction, a customer can rent
more than one movie titles.