Quiz 2 Closed Book Section

This exam is given in two parts. The closed book section of this exam is to be worked without reference to any other written information other than the exam. You must turn in the closed book section of the exam before consulting your book and notes.

Question 1 (10 points)

The design methodology presented in the textbook consists of three phases: conceptual, logical, and physical. In the space below briefly describe what happens in these three phases. Be sure to mention the "output" of each phase.

Question 2 (20 points)

Give short definitions of the following terms:

  1. candidate key
  2. one-to-many relationship
  3. full functional dependency
  4. integrity constraint
  5. user view

Question 3 (10 points)

If a ER-diagram has a many-to-many relationship, what steps must be taken to transform this relationship so that it can be represented by tables within a relational model. Illustrate this transformation with an example.

Question 4

What is your name?