Database_Canonical form

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

Moderator: CS Moderators Team

Database_Canonical form

Postby monika17ap » Thu Nov 21, 2013 11:18 am

Can anyone explain canonical form and minimal canonical form??
monika17ap
 
Posts: 13
Joined: Tue Nov 19, 2013 11:19 am
My College/Company:: WCE, Sangli
Roll Number: 99999999

Re: Database_Canonical form

Postby sameer2009 » Thu Nov 21, 2013 3:10 pm

There might be some extra attributes on the either side (LHS or RHS) of a Functional dependency in the original set of Functional dependencies. If such extra attributes are eliminated from respective Functional dependency, then we get a reduced set of Functional dependencies. Such reduced set of Functional dependency is equivalent to the original set of Functional dependency.
Such reduced set of Functional dependency is called as Canonical set of Functional Dependencies.
Please refer DBMS material or "Korth" for how to eliminate the extra attributes from a Functional dependency.
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