On completion of Exercise 14.16 examine the 3NF relations created to represent the attributes shown in the relation displaying employee contract data for an agency called Instant Cover in Figure 14.20. Determine whether these relations are also in BCNF. If not, transform the relations that do not conform into BCNF.
What will be an ideal response?
The only relations that may violate BCNF are those that have more than one candidate key.
Therefore for this exercise, as there are no relations that satify this criteria, the relations shown in
the answer for Exercise 14.16 must already be in BCNF.
Computer Science & Information Technology
You might also like to view...
Which of the following would you typically not find in a calculated control?
A) Image B) Simple math C) Aggregate function D) Function using the Expression Builder
Computer Science & Information Technology
According to the order of operations, addition and subtraction are evaluated before multiplication and division if the addition and subtraction equations are contained within parentheses
Indicate whether the statement is true or false
Computer Science & Information Technology