Question: Database ER diagram and normalization question: Buyme! is an online company that sales hundreds of office supply products on its e-Commerce store. BuyMe! has asked

Database ER diagram and normalization question:

Buyme! is an online company that sales hundreds of office supply products on its e-Commerce store. BuyMe! has asked you to design and implement a sales order processing system which will be used by users in our Operations department to process sales orders. Here is an overview of the sales order process. Customers order things from BuyMe! website. Each customer has a customer number and profile (such as name, shipping address). To simplify the matter, each time an order is placed, only one item is ordered. The company maintains hundreds of products at various warehouses throughout the United States. Each warehouse has a warehouse code, address and phone number. The compoany keeps track of products carried in various warehouses and their current inventory level.

You are asked to design a relational database (Entity Relationship Diagram and normalized tables) for this company.

1. ER Diagram

2. Third Normal Form tables

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

EyeGuard Equipment Inc. (EEI) manufactures protective eyewear for use in commercial and home applications. The product is also used by hunters, home woodworking hobbyists, and in other applications....

A large online retailer has set up a private web space to sell to its customers that are businesses. These transactions are generally conducted through negotiated contracts. How does the company use...

Could I get the cost of capital calculation (WACC) broken out in excel for Amazon based on FY2015 financials? \fTo our shareowners: This year, Amazon became the fastest company ever to reach $100...

Hi, I have areport due in nine hours. I need to find the following list of things on Amazon.com....

According to the article "FamilyMart:Internet Plus Strategy" provided below, please answer the following questions in detail: a. What is the best plan of action if FamilyMart is to engage in online...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

Please answer the below questions about Amazon . I have attached their 10-K which you should be able to find all this information. For each question, please write 2-3 paragraphs. If you use any other...

IFSM 300 Final Assessment Exam NOTE: As for all work in this class, the final exam must be original work developed by the student solely for use in this class and must conform to UMUC's academic...

Using the Annual Report of your selected company answer the following questions in the Discussion: What is the value of the company's inventory at year end? What was the amount of cost of goods sold...

\f\f\fChapter 2 Service Strategy Learning Objectives After completing this chapter, you should be able to: 1. Formulate a strategic service vision. 2. Describe how a service competes using the three...

Three camps were discussed for improving the Internet so that it better supports multimedia applications. Briefly summarize the views of each camp. In which camp do you belong?

Cost of common equity Percy Motors has a target capital structure of 40 percent debt and 60 percent common equity, with no preferred stock. The yield to maturity on the company's outstanding bonds is...

At a minimum, the human immune system is capable of recognizing approximately how many different antigens? 1 0 5 1 0 1 0 1 0 1 5 1 0 2 5 1 0 2 0

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

1. What decisions would a city manager at the preconventional level be expected to make?

3. What decisions would a city manager at the conventional level be expected to make?

1. Which position would you take?