Database Modeling and Design, 5th Edition

Solutions to Selected Exercises

Problem 2.2.

Problem 3.2.

Problem 4.1. Connect Movie to Video-copy as a 1-to-n relationship (Video-copy at the n side), or use a generalization from Movie to Video-copy with Movie as the supertype and Video-copy as the subtype.

Problem 6.1. Given the table R1(A, B, C) with FDs A -> B and B -> C:

a. Is A a superkey for this table? Yes

b. Is B a superkey for this table? No

c. Is this table in 3NF, BCNF, or neither? Neither 3NF nor BCNF.

Problem 6.3. Minimum set of 3NF (and BCNF) tables:

R1: ABCDEFHINQ with ...