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
Consider student (std_id, std_name, date_of_birth, phone, dept_name). Put the data for a student with student id200, name arun, birth date 1 February, 1985, phone number (01110 328

Though all the ABAP/4 Dictionary Structures that exists in the structure of the LDB, being described in Database Program, we are explaining the Dictionary Structures in the Report.

Concurrency issues Data integrity: Threads accessing same object need to be synchronized, such as: banking account. Deadlock: One or more threads in system are perman

Explain the Query Processing  Data Query Processing permits a user to report or analyze structured and unstructured data pulled from multiple data sources.

What is a shadow copy scheme? It is simple, but efficient, scheme known as the shadow copy schemes. It is based on making copies of the database called shadow copies that singl

What are the uses of ODBC? Under what circumstances we use this technology? ODBC expose database capabilities within a standardized way to the application programmer by an ap

Describe a technique for direct search? Explain how data is stored within a file so which direct searching can be performed. For a file of unordered fixed length records by u

Data Control The data control mostly refers to commands that permit system and data privileges to be passed to several users. These commands are usually available to database admi

I have a homework assignment due today by midnight. I need help understanding databasse normalization and determining the type of form violation & how to fix the violation.

Define granularity, hierarchy of granularity of locks & multiple granularity locking. Explain the modified two phase locking along with multiple granularity locking. Ans: The s