Create a complete physical database design for the manager

Assignment Help Basic Computer Science

Reference no: EM131216699

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.

Reference no: EM131216699

Questions Cloud

Determine rc and determine the maximum gain : The circuit bandwidth is 800 MHz and the quiescent collector-emitter voltage is VCEQ = 1.25 V. - Determine RC.- Determine the maximum gain.

What laws are enforced by the eeoc : What is the EEOC's step-by-step process to address allegations? Include not only what the EEOC does, but also how the EEOC includes the employee (one making the allegation) and the employer (one against whom the allegations are made) in its proces..

What student populations might have the most difficulty : Can all students succeed in the virtual classroom? What student populations might have the most difficulty with online learning and why? How would you address these concerns?

Explain the historical foundation of the field of psychology : Explain the historical, philosophical, and empirical foundations of the field of organizational psychology and the psychology of leadership.

Create a complete physical database design for the manager : Create a complete physical database design for the Manager, Assistant, and Member users view of Stay Home Online Rentals.

Explain the legal rights of the tenant and the landlord : Explore the legal rights and responsibilities of the tenant and the landlord. Decide whether or not the landlord and / or the tenant had a legal duty to mitigate damages.

Why do you think some people are troubled by the idea : Why do you think some people are troubled by the idea that crime has a biological cause? Support your response using an article from the popular media presenting the biological argument for criminal behavior.

Determine the maximum voltage gain : Derive the expression for the voltage transfer function T (s) = Vo(s)/Vi(s). - Determine the maximum voltage gain. - What is the bandwidth?

Why might these tasks be carried out by different people : Explain the difference between logical and physical database design. Why might these tasks be carried out by different people?

User Account

All Pages