Question: Consider the relation REFRIG(MODEL#, YEAR, PRICE, MANUF_PLANT, COLOR), which is abbreviated as REFRIG(M, Y, P, MP, C), and the following set of F of functional

Consider the relation REFRIG(MODEL#, YEAR, PRICE, MANUF_PLANT, COLOR), which is abbreviated as REFRIG(M, Y, P, MP, C), and the following set of 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)}. Is this decomposition lossless? Show why. (You may consult the test under Property LJ1 in Section 15.2.4)

Step by Step Solution

★★★★★

3.34 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

b M IS NOT a candidate key since it does not functionally determine attributes Y or P M Y IS a candi... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

888-CS-DB (2366).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Consider the relation R, which has attributes that hold schedules of courses and sections at a university; R = {CourseNo, SecNo, OfferingDept, CreditHours, CourseLevel, InstructorSSN, Semester, Year,...

Consider the instance of the relation SHIRT (Shirt#, Color, Size) where Shirt# is equivalent to a style number (e.g., style number 341 might be a shirt with a button-down collar while style number...

Consider the universal relation R = {A, B, C, D, E, F, G, H, I} and the set of functional dependencies F = { {A, B} -> {C}, {A} -> {D, E}, {B} -> {F}, {F} -> {G, H}, {D} -> {I, J} }. What is the key...

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: , Y Find the...

Problem 1 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,...

(5 pts) Consider the universal relation R = {A, B, C, D, E, F, G, H, I, J} and the set of functional dependencies F = {{A,B}{C}, {A}{D,E}, {B}{F}, {F}{G,H}, {D}{I,J}}. What is the key for R?...

Consider the relation R(MODEL#, YEAR, PRICE, MANUFACTURER, COLOR), which is abbreviated as R (M, Y, P, N, C), and the following set of F of functional dependencies: F={M -> N, {M,Y} -> P, N -> C}...

(5pt) Consider the relation R(MODEL#, YEAR, PRICE, MANUFACTURER, COLOR), which is abbreviated as R (M, Y, P, N, C), and the following set of F of functional dependencies: F-M->N, MY] > P, N > C) a....

URN 09/1026 DIGITAL BRITAIN Final Report JUNE 2009 DIGITAL BRITAIN - Final Report Published by TSO (The Stationery Office) and available from: Online www.tsoshop.co.uk Mail,Telephone, Fax & E-Mail...

At the beginning of the year, Anna began a calendar-year business and placed in service the following assets during the year: Date Acquired 1/30 Cost Asset Basis $ 58,000 $ 62,000 $ 105,000 $ 440,000...

Bargain Department Stores, Inc., is a chain of department stores in the Midwest. Quarterly sales of the "Bargain 8(KK)-Btu Air Conditioner" over the past three years are as given in the left hand...

What factors might signal the likelihood that goodwill may be impaired? Explain and indicate how the auditor would be aware of each of these factors.

The weights of 5 people before they stopped smoking and 5 weeks after they stopped smoking, in kilograms, are as follows Use the signed-rank test for paired observations to test the hypothesis, at...

While visiting Haifa, Sid Resnick discovered that people who wish to travel from the port area up the mountain frequently take a shared taxi known as a sherut. The capacity of each car is five...

Discuss the different types of failures. What is meant by catastrophic failure?

Draw a state diagram and discuss the typical states that a transaction goes through during execution.

What is the system log used for? What are the typical kinds of records in a system log? What are transaction commit points, and why are they important?

Exercise Problems #2, #3, & #4 will use relations similar to those in our semester project. Here are each of the relations for this homework: Stores( store id: integer, name: String, address: string)...

Score: 0 of 1 pt 6 of 7 (5 complete) HW Score: 44.64%, 3.13 of 7 pts Ja Next Question P18-17 (similar to) Question Help FE Operating exposure. Copy-Cat, Inc. has signed a deal to make vintage Nissan...

Esfandairi Enterprises is considering a new three - year expansion project that requires an initial fixed asset investment of $ 2 , 3 0 0 , 0 0 0 . The fixed asset will be depreciated straight - line...