This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Complete I, II and III for the following E-R diagram (a) (Page 107, Figure 3-8) (e) (Page 119, Figure 3-15a) (f) (Page 119, Figure 3-15b) (See Figure 5-5 for an example of relation schema; see Figure 5-23 for an example of functional dependencies.) 3. (I) Transform each of the following diagrams into a relational schema that shows referential integrity constraints (See Figure 5-5 for an example of relation schema); a. Figure 4-6b (Page 160) b. Figure 4-7a (Page 161) (II) For each of the above relations, diagram the functional dependencies. (See Figure 5-23 for an example of functional dependencies.)...
View Full Document
- Spring '08