Normalisation questions & Answers

Normalisation questions & Answers - Normalisation...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Normalisation questions. 1. To keep track of office furniture, computers, printers, and so on, the FOUNDIT company uses the table structure shown in the below table: Attribute Name ITEM_ID ITEM_LABEL ROOM_NUMBER BLDG_CODE BLDG_NAME BLDG_MANAGER a) b) Sample Value 231134-678 HP DeskJet 895Cse 325 NTC Nottooclear I. B. Rightonit Sample Value 342245-225 HP Toner 325 NTC Nottoclear I. B. Rightonit Sample Value 254668-449 DT Scanner 123 CSF Canseefar May B. Next Given this information, draw the dependency diagram. Make sure you identify the primary key and label the transitive and/or partial dependencies. (5 marks) Then from the dependency diagram drawn, create a set of dependency diagrams that meet 3NF requirements. (5 marks) Solution ANSWER a. Problem 8 Solution ITEM_ID ITEM_DESCRIPTION BLDG_ROOM BLDG_CODE BLDG_NAME BLDG_MANAGER Transitive Dependencies (See discussion in the IM text). Problem 9 Solution: All tables in 3NF ITEM_ID ITEM_DESCRIPTION BLDG_ROOM BLDG_CODE BLDG_CODE BLDG_NAME EMP_CODE EMP_CODE EMP_LNAME EMP_FNAME EMP_INITIAL b. Problem 8 Solution ITEM_ID ITEM_DESCRIPTION BLDG_ROOM BLDG_CODE BLDG_NAME BLDG_MANAGER Transitive Dependencies (See discussion in the IM text). Problem 9 Solution: All tables in 3NF ITEM_ID ITEM_DESCRIPTION BLDG_ROOM BLDG_CODE BLDG_CODE BLDG_NAME EMP_CODE EMP_CODE EMP_LNAME EMP_FNAME EMP_INITIAL ...
View Full Document

This note was uploaded on 02/15/2010 for the course MIT 424 taught by Professor Cevenini during the Three '10 term at Charles Sturt University.

Ask a homework question - tutors are online