Question 19 Keep Track Office Furniture Computers Printers Foundit Company Uses Following Q37279861

QUESTION 19

1. To keep track of office furniture, computers, printers, and soon the FOUNDIT company uses the following table structure:

ATTRIBUTE NAME

SAMPLE VALUE

SAMPLE VALUE

SAMPLE VALUE

ITEM_ID

231134-678

342245-225

244668-449

ITEM_DESCRIPTION

HP DeskJet 895Cse

HP Toner

DT Scanner

ROOM_NUMBER

325

325

123

BLDG_CODE

NTC

NTC

CSF

BLDG_NAME

Nottooclear

Nottooclear

Canseefar

BLDG_MANAGER

I.B. Rightonit

I.B.Righonit

May B. Next

2. Is the table in 2nd normal form? YesNo
3. Is the table in 3rd normal form? YesNo
4. Is BLDG_MANAGER transitively dependent on ITEM_ID? YesNo

QUESTION 17 1.