Explain the steps in the process of putting a relation straight into Boyce-Codd Normal Form (BCNF)
What will be an ideal response?
The steps are:
(1 ) Identify all functional dependencies in the relation.
(2 ) Identify every candidate key in the relation.
(3 ) Check to see if all determinants are candidate keys.
a. If so, the relation is in BCNF-STOP.
b. If not, then:
i. Move the columns of the functional dependency of the determinant that is not a candidate key to a new relation.
ii. Make the determinant of that functional dependency the primary key of the new relation.
iii. Leave a copy of the determinant in the original relation as a foreign key.
iv. Create a referential integrity constraint between the relations.
NOTE: If there is more than one functional dependency that needs to be moved, move the functional dependency with the most columns first.
(4 ) Repeat step (3 ) until you reach STOP.
You might also like to view...
Which of the following statements regarding Social Security disability is NOT correct?
A) In order to qualify for benefits, a disability must be expected to end in death or total deafness. B) There is a 5-month waiting period to receive benefits. C) A person who has paid FICA taxes and has earned at least 6 credits during the last 13 quarters is considered currently insured. D) The disability is expected to last for at least 12 months.
Part of the challenge of implementing poka-yokes in service contexts is the need to address not only server errors, but also customer errors
Indicate whether the statement is true or false