Consider a relational schema R(A, B, C, D, E) with the following functional dependencies: A ? B, BC ? E, and ED ? A.
(a) List all keys of R.
(b) Is R in 3NF?
(c) Is R in BCNF?
(a) The keys are: ACD, BCD, and CDE.
(b) R is in 3NF because B, E, and A are all parts of keys.
(c) R is not in BCNF because none of A, BC, and ED contain a key.
Computer Science & Information Technology
You might also like to view...
The Link Checker is particularly useful in verifying the validity of external links.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
________ are categorized into three types: insert, delete, and update
A) Anomalies B) Transitive dependencies C) Foreign keys D) Integrity constraints
Computer Science & Information Technology
File association refers to the relationship between a file and the program that created the file
Indicate whether the statement is true or false
Computer Science & Information Technology
Why is the NIC considered the "gatekeeper"?
What will be an ideal response?
Computer Science & Information Technology