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...
Give a command for displaying the login name of the user who was the first to log on a system.
What will be an ideal response?
Regardless of whether or not a Web page will be displayed on a cell phone, tables are safe to use because they have very high levels of browser support on phones.
Answer the following statement true (T) or false (F)