What is the candidate key for a table with columns, Database Management System

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







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
Related Questions
What are the benefits of prepared statements and place holders? Parameter binding operations automatically handle escaping of characters Encourage Statement reuse

Describe how you can simplify Operations. To simplify operation, one should use inheritance, where possible to use, to reduce the quantity of distinct operations. Introduce new

How much would you charge to create a database encompassing an Online Bakery with all the elements below? I. Describe the application that you would like to design. This should

Consider the following database schema: STAFF(StaffNo, fName, lName, Position, sex, dob, branchNo) BRANCH(BranchNo, Street, City) Assume the following for the above database

What is Oracle Process? Explain any four processes started by Oracle. Oracle Process is as follows: SMON: The System Monitor carries out a crash recovery while a crashed in

Database Recovery And Security Introduction In this part we will introduce two main issues relating to database management systems. A computer system suffers from dissi

what is attribute is attribute inheritance in dbms?

Differentiate between natural join and outer join? Natural join is a binary operator which is written as (R * S) where as R and S are relations. The output of the natural join

Explain trivial dependency? Functional dependency of the form α ->β. is trivial if α C β. Trivial functional dependencies are satisfied by all the relations.

want a idea for final year project