tags:

views:

43

answers:

1
Q: 

What will be the candidate key and why? Please refer question

Consider a relation R(ABCDEG)

The functional dependencies are given below: AB->C AC->B AD->E B->D C->A E->G Determine the candidate key(s) for the relation R.

Options: A. AB, AC and C B. AB and AC C. AB and C D. C only

A: 

Towards the bottom of this page: http://en.wikipedia.org/wiki/Relational_model There is an algorithm that will give you the answer.

Nick Orton  2010-09-19 03:27:18

related questions

What would be the simplest way to alpha sort an array of chars in C?
Failed software development
When does ++ not produce the same results as +1?
Shortest Root to Leaf Path
Repository Pattern Implementation Experience
Algorithm to detect similar documents in python script
Separation of Concerns
Creating a java servlet web application
How do you solve the 15-puzzle with A-Star or Dijkstra's Algorithm?
Algorithm to find which numbers from a list of size n sum to another number
software Engineering documentation
What is round-robin scheduling?
What is a multitasking operating system?
How do I clip a line segment against a frustum?
How do I capitalize first letter of first name and last name in C#?
Why is quicksort better than mergesort?
Hidden Markov Models
Using Stack as Queue
Database design for a booking application e.g. hotel
What is a good algorithm for deciding whether a passed in amount can be built additively from a set of numbers?
How to identify specific digits of an integer input in C?
Interesting interview questions
Print Odd-Even numbers using signals
What is the best way to learn recursion?
Are foreign keys really necessary in a database design?