Attribute Name ITEM_ID ITEM LABEL ROOM NUMBER BLDG MANAGER EMP_CODE EMP LNAME EMP FNAME BLDG NAME...

 

Transcribed Image Text:

Attribute Name ITEM_ID ITEM LABEL ROOM NUMBER BLDG MANAGER EMP_CODE EMP LNAME EMP FNAME BLDG NAME EMP_INITIAL BLDG_CODE Sample Value 231134-678 HP DeskJet 895℃se 325 I. B. Rightonit 124574 Sneed Kyle Nottooclear K NTC Sample Value 342245-225 HP Toner 325 I. B. Rightonit 124574 Sneed Kyle Nottooclear K NTC Sample Value 254668-449 DT Scanner 123 May B. Next 168570 Lou Cindy Canseefar M CSF Identify the dependencies for the 2 and 3rd normalization in a dependencies diagram (table with lines). Solve for normalization by creating the entities (in tables like we did on problem set 2). Currently the ITEM_ID is the primary key (hint: you will have 3 entities after you normalize it). Rename the attributes appropriately according to the entities you have put them in. ** For instance if you put the ROOM_NUMBER in the ITEM table, you would name it ITEM_ROOM. • Create an ERD with the relationships, primary keys and foreign keys after you normalize it. Attribute Name ITEM_ID ITEM LABEL ROOM NUMBER BLDG MANAGER EMP_CODE EMP LNAME EMP FNAME BLDG NAME EMP_INITIAL BLDG_CODE Sample Value 231134-678 HP DeskJet 895℃se 325 I. B. Rightonit 124574 Sneed Kyle Nottooclear K NTC Sample Value 342245-225 HP Toner 325 I. B. Rightonit 124574 Sneed Kyle Nottooclear K NTC Sample Value 254668-449 DT Scanner 123 May B. Next 168570 Lou Cindy Canseefar M CSF Identify the dependencies for the 2 and 3rd normalization in a dependencies diagram (table with lines). Solve for normalization by creating the entities (in tables like we did on problem set 2). Currently the ITEM_ID is the primary key (hint: you will have 3 entities after you normalize it). Rename the attributes appropriately according to the entities you have put them in. ** For instance if you put the ROOM_NUMBER in the ITEM table, you would name it ITEM_ROOM. • Create an ERD with the relationships, primary keys and foreign keys after you normalize it.