1. Engineering
  2. Computer Science
  3. t keep track of office furniture computers printers and so...

Question: t keep track of office furniture computers printers and so...

Question details

TỔ 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 SampleSample Value Value Value ITEM_ID 231134-678 342245- 254668- 449 225 HP DeskJetHP Toner 895Cse ITEM_LABEL DT Scanner 123 ROOM NUMBER 325 BLDG_CODE BLDG NAME BLDG MANAGER I. B. 325 NTC NTC CSF Nottooclear Nottoclear Canseefar May B. Rightonit Rightonit Next 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 Crows Foot ERD. 5 Marks

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution