1NF: The key Normalization to the first normal form (1NF) involves:

1. Looking at the sample records to find the primary key. We have already assigned a PK in the prior step.

2. Looking at the sample records to find any repeating groups. 3.

Typing the updated relational schemas (or drawing the updated dependency diagram(s)). 2NF The Whole key: Normalization to the first second form

(2NF) involves: 1. Being in 1NF.

2. Removing any partial dependencies. Update any relational schemas or dependency diagrams.

3NF Nothing but the key: Normalization to the third normal form (3NF) involves: 1. Being in 2NF. 2. Containing no transitive dependencies. Update any relational schemas or dependency diagrams.

NEEDS TO BE WRITTEN OUT RELATIONAL SCHEMAS

Watson Wearables, Inc. needs to keep track of their office and computer inventory in order to reduce costs, manage reorder points, and better track item locations within their facilities. They need to track which buildings contain what products and be able to contact the manager of each building to verify inventory and reorder products, when necessary. The New Technology Center (NTC) is a building managed by Connor B. Johnson, while the Candice Simms Foundation (CSF) Building is managed by Mary B. Carter. Each manager has access to the building phone number of the building he or she manages. NTC has a phone number of (555) 637-9192. CSF has a phone number of (555) 637-9045. Currently, one of the administrative assistants keeps track of office furniture, computers, servers, printers, scanners, printer toner, etc. using a simple spreadsheet. It looks something like this, with just a sample of five of the items tracked: Item Item Building Room Vendor Vendor Total Item Quantity Item Quantity on Number Name Number(s) ID Name on Hand Order 231134-678 HP Deskjet New Technology 325, 100 555 Sam's Supply 20 (10 in each 0 895 Cse Center Store room) 342245-225 HP Toner New Technology 325 555 Sam's Supply 12 Center Store 254668-449 DT Scanner Candice Simms 123 456 John's 18 Foundation Warehouse Building 254678-449 DT Hard Candice Simms 100 987 Electronic Drive Foundation Depot, Inc. Building 254278-450 DT 400 New Technology 100 987 Electronic 2 Cable Center Depot, Inc. 2 5 4 2 1 In this project, your goal is to replace the spreadsheet solution currently used by the administrative assistant with a relational database