|
Question List a minimal set of functional dependencies satisfied by the table T.
Note: FDs are determined from understanding the data items and rules of the enterprise. This is just for practice. |
|
|||||||||||||||||||||||||
|
⇒ By the Union |
|
B attribute are the same,D values are all different, andA↛C (Rows 1 and 2) and C↛A (Rows 1 and 3).D determines all other attributes,
B, combined with any other attribute P, still functionally determines only those attributes determined by P, and
A C” have distinct values on each row, so
A C → A B C D ⇒ A C → D
T is
(a) A → B, (b) C → B, (c) D → A B C, (d) A C → D
|
In the classroom the teacher is asking a student to do something. Teacher: Tell me a sentence that starts with “I.” Student: I is the ... Teacher: Stop! Never put “is” after “I.” Student: OK. I am the ninth letter of the alphabt. |