(Solved): a. Given that information, draw the dependency diagram. Make sure that you label the transitive and/ ...

a. Given that information, draw the dependency diagram. Make sure that you label the transitive and/or partial dependencies. 5 Marks b. Modify the dependency diagrams that meet 3NF requirements. Rename attributes to meet the naming conventions, and create new entities and attributes as necessary. 5 Marks c. Draw the Crow's Foot ERD. 5 Marks To keep track of office furniture, computers, printers, and so on, the CSU DIT uses the table structure shown in Table 1. Please note that BLDG stands for building. Table 1 Sample ITEM Records Attribute Name Sample Sample Sample Value Value Value ITEM_ID 231134-678 342245-254668 225 449 HP DeskJet HP Toner DT 895Cse ITEM LABEL Scanner 123 CSF ROOM NUMBER 325 325 LDG CODE BLDG NAME BLDG MANAGER I. B. NTC NTC Nottooclear Nottoclear Canseefa May B. 1. ? RightonitRightonit Next Show transcribed image text a. Given that information, draw the dependency diagram. Make sure that you label the transitive and/or partial dependencies. 5 Marks b. Modify the dependency diagrams that meet 3NF requirements. Rename attributes to meet the naming conventions, and create new entities and attributes as necessary. 5 Marks c. Draw the Crow's Foot ERD. 5 Marks
To keep track of office furniture, computers, printers, and so on, the CSU DIT uses the table structure shown in Table 1. Please note that BLDG stands for building. Table 1 Sample ITEM Records Attribute Name Sample Sample Sample Value Value Value ITEM_ID 231134-678 342245-254668 225 449 HP DeskJet HP Toner DT 895Cse ITEM LABEL Scanner 123 CSF ROOM NUMBER 325 325 LDG CODE BLDG NAME BLDG MANAGER I. B. NTC NTC Nottooclear Nottoclear Canseefa May B. 1. ? RightonitRightonit Next