State the conditions (in terms of functional dependencies) for a relation to be in third normal form and in BCNF.
What will be an ideal response?
Solution:
For all FD's X ->A that are not trivial:
BCNF - (1) X is a superkey
3rd NF - (1) X is a superkey
(2) A is contained in a key
You might also like to view...
The ____ form layout displays fields across the screen in rows, with a label above each field.
A. Justified B. Tabular C. Datasheet D. Columnar
A(n) ________ is a reference placed at the end of a section or a document
A) footnote B) citation C) endnote D) bibliography
What is the best practice to switch the columns and rows in a range?
A) Cut the range, then use the Paste Special option called Values B) Cut the range, paste it into a blank area, then cut and paste each cell where you want it C) Cut the range, then use the Paste Special option called Switch D) Cut the range, then use the Paste Special option called Transpose
By defining the ________, data consistency is ensured
Fill in the blank(s) with correct word