find a non-redundant cover and canonical cove, Database Management System

Given the following set of functional dependencies {cf→bg, gd, cdgf, bde, dc} defined on R(b,c,d,e,f,g)

a. Is cf→e implied by the FDs?

b. Is dg a superkey?

c. Is dg a candidate key?

d. Find a non-redundant cover.

e. Find a canonical cover.

f. What are the candidate keys?


Posted Date: 4/6/2013 3:05:49 AM | Location : United States

Related Discussions:- find a non-redundant cover and canonical cove, Assignment Help, Ask Question on find a non-redundant cover and canonical cove, Get Answer, Expert's Help, find a non-redundant cover and canonical cove Discussions

Write discussion on find a non-redundant cover and canonical cove
Your posts are moderated
Related Questions
Explain Dynamic Two-Phase Locking Here a transaction locks a data item instantly earlier than any operation is applied on the data item.  After finishing all the operations on

What is Derived and stored Attribute? Derived and Stored Attribute - In a few cases, two or more attribute values are associated, for example, Age and BirthDate attributes of a

Describe Hashing in DBMS? Hashing: Hashing is a technique to store data within an array so which storing, searching, inserting and deleting data is fast (in theory it's O(1))

Define the term- Actors and Data Stores Actors: An actor is the active object which drives data flow graph by producing or consuming values. Actors are attached to inputs a

What is the error handling Traditionally, bits have been sent over line lacking any error correcting scheme in physical layer. The presence of the CPU in each modem makes it po

What is trigger Triggers are statements that are implemented automatically by the system as the side effect of a change to the database.

List two restrictions that are applied on the modification (updation, insertion or deletion) of base tables through view.  Ans: The two restrictions are: 1. If a view

What is the use of keyword ISA? The use of keyword ISA is to show that a class is a specialization of another class.

Example- Search the salary of employees who are not 'ANALYST' but get a salary below than or equal to any people employed as 'ANALYST'. SELECT EMPNO, ENAME, JOB, SAL FROMEMP

Differentiate between Key and superkey? Key and superkey - A key a single attribute or a combination of two or more attributes of an entity set in which is used to identify o