DATABASE ARCHITECTURE AND DESIGN

IT 8100 DATABASE ARCHITECTURE IT 8100 

 DATABASE ARCHITECTURE AND DESIGN

 Group Activity 1 “Whole Sale Food Market” Group Activity 

“Whole Sale Food Market”

3

Department Department Department

Product

Code Code

Aisle

Number Number

Price Price

Unit of Unit of Unit of Measure Measure

Produce Produce Produce

4081

1

0.35

lb

Produce Produce Produce

4027

1

0.90

ea

Produce Produce Produce

4108

1

1.99

lb

Butcher Butcher

331100

5

1.50

lb

Butcher Butcher

331105

5

2.40

lb

Butcher Butcher

332110

5

5.00

lb

Freezer Freezer

411100

6

1.00

ea

Freezer Freezer

521101

6

1.00

ea

Freezer Freezer

866503

6

5.00

ea

Freezer Freezer

866504

6

5.00

ea

Whole Sale Food Market Whole Sale Food Market Whole Sale Food Market Whole Sale Food Market Whole Sale Food MarketWhole Sale Food Market Whole Sale Food Market

User View 1 User View 1 User View 1 User View 1 User View 1 User View 1 User View 1 -Price Update List Price Update List Price Update List Price Update List

5

Normalize User Views and Create a Final 3NF Normalize User Views and Create a Final 3NF Normalize User Views and Create a Final 3NF Normalize User Views and Create a Final 3NF Normalize User Views and Create a Final 3NF Normalize User Views and Create a Final 3NF Normalize User Views and Create a Final 3NF solution

UNF

1NF

2NF

3NF

CHALLENGES CHALLENGES

Group Activity 1 “Whole Sale Food Market” Group Activity 1 “Whole Sale Food Market” Group Activity 1 “Whole Sale Food Market” Group Activity 1 “Whole Sale Food Market” Group Activity 1 “Whole Sale Food Market” Group Activity 1 “Whole Sale Food Market” Group Activity 1 “Whole Sale Food Market” Group Activity 1 “Whole Sale Food Market” Group Activity 1 “Whole Sale Food Market” Group Activity 1 “Whole Sale Food Market” Group Activity 1 “Whole Sale Food Market”