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 does Aggregation mean?

Although, the essential features of E-R diagrams are enough to design many database situations. Though, with more difficult relations and advanced database applications, it is need

What do you understand by a view? What does WITH CHECK OPTION clause for a view do? - A view is a virtual table which comprises fields from one or more real tables. - It is

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

Describe the development process of Object oriented methods Object oriented methods have roots which are strongly anchored back in the 60s, functional and structured methods we

With the help of a suitable diagram gives module wise explanation of system architecture of DBMS.on..

Physical Database Design Issues The database design includes the process of logical design with the use of E-R diagram, normalisation, etc., followed by the physical design.

Consider a table student (std_id, std_name, date_of_birth, percent_marks, dept_name). Write a QBE query to display names of Computer Science department students who have scored mo

Define the categories of SQL Statements? 1) Statements that don't return a result set. This statement class includes INSERT, DELETE, and UPDATE. 2)Statements that return

Explain the conventions for displaying an ER schema as an ER diagram? An E-R Diagram scheme might describe certain constraints to that the contents of a database must conform.