Ad Code

Transitive dependency,BCNF,Anomalies Question ?


Explain me transitive dependency , BCNF ,relation decomposed,anomalies if we have two table the first student we insert forgin key & the table we must the student attribute their automaticcly primary key made

Transitive dependency: It is functional dependency between the primary key and one or more nonkey attributes that are dependent on the primary key via another nonkey attribute. Transitive dependency create unnecessary redundancy that may lead to anomalies.
For example there is a relation CUSTOMER ORDER(OrderID, OrderDate, CustomerID, CustomerName, CustomerAddress) Here, in this relation CustomerName is functionally dependent on CustomerID which is also dependent on OrderID which can be shown like this. OrderID→CustomerID→CustomerName
2) BCNF: A relation is in BCNF if and only if every determinent is a candidate key. It is stronger form of normalization than 3NF because it eliminates the second condition for 3NF, which allows the right side of the functional dependency to be a prime attribute. So we can define it as, A relation is in BCNF if and only if every determinant is a candidate key. Example: Let us consider a relation TEACHING which has three attributes: Student, Course, and instructor. TEACHING (Student, Course, Instructor). In this relation, Student determines the course which determines the instructor. Also instructor determines the course which he has to handle. If an instructor is having a command in a particular subject, naturally he would like to handle the subject or course. The relation TEACHING can be transformed into BCNF by splitting the relation into two relations R1 and R2. R1(Instructor, Course) and R2 (Instructor, Student). By splitting the relation TEACHING into two relations R1 and R2 we have transformed the relation TEACHING into BCNF because for the relation to be in BCNF all nonprime attributes must be fully dependent on every key. In the relation R1, the nonprime attribute course is fully dependent on the key attribute Instructor.
3) Relation decomposed means we break the relation and make new ones.
4) Anomalies are actually errors which can come when we want to insert, update or delete any rows in a relation.
Your last query is not understandable, if feasible please ask it again.
Reactions

Post a Comment

0 Comments