Question

1.For each of the following E-R diagrams from Chapter 2:

I. Transform the diagram to a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema).

Figure 4-5:

1. Figure 2-8
2. Figure 2-9b
3. Figure 2-11a
4. Figure 2-11b
5. Figure 2-15a (relationship version)
6. Figure 2-15b (attribute version)
7. Figure 2-16b
8. Figure 2-19

*These E-R diagrams are shown below:

a. Figure 2-8:

b. Figure 2-9b:

c. Figure 2-11a:

d. Figure 2-11b:

e. Figure 2-15a (relationship version):

f. Figure 2-15b (attribute version):

g. Figure 2-16b:

h. Figure 2-19:

Answer 1

Dear,

 

Definition: A functional dependency occurs when one attribute in a relation uniquely determines another attribute. This can be written as A -> B which means "B is functionally dependent upon A."

Note: According to cramster rules one question per post.