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.
You might also like to view...
To ________ a table into a range, click within the table, click the Table Tools Design tab, and from the Tools group, select Convert to Range
Fill in the blank(s) with correct word
How many characters may a field name in Access contain including numbers, letters, spaces, and special characters?
A. 255 B. 36 C. 64 D. 146
A physical file pointer "points to" a hardware device, such as a keyboard, screen, or printer.
Answer the following statement true (T) or false (F)
When using the method System.out.printf( ), what is the purpose of the %d format code?
a) For printing a double b) For printing a float c) For printing a String d) For printing an int