Question: Design a database diagram for a product orders database with four tables. Indicate the relationships between tables and identify the primary key and foreign key

Design a database diagram for a product orders database with four tables. Indicate the relationships between tables and identify the primary key and foreign key in each table. Explain your design decisions.

Customers (CustomerID, CustomerName, CustomerAddress, CustomerEmail, CustomerPhone)
Orders (OrderID, CustomerID, OrderDate, ShipDate, TotalPrice)
OrderItem (OrderID, ProductID, Quantity, UnitPrice)
Products (ProductID, ProductName, Price, InStock, OnOrder)

b) Add the three tables below into the design for part a, you can create additional tables and columns if necessary. Indicate the relationships between tables and identify the primary key and foreign key in each table. Explain your design decisions.

- Shipping (ShippingID, OrderID, ShipperName, ShipperPhone, Weight, ShippingDate, ShippingMedium, ShippingStatus)
- Employees (EmployeeID, SSN, FirstName, LastName, HireDate, Title, DepartmentID, HomeAddress, Phone, Email)
- Department (DepartmentID, DepartmentHead, DepartmentAddress)

Step by Step Solution

★★★★★

3.38 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Part A Initial Database Design In this initial design Ive created four tables Customers Orders OrderItem and Products Each table serves a specific purpose in managing product orders Below are the deta... View full answer

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!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original TAL...

On January 1, Chan & Chan, CPAS received a $15,000 cash retainer for accounting services to be rendered ratably over the next 3 months. The full amount was credited to the liability account Unearned...

Continue working on your Order database on the following queries using SQL statements. Copy and past 1) query question, 2) SQL statement and 3) SQL output to a word file, and print it out. 1. List...

Continue working on your Order database on the following queries using SQL statements. Copy and past 1) query question, 2) SQL statement and 3) SQL output to a word file, and print it out. 1....

[1] Consider the following table: Shipment. Shipment(ShipmentId, ProductId, Quantity, SourceCity, DestinationCity, Distance) ShipmentId is an unique identifier for a shipment of a quantity of a...

The Mesa Veterinary Hospital is run by Dr. Brigitte Roosevelt. She has two employees in the office and has asked you to develop a database to help better track her data. Dr. Roosevelt currently uses...

The normalization process was shown for just the BOOKS table. The other tables in the Just Lee Books database are shown after normalization. Because the database needs to contain data for each...

Which tables and fields would you access to determine which book titles have been purchased by a customer and when the order shipped? Figure 1-5: ORDERS Order# Customer# Orderdate Shipdate Shipstreet...

If management needed to determine which book category generated the most sales in April 2009, which tables and fields would they consult to derive this information? Figure 1-5: ORDERS Order#...

Under Raw interpretations of GPA Is p significant at less that .01, or greater than .01? Is this one tailed? I am struggling to understand: "strong positive correlation relationship and with a...

Assume that investor's care about the first four moments of the return distribution. Given the following information which investment would investors prefer? Stock A: Mean Return = 10%, Standard...

How is power divided between the Board of Directors, individual directors and shareholders? Why power is divided this way? Does this division of power create any issues? If so, for whom?

Consider the demand equation for University of Alberta hoodies p = -0.03x + 30.0 for 0 x 1000. This describes the relation between the hoodie price p in dollars and the amount of hoodies demanded....

25.0 m C B A 52.0 m 65.0 m

Explain the difference between traditional square of opposition and modern square of oppositions.

Year Manufacturing Overhead Activity Driver 1 Activity Driver 2 Activity Driver 3 2000 4,234,155 6,174 790 48,555 2001 1,402,088 2,942 339 42,947 2002 7,567,442 2,175 781 44,462 2003 4,068,697 5,326...

Determine by direct integration the values of x for the two volumes obtained by passing a vertical cutting plane through the given shape of Fig. 5.21. The cutting plane is parallel to the base of the...

Are you using any services offered in the cloud? If so, what service model is offered by your provider? If not, what are your primary reasons for not using services offered in the cloud?

When you are happy with the mission statement you have developed in response to the prior question, describe the objectives and competitive strategy for achieving that mission.

Consider the Is_married_to unary relationship in Figure 8.14c. a. Assume that we want to know the date on which a marriage occurred. Augment this E-R diagram to include a Date_married attribute. b....

Consider a $5000 face value Province of Quebec strip bond from the issue in Table 8.3 that matures on December 1, 2018. If the yield does not change as years go by, what will be the bonds value on:...

Boris recently turned 30, an event causing him to give thought to some long-range financial planning. He believes that, if he owns a home and is debt-free by age 60, he and his partner can retire and...

Wojtek purchased a $10,000 face value strip bond on a date when it had 14 years left until maturity. The purchase price was based on a market yield of 6.2% compounded semiannually. He sold the bond 4...