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