Directions (Q96–100): An organization maintains a database with five attributes A, B, C, D, E. Consider the universal relation R(A, B, C, D, E) with functional dependency set F = {A → BC, D → E, BC → D, A → D}. All attributes are simple and atomic.
Identify primary key of table with F functional dependency set
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: C. A
Explanation
A determines B, C, then D, then E, and appears on no right side, so A is the key.
More Database Management Systems questions
- Identify the normal form in which relation R belong to
- Identify the redundant functional dependency in F
- Assume that given table R is decomposed in two tables R (A, B, C) 1 with functional dependency set f = {A → B, A → C} 1 and R (A, D, E) FD…
- Which of the following has same expressive power with regard to relational query language? (a) Relational algebra and domain relational cal…
- Which of the following features is supported in the relational database model?
- With respect to relational algebra, which of the following operations are included for mathematical set theory? (a) Join (b) Intersection (…