[Solved]-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. Two questions require you to download the Dominos MySQL dump (link in Quiz assessment folder) and import it into MySQL How many tuples does the Cartesian product of the ORDER and ORDERCONTENTS table return? С 13 4. 8 C 40 QUESTION 18 Subject CreditPts Semester Enrollment Lecturer CS100 CS102 CS114 CS115 CS383 CS383 500 500 300 270 50 45 DBJ EJS TAH TAH RMC PNC 2 2 16 16 2 Is Subject, Semester a candidate key? Is Subject, CreditPts a candidate key Show transcribed image text QUESTION 17 1. Two questions require you to download the Dominos MySQL dump (link in Quiz assessment folder) and import it into MySQL How many tuples does the Cartesian product of the ORDER and ORDERCONTENTS table return? С 13 4. 8 C 40
QUESTION 18 Subject CreditPts Semester Enrollment Lecturer CS100 CS102 CS114 CS115 CS383 CS383 500 500 300 270 50 45 DBJ EJS TAH TAH RMC PNC 2 2 16 16 2 Is Subject, Semester a candidate key? Is Subject, CreditPts a candidate key

Expert Answer

---

Answer to QUESTION 19 To keep track of office furniture, computers, printers, and so on the FOUNDIT company uses the following ta… . . .