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.
You might also like to view...
An em dash indicates an explanation or emphasis in a document
Indicate whether the statement is true or false
You should use at most ________ fonts in a worksheet
A) two B) three C) four D) five
Which EAP protocol creates an encrypted channel between the client authentication server and the client, and uses Microsoft Windows logins and passwords?
A. TKIP B. LEAP C. PEAP D. ICMP
Photoshop displays non-selected anchor points as ____ as you add further anchor points.
A. triangles B. hollow squares C. red circles D. blue rectangles