Consider the following relational schemas and functional dependencies. Assume that the relations have been produced from a relation ABCDEFGHI and that all known dependencies for this relation are listed. State the strongest normal form for each one and, if appropriate, decompose to BCNF.
(a) R(A, B, C, D, E); A ? B, C ? D
(b) S(A, B, F); AC ? E, B ? F
(c) T(A, D); D ? G, G ? H
(d) U(C, D, H, G); A ? I, I ? A
(e) V(A,C, E, I)
(a) Not in 3NF. Decompose to: AD, CD, and ACE.
(b) Not in 3NF. Decompose to: AB and BF.
(c) – (e) Last three are in BCNF.
You might also like to view...
The Page Footer section of a report will show labels or data at the bottom of each page of report
Indicate whether the statement is true or false
The ____ identifies what each data series represents.
A. legend B. data marker C. data title D. gridline
Cryptochain is the name of the massive public online ledger which records the time and amount of every finalized cryptocurrency transaction.
Answer the following statement true (T) or false (F)
Android offers a GUI experience by employing programs called _______________ that enable users to customize their Android device extensively.
Fill in the blank(s) with the appropriate word(s).