Consider a relational schema R(A, B, C, D, E) with the following functional dependencies: A ? B, BC ? E, and ED ? A.
What will be an ideal response?
(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...
OS/JCL __________ statements separate and identify jobs.
a. DD b. EXEC c. STEP d. JOB
Computer Science & Information Technology
An external entity may be:
A) a person. B) another department. C) another computer system. D) All of the above.
Computer Science & Information Technology
The ________ Show template has several question layouts such as True or False, Multiple Choice, and more
Fill in the blank(s) with correct word
Computer Science & Information Technology
A unit of digital information that consists of 8 bits; used to represent a single character in modern computer systems.
What will be an ideal response?
Computer Science & Information Technology