# Create a conceptual data model, using crow�s foot notation for ... - DOC

Document Sample

```					DES715 In Class Exercise

Exercise 1

Given the following overview and sample report, create a normalized table structure by drawing
the dependency diagram and showing the tables through 1NF, 2NF and 3NF.

Order Detail Report

Order    Order       Cust     Cust         Part   Part         Qty     List
Number   Date        Number   Last         Number Desc         Ordered Price
Name

12489   2001-09-02   124     Adams           AX12   Iron          11    14.95
12491   2001-09-02   311     Charles         BT04   GasGrill       3   149.99
BZ66   Washer         1   399.99
12494   2001-09-04   315     Daniels         CB03   Bike           4   279.99
12495   2001-09-04   256     Samuels         CX11   Blender        2    22.95
12498   2001-09-05   522     Nelson          AZ52   Dartboard      2    12.95
12500   2001-09-05   124     Adams           BT04   GasGrill       1   149.99
12504   2001-09-05   522     Nelson          CZ81   Treadmill      2   325.99

Primary Key: ORDER_NUM & PART_NUM

1NF                 2NF               3NF
Dependency Diagram:

ORDER_NUM

ORDER_DATE

CUST_NUM

CUST_LNAME

PART_NUM

PART_DESC

QTY_ORDERED

LIST_PRI CE
DES715 In Class Exercise

1NF:

ORDER_PART (ORDER_NUM (PK), PART_NUM(PK), ORDER_DATE, CUST_NUM,
CUST_LNAME, PART_DESC, QTY_ORD, LIST_PRICE)

2NF:

ORDER (ORDER_NUM (PK), ORDER_DATE, CUST_NUM, CUST_LNAME)

PART (PART_NUM (PK), PART_DESC, LIST_PRICE)

ORDER_PART (ORDER_NUM (PK, FK), PART_NUM(PK, FK), QTY_ORD)

3NF

CUSTOMER (CUST_NUM (PK), CUST_LNAME)

ORDER (ORDER_NUM (PK), ORDER_DATE, CUST_NUM (FK))

PART (PART_NUM (PK), PART_DESC, LIST_PRICE)

ORDER_PART (ORDER_NUM (PK, FK), PART_NUM(PK, FK),
QTY_ORD)

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 9 posted: 9/15/2012 language: English pages: 2
How are you planning on using Docstoc?