Database Design and Implementation Assignment #2

Make a copy of this assignment in Microsoft Word, add your answers, and then submit to the dropbox as per the instructions and due date. Either full sentence or point-form answers are acceptable.

1. Define each of the following terms: (4 Marks)

a. associative entity

b. derived attribute

c. entity-relationship model (not diagram)

d. multivalued attribute

1. Define these integrity Constraints: (4 Marks)

• Domain Constraints
• Entity Integrity
• Referential Integrity
• How referential integrity constraints are implemented

3. Draw and explain an ER diagram for the given two entities with these requirements: (you must use software like Visio for the drawing) (12 Marks)

• The course can have zero or more students.
  • Might be in the process or not popular courses.
• A student can take zero or many courses.
  • Might not yet have registered.

If you notice there are any M: N relationships in this situation, you should resolve them.