For problems 1-4, give all candidate keys for the tables with FDs specified.  Composite candidate keys must be put in parentheses, and candidate keys must be separated with commas or otherwise clearly specified.  For example, "A, B, C"  means that there are three candidate keys, but "(ABC)" means that there is one composite candidate key and "(ABC), E" means that there are two candidate keys, the composite of three colums (A B C) plus the single column E.  Please be very specific for full credit. 

1. What is (are) the candidate key(s) for a table with columns
                        A B C D E F G H I J
            and the following set of functional dependencies? 

A B → J

D → B

J→ C E F G H I

2. What is (are) the candidate key(s) for a table with columns
                        L M N O P Q
and the following set of functional dependencies? 

L→ M N

O → L P Q

3. What is (are) the candidate key(s) for a table with columns
                        A B C D E F G H I
  and the following set of functional dependencies? 

A → C D E F

E→G H I

6.What is (are) the candidate key(s) for a table with columns
                        M N O P Q R S T U
and the following set of functional dependencies? 

M →N O P

O P →M

N → Q R S T

Posted Date: 3/29/2013 2:18:09 AM | Location : United States

Ask an Expert

Related Discussions:- What is the candidate key for a table with columns, Assignment Help, Ask Question on What is the candidate key for a table with columns, Get Answer, Expert's Help, What is the candidate key for a table with columns Discussions

Write discussion on What is the candidate key for a table with columns
Your posts are moderated

Write your message here..

Related Questions

What are the functions of an accumulator, What are the functions of an accu... What are the functions of an accumulator? The accumulator is the register associated with the ALU operations and sometimes I/O operations. It is an integral part of ALU. It hol

What are the kinds of strings, What are the kinds of Strings?  -A binar... What are the kinds of Strings?  -A binary string in MySQL is one that MySQL treats as case sensitive in comparisons. -A non binary string in MySQL is one that MySQL does'nt

Database Management System, Assume that you are responsible for selecting a... Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

What is the meaning of redundant associations, Adding Redundant Association... Adding Redundant Associations for Efficient Access The expression redundant association means using "duplicate association for proficient access". While analysis, it is not a

Develop a fragment of a hypothetical system, The objectives of this assignm... The objectives of this assignment are:  - to develop skills in the design of database driven applications  - to develop skills in applying SQL to implement the relational and

Differance between unordered and ordered file, Differance between Unordered... Differance between Unordered and ordered file ? Unordered file do no has any sequence although ordered file has arranged in a few sequence and data are assigned in ordered form

Windows 8 Administrative Tools, Which two tools are used to administer user... Which two tools are used to administer users for Active Directory?

The natural join is equal to which product, The natural join is equal to wh... The natural join is equal to which product? The natural join is equal to Combination of projection and Cartesian product

State the terms designing the database and normalization, State the terms D... State the terms Designing the database and Normalization Designing the database: Out of the ERD we have formed, it is very easy to verify the tables, the attributes which the

Normalization database, I need some help with my normalization database hom... I need some help with my normalization database homework.