On completion of Exercise 14.14 examine the 3NF relations created to represent the attributes shown in the Wellmeadows Hospital form shown in Figure 14.18. 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 Ward relation, which has a wardNo as a PK and
wardName as an alternate key. This relation contains the following functional dependencies:
wardNo ??wardName (fd1)
wardName ??wardNo (fd2)
The presence of fd2 does not break BCNF because wardName is a candidate key for this
relation. Hence the Ward relation is in BCNF.
As the other relations shown in the answer for Exercise 14.14 have only one candidate key,
they must also be in BCNF.
You might also like to view...
Which of the following operators is the increment operator
A. += B. + C. % D. ++
The first step in building your form is to add a form ____________________ to an existing Web page.
Fill in the blank(s) with the appropriate word(s).
_____ maintains consistency among data flow diagrams (DFDs) by ensuring that input and output data flows align properly.
A. Balancing B. Indexing C. Adapting D. Shipping
Removable media control
What will be an ideal response?