Computers and Technology, 17.12.2019 04:31, lolyan555

Consider the relation refrig(model#, year, price, manuf_plant, color),which is abbreviated as refrig(m, y, p, mp, c), and the following set f of functional dependencies: f = {m ? mp,{m, y} ? p, mp ? c}
a. evaluate each of the following as a candidate key for refrig, giving reasons why it can or cannot be a key: {m}, {m, y}, {m, c}.
b. based on the above key determination, state whether the relation refrig is in 3nf and in bcnf, giving proper reasons.
c. consider the decomposition of refrig into d = {r1(m, y, p), r2(m, mp, c)}
1. is this decomposition lossless? show why.
2. is this decomposition has the dependency preservation property?

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 11:00, babbybronx

Lisa’s company, abc ltd., lost its biggest client and is now facing a financial crunch. most of her colleagues have resigned, but lisa decides to stay with the company and assist the management in overcoming the financial situation. which quality is lisa demonstrating? a. self-management b. cooperativeness c. responsibility d. loyalty

Answers: 2

continue

Computers and Technology, 22.06.2019 21:40, tdahna0403

Develop a function to create a document in the mongodb database “city” in the collection “inspections.” be sure it can handle error conditions gracefully. a. input -> argument to function will be set of key/value pairs in the data type acceptable to the mongodb driver insert api call b. return -> true if successful insert else false (require a screenshot)

Answers: 2

continue

Computers and Technology, 23.06.2019 11:00, abdulbasharee99

In the context of the box model, what is the difference between a margin and a padding? a. a padding lies outside a box border, while a margin lies inside it. b. a padding lies inside a box border, while a margin lies outside it. c. a padding can be adjusted independently, while a margin depends on the size of its box. d. a padding depends on the size of its box, while a margin can be adjusted independently.

Answers: 3

continue

Computers and Technology, 23.06.2019 22:40, azariah7

22. sata3 allows for data transfer rates of 600 mb/s. explain why you would likely not be able to copy data from one hard drive to another at anywhere close to this speed. also, what could be upgraded on the computer to achieve transfer speeds closer to 600 mb/s

Answers: 1

continue

Do you know the correct answer?

Consider the relation refrig(model#, year, price, manuf_plant, color),which is abbreviated as refrig...