Long before the tables are created and data is moved or inserted into them, the database designer creates the logical and physical models of the database. In this application, you will examine the process of relational database design and modeling and understand and use normalization techniques to identify new tables, update business rules for a database, and  updated entity relationship diagrams.

Normalize the tables from the Week 2 Assignment, specifically, the tables identified within your Learning Resources.

Tasks:

1. Identify the new tables. (25 points)
2. Update the business rules for the database. (25 points)
3. Provide an updated ERD. (25 points)

1. 
    
    
    
    

Transcribed Image Text:

Part ID Part Units on Hand Class Warehouse Unit Description Number Price AX12 Iron 104 HW 3 24.95 AZ52 Dartboard 20 SW 2 12.95 BH22 Corn Popper 95 HW 3 24.95 BT04 Gas Grill 11 AP 2 149.99 BZ66 Washer 52 AP CA14 Griddle 78 HW 33 3 39.99 39.99 CB03 Bike 44 SG 1 299.99 CX11 Blender 112 HW 3 22.95 CZ81 Treadmill 68 SG 2 349.95 Part ID Part Units on Hand Class Warehouse Unit Description Number Price AX12 Iron 104 HW 3 24.95 AZ52 Dartboard 20 SW 2 12.95 BH22 Corn Popper 95 HW 3 24.95 BT04 Gas Grill 11 AP 2 149.99 BZ66 Washer 52 AP CA14 Griddle 78 HW 33 3 39.99 39.99 CB03 Bike 44 SG 1 299.99 CX11 Blender 112 HW 3 22.95 CZ81 Treadmill 68 SG 2 349.95