Example 2 Parking Tickets Table St ID L Name F Name Phone No St Lic Lic No 38249
ID: 3716901 • Letter: E
Question
Example 2 Parking Tickets Table St ID L Name F Name Phone No St Lic Lic No 38249 Brown Thomas 111-7804 FL 38249 Bro Thomas 1-7804FL 82453 Green Sall Ticket# | Date Code Fine 391-1689AL 391-1689AL 391-1689AL BRY 123 15634 10/17/06 2 BRY 123 16017 11/13/06 1 TRE 141 14987 10/05/06 3 TRE 141 16293 11/18/06 1 TRE 141 17892 12/13/062 S25 $15 $100 S15 S25 82453Green Sall Sall 82453 Green L Name F Name Phone No St Lic Lic No Ticket Date Code Fine The figure above shows the functional dependencies in the Parking Tickets relation. The primary key for the relation is the combination of StID and Ticket# - Functional dependency A StID ? LName, FName, PhoneNo, StLic, LicNo Is this a partial or transitive dependency? ------ Functional dependency B Code ? Fine Is this a partial or transitive dependency? Functional dependency C St Lic? Lic No Is this a partial or transitive dependency?Explanation / Answer
Answer:------
Fully Functional Dependency:------A relation is said to be fully functional dependent ,if it depedents on the whole key of the relation, not any part of the key.
e.g.
R(A B C D) //Here ABC is a primary key.
{
ABC---->D
}
Partial Functional Dependency:-----A relation is said to be partial functional dependent ,if it depedents on the any part of the key not the whole key of the relation.
e.g.
R(A B C D) //Here ABC is a primary key.
{
AB---->D
}
1.
Functional dependency A,
St_ID -----> L_Name,F_Name,Phone_No, St_Lic,Lic_No
Yes, this is a partial or transitive dependency because, Primany Key for the realtion is the combination of St_ID and Ticket#.And given realtion depends on a part of primary key that part name is St_ID.
2.
Functional dependency B,
Code ---> Fine
No, this is not a partial or transitive dependency because, Code is not a part of Primany Key.
3.
Functional dependency C,
St_Lic ----> Lic_No.
No, this is not a partial or transitive dependency because, St_Lic is not a part of Primany Key.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.