fx ITEM: A 31 32 33 34 24 Order Detail 25 26 27 28 29 item number part number unit price total quantity 30 Delivery Schedule delivery number location number quantity due date 35 36 Part 37 part number 38 39 40 41 42 standard price Customer-Part Relationship customer number part number 43 special price B C D 1 2 3 ITEM: 4 5 6 7 Customer Header customer number buyer name bill-to address 8 buyer phone 9 buyer email 10 credit rating 11 12 Customer Shipping 13 14 N location number receiver name 15 receiver phone 16 receiver email 17 ship-to address 18 19 Order Header 20 20 order number 21 22 E order date shipment method ORDER MANAGEMENT Entity-Relationship D

Understanding Business
12th Edition
ISBN:9781259929434
Author:William Nickels
Publisher:William Nickels
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
icon
Related questions
Question

Design a normalized order management database with the requirements provided below. 


Each record should have at least one primary key field specified. After identifying the records and their corresponding fields, draw an entity-relationship (ER) diagram to illustrate the relationships between entities and attributes.

 

fx ITEM:
A
31
32
33
34
24 Order Detail
25
26
27
28
29
item number
part number
unit price
total quantity
30 Delivery Schedule
delivery number
location number
quantity
due date
35
36
Part
37
part number
38
39
40
41
42
standard price
Customer-Part Relationship
customer number
part number
43
special price
B
C
D
Transcribed Image Text:fx ITEM: A 31 32 33 34 24 Order Detail 25 26 27 28 29 item number part number unit price total quantity 30 Delivery Schedule delivery number location number quantity due date 35 36 Part 37 part number 38 39 40 41 42 standard price Customer-Part Relationship customer number part number 43 special price B C D
1
2
3
ITEM:
4
5
6
7
Customer Header
customer number
buyer name
bill-to address
8
buyer phone
9
buyer email
10
credit rating
11
12 Customer Shipping
13
14
N
location number
receiver name
15
receiver phone
16
receiver email
17
ship-to address
18
19
Order Header
20
20
order number
21
22
E
order date
shipment method
ORDER MANAGEMENT
Entity-Relationship
D
Transcribed Image Text:1 2 3 ITEM: 4 5 6 7 Customer Header customer number buyer name bill-to address 8 buyer phone 9 buyer email 10 credit rating 11 12 Customer Shipping 13 14 N location number receiver name 15 receiver phone 16 receiver email 17 ship-to address 18 19 Order Header 20 20 order number 21 22 E order date shipment method ORDER MANAGEMENT Entity-Relationship D
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Understanding Business
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON
Business Essentials (12th Edition) (What's New in…
Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON