(Solved) : Keep Track Office Furniture Computers Printers Csu Dit Uses Table Structure Shown Table 1 Q34228463 . . . .

To keep track of office furniture, computers, printers,and so on, the CSU DIT uses the table structure shown in Table1.

Please note that BLDG stands for building.

Table 1 Sample ITEM Records

Attribute Name

Sample Value

Sample Value

Sample Value

ITEM_ID

231134-678

342245-225

254668-449

ITEM_LABEL

HP DeskJet 895Cse

HP Toner

DT Scanner

ROOM_NUMBER

325

325

123

BLDG_CODE

NTC

NTC

CSF

BLDG_NAME

Nottooclear

Nottoclear

Canseefar

BLDG_MANAGER

I. B. Rightonit

I. B. Rightonit

May B. Next

a. Given that information, draw the dependency diagram.Make sure that you label the transitive and/or partialdependencies. 5 Marks

b. Modify the dependencydiagrams that meet 3NF requirements. Rename attributes to meet thenaming conventions, and create new entities and attributes asnecessary. 5Marks

c. Draw the Crow’s Foot ERD.   5 Marks

Please rename attributes to meet the naming conventionsand create new entities in