Computers and Stuff, Inc.

Create an ERD for the following order detail report.  Identify and label all entities, attributes and relationships (with appropriate cardinality and modality).  List your assumptions.

COMPUTERS AND STUFF, INC.

ORDER DETAIL REPORT

 

Order No.:       123                                                      Order Date:  1/1/1999

Customer ID:    10                                                       Status:  closed

Customer Name:  DePaul University

 

Product ID

Product Description

Prod_type

Quantity

Unit Price

Total

Ship_date

PC500

Pentium II Processor, 300 Mhz clock

Hardware

5

$ 600

$ 3000

1/8/1999

PC933

P III processor, 933  Mhz clock

Hardware

1

$ 1800

$ 1800

2/10/1999

RAM16

16 Mb RAM chip

Memory

20

$ 80

$ 1600

2/12/1999

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

$ 6400

Grand Total