Consider the following six relation schemes and their corresponding sets of functional dependencies. In each case identify

a. All the candidate keys

b. The highest normal form of the relation (2NF, 3NF, BCNF).

R1 (W, X, Y, Z) XY→Z, Y→ W

R2 (K,L,M,N) KL→N, K→M

R3 (P,Q,R,S) P→Q, Q→R, R→S

R4 (T,U,V) T→U, U→T, T→V

R5 (W,X,Y,Z) Z→W, YZ→W, WY→XZ

R6 (A,B,C,D) AB→D, AC→D

 

Posted Date: 4/6/2013 3:06:41 AM | Location : United States

Ask an Expert

Related Discussions:- Identify the candidate keys, Assignment Help, Ask Question on Identify the candidate keys, Get Answer, Expert's Help, Identify the candidate keys Discussions

Write discussion on Identify the candidate keys
Your posts are moderated

Write your message here..

Related Questions

Types of attributes, Attributes attached to an entity can be of various typ... Attributes attached to an entity can be of various types. Simple The attribute that cannot be further separated into smaller parts and shows the basic meaning is known as a

Describe dynamic model, Describe Dynamic Model. The dynamic model speci... Describe Dynamic Model. The dynamic model specifies allowable sequences of changes to the objects from an object model. It contains event trace diagrams describing scenarios. A

Produce a set of relations - normalisation, Produce a set of relations (equ... Produce a set of relations (equivalent to the Finkelstein entity list) in third normal form (3NF) from the following un-normalised relation. You must use the Finkelstein methodolog

What is a database graph, What is a database graph? The partial orderin... What is a database graph? The partial ordering implies that the set D may now be viewed as a directed acyclic graph, known as a database graph.

Structure of the ldb, Though all the ABAP/4 Dictionary Structures that exis... 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.

Command line interfaces, Command Line Interfaces: These are interactive int... Command Line Interfaces: These are interactive interfaces, character-based that let you use the complete power and functionality of the DBMS query language directly. They permit yo

Compute the closure set, Compute the closure (F+) for the following set of ... Compute the closure (F+) for the following set of the functional dependencies defined on R(a,b,c,d), where F - {c→ a, ab → d, a → b, d → c}, i.e. what are all of the FDs implied b

Define the concept of design documentation, Design Documentation  The ... Design Documentation  The Design Document shall be an extension of Requirements Analysis Design. "The Design Document will comprise a revised and much more detailed descrip

Differentiate sub-class and super-class, Differentiate sub-class and super-... Differentiate sub-class and super-class? The specialization of a class is known as subclasses.eg: employee is a subclass of person and teller is a subclass of employee. Convers

What is called remapping of bad sectors, What is called remapping of bad se... What is called remapping of bad sectors? If the controller detects that a sector is injured when the disk is initially formatted, or when an attempt is made to write the secto