Exercise 2.38

Apply the normalization process to the Veterinary Office List—Version One relation shown in Figure 1-26 to develop a set of normalized relations. Show the results of each of the steps in the normalization process.

Exercise 2.40

Consider the following relation:

STUDENT (StudentNumber, StudentName, SiblingName, Major)

Assume that the values of SiblingName are the names of all of a given student’s brothers and sisters; also assume that students have a at most one major.

A. Show an example of this relation for two students, one of whom has three siblings and the other of whom has only two siblings.

B. List the candidate keys in this relation.

C. State the functional dependencies in this relation.

D. Explain why this relation does not meet the relational design criteria set out in this chapter (that is, why this is not a well-formed relation.)

E. Divide the relation into a set of relations that meet the relational design criteria (that is, that are well formed).

Apply the normalization process to the Veterinary Office List—Version One relation shown in Figure 1-26 to develop a set of normalized relations. Show the results of each of the steps in the normalization process.

Exercise 2.40

Consider the following relation:

STUDENT (StudentNumber, StudentName, SiblingName, Major)

Assume that the values of SiblingName are the names of all of a given student’s brothers and sisters; also assume that students have a at most one major.

A. Show an example of this relation for two students, one of whom has three siblings and the other of whom has only two siblings.

B. List the candidate keys in this relation.

C. State the functional dependencies in this relation.

D. Explain why this relation does not meet the relational design criteria set out in this chapter (that is, why this is not a well-formed relation.)

E. Divide the relation into a set of relations that meet the relational design criteria (that is, that are well formed).

### Recently Asked Questions

- TEST THE APPROPRIATE HYPOTHESIS. Include the null and alternate hypotheses, degrees of freedom, test statistic, rejection region, and decision. Solve the

- hello i am looking for BUS 303 papers that are not designated to any university

- What types of data can be derived from viewing 50 degrees north and 170 degrees west on the map in the winter and summer?