homeworkstudyhelp

Our Services

Get 15% Discount on your First Order

Q1.  The following figure shows a shipping ticket sent to a…

Q1.  The following figure shows a shipping ticket sent to a customer. Draw an ERD reflecting the data contained in the shipping ticket.

 

 

 

Note:
(1) The ERD must have Customer (Customer ID as the PK), Manufacturer (Manufacturer Name as
the PK), SalesOrder, Product, and many other entities.
(2) Assume that there is only one customer and one sales manager for each order.
(3) No need to create a Recipient entity; recipient information must be attributes of SalesOrder.
(4) The database must include the unit price change history of products. (Hint: Create a ProductPrice entity to record all prices of products)

The ERD must include not only entities and relationships with cardinalities but also all attributes.
Underline the primary key. There must be no many-to-many relationships and no multi-valued
attributes. Enter all foreign keys in the ERD.

Q2. Convert the ERD you created in Q1 into a relational database schema. 

Show all steps and primary keys

 

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

(a) Describe the concept of diminishing marginal returns. (b)…

(a) Describe the concept of diminishing marginal returns. (b) Present a hypothetical table and identify the point of diminishing marginal returns. (c) Describe one real life example of the concept of diminishing marginal returns. Remember to include at least two academic references

What is opportunity cost?  What does a production possibility…

What is opportunity cost?  What does a production possibility model tell us? (The Production Possibilities Curve (PPC) is a model used to show the tradeoffs associated with allocating resources between the production of two goods. The PPC can be used to illustrate the concepts of scarcity, opportunity cost, efficiency, inefficiency,

Thesis Statement: obesity   Body Paragraph 1 Topic Sentence: [type…

Thesis Statement: obesity   Body Paragraph 1 Topic Sentence: [type your topic sentence here] Supporting Point Sentence: [type your logic/reasoning sentence here] Supporting Support Example Sentence: [type an example that supports the logic/reasoning sentence here]   Body Paragraph 2: Topic Sentence: [type your topic sentence here] Supporting Point Sentence: [type