Create a complete physical database design for the Manager, Assistant, and Member users view of Stay Home Online Rentals.
Appendix A
Data requirements The details held on a distribution center of StayHome are the center address and the telephone number. Each distribution center is given a distribution center number, which is unique throughout the company. Each distribution center has staff, which includes a Manager. The details held on a member of staff are his or her name, position, and salary. Each member of staff is given a staff number, which is unique throughout the company. Each distribution center is allocated a stock of DVDs. The details held on a DVD are the catalog number, DVD number, title, genre, and purchase price. The catalog number uniquely identifies each DVD. However, in most cases there are several copies of each DVD at a distribution center, and the individual copies are identified using the DVD number. Each distribution center receives DVDs from DVD suppliers. The details held on DVD suppliers are the supplier number, name, address, telephone number, and status. Orders for DVDs are placed with these suppliers and the details held on a DVD order are the order number, supplier number, supplier address, DVD catalog number, DVD title, DVD purchase price, quantity, date order placed, date order received, and the address of the center receiving the order. A customer of StayHome Online Rentals must first register as a member of a local distribution center of StayHome. The details held on a member are name, address, and the date that the member registered at a center. Each member is given a member number, which is unique throughout all centers of the company and is used even when a member chooses to register at more than one center.