completion of Exercise 14.15 examine the 3NF relations created to represent the attributes shown in the relation that displays dentist/patient appointment data in Figure 14.19. 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 we need only re-examine the Appointment relation, which has (staffNo, aDate,
aTime) as a PK and (patNo, aDate, aTime) as an alternate key. This relation contains the
following functional dependencies:
You might also like to view...
In the accompanying figure, the ____ technique was probably used to create the illusion of interlocking objects.
A. copy and insert B. copy and paste paths C. copy and paste vectors D. copy and paste blocks
Identify a factor that enables management to minimize inventory levels and provide a high rate of order fulfillment.
a. Sales forecasting b. Customer review c. Web site popularity d. Easy payment method
If selecting individual animations when using a touch screen is difficult, you should try using a(n) ____ or open the Animation pane to select an animation.
A. effect B. printer C. stylus D. keyboard
A(n) ________ is a voice recording that plays and corresponds to the information on a slide
A) narration B) sound effect C) transition effect D) audio file