Evaluate each of the following as a candidate key for refrig

Assignment Help Basic Computer Science
Reference no: EM131053977

Consider the relation REFRIG(Model#, Year, Price, Manu 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)}. Is this decomposition lossless? Show why. (You may consult the test under Property NJB in Section 16.2.4.)

Reference no: EM131053977

Questions Cloud

Identify the possible causes for endometriosis : What are the most important things that you have learned from this scenario? What actions will you take into clinical practice as a result of your learning from this scenario?
Management wants to monitor the proportion : 1) A bank's savings account statements contain 24 items of account information. Last month, 2500 bank statements were checked and 52 errors were found in the account items. What is the dpmo value?
Calculate gross profit margin and operating profit margin : AC4410 ACCOUNTING AND FINANCE Coursework. The company chosen for this assignment is BT Group. Use the last 4 years financial statements to calculate the ratios. Gross profit margin, Operating/Net Profit margin and ROCE (rate of capital employed)
Example of a simple object model : Give an example of a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
Evaluate each of the following as a candidate key for refrig : 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 NJB in Section 16.2.4.)
Marketing vp leads a department of four managers : Doug is on the phone with the vice president of marketing, pitching to him the benefits of the new Web-based performance appraisal system that HR wants to implement throughout the company. "It will simplify things for you. More importantly, it wil..
How can we determine their equivalence : How can we determine their equivalence?
What normal form is the relation : If no multivalued attributes exist and no partial dependencies exist in a relation, what normal form is the relation?
Object oriented interface : Between ODBC, OLEDB, ADO and JPCD, which one is an object oriented interface that encapsulates data server functionality?

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Identifying and explaining how the breach occurred

Based on the Target Data Breach answer the following questions and use only information from authoritative or scholarly sources and list references. identifying the type of breach identifying and explaining how the breach occurred (or suspicions by a..

  Explaining it solutions to enhance workflows

The final method to include IT is not to go "looking for IT solutions" just for sake of using IT. But to have IT at the table to truly think about ways to develop workflows.

  Write an expression that divides distance

Given two integer variables distance and speed , write an expression that divides distance by speed using floating point arithmetic, i.e. a fractional result should be produced.

  Truth table validity of demorgan-s theorem for variables

Find out by means of truth table validity of DeMorgan's theorem for three variables: (ABC)' = A' + B' + C'. Simplify given expressions by using Boolean algebra.

  Explain the difference between computer hardware and softwar

Explain the difference between computer hardware and software? Why is the use of information systems in healthcare important? Explain your answer.

  Component interface for an emergency control room

As the lead software engineer for a medium-sized hospital, you have been asked to spearhead an effort to improve the tracking of Voice Over IP (VOIP) calls made within the hospital system.

  Excel independent projects

I have 10 excel independent projects .There all form the text " Microsof Office 2013 Excel : In Complete " I have all the info and the start files. Since they're relatively easy and less then a page on the majority of them. I have no knowledge wit..

  Was this project terminated through political means

Was this project terminated through "political" means?

  Left for the address part of the instruction

a. How many bits are needed for the opcode? b. How many bits are left for the address part of the instruction? c. What is the maximum allowable size for memory?

  Explain how non-volatile ram can help speed up disk writes

Since indexes speed up searches, why wouldn't the DBMS automatically create an index for every column of a table?

  Advantages and disadvantages of using software as a service

Discuss the fundamental advantages and disadvantages of using software as a service (SaaS) within organizations. Next, give your opinion as to why SaaS has become a common delivery model for many business applications.

  Write program that reads in two floating-point numbers

Write a program that reads in two floating-point numbers and tests whether they are the same up to two decimal places. Here are two sample runs. Enter two floating-point numbers

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd