DBMS_RELATION MODEL_CANDIDATE,SUPER KEY_NORMAL FORMS

Enter Name of Correspondence Set, Page Number, Question Number, Your Name and Roll Number for Query!

Moderator: CS Moderators Team

DBMS_RELATION MODEL_CANDIDATE,SUPER KEY_NORMAL FORMS

Postby prajakta » Thu Jun 13, 2013 8:36 pm

I m very confused in deciding candidate keys for the given set of fds and even more about the normal forms .Is there any perticular procedure for finding candidate keys
prajakta
 
Posts: 3
Joined: Thu Jun 13, 2013 8:17 pm
My College/Company:: ses coe.dhule,
Roll Number: 75420016

Re: DBMS_RELATION MODEL_CANDIDATE,SUPER KEY_NORMAL FORMS

Postby sameer2009 » Fri Jun 14, 2013 10:01 am

learn Attribute closures from any standard dbms book or internet
Attribute closures help in finding candidate keys
Check this out!!! Free Android App for Computer Science and Engineering Exam.
Download .apk file @ tinyurl.com/csexamapp
See How To Use @ tinyurl.com/csexamapplication
sameer2009
Gatementor Guru
Gatementor Guru
 
Posts: 1433
Joined: Tue Sep 09, 2008 5:29 pm
My College/Company:: lt
Roll Number: 99999

Re: DBMS_RELATION MODEL_CANDIDATE,SUPER KEY_NORMAL FORMS

Postby prajakta » Mon Jun 17, 2013 4:03 pm

A->BC
CD->E
B->D
E->A
List the candidate keys?
prajakta
 
Posts: 3
Joined: Thu Jun 13, 2013 8:17 pm
My College/Company:: ses coe.dhule,
Roll Number: 75420016

Re: DBMS_RELATION MODEL_CANDIDATE,SUPER KEY_NORMAL FORMS

Postby sameer2009 » Tue Jun 18, 2013 9:33 am

prajakta wrote:A->BC
CD->E
B->D
E->A
List the candidate keys?

A
E
CD
BC
Check this out!!! Free Android App for Computer Science and Engineering Exam.
Download .apk file @ tinyurl.com/csexamapp
See How To Use @ tinyurl.com/csexamapplication
sameer2009
Gatementor Guru
Gatementor Guru
 
Posts: 1433
Joined: Tue Sep 09, 2008 5:29 pm
My College/Company:: lt
Roll Number: 99999


Return to CS Question

Who is online

Users browsing this forum: No registered users and 2 guests
cron