4 questions Chapter 4

1. What is a well-structured relation?  Why are well-structured relations important in logical database design?

2. What is the primary purpose of normalization?

3. List three conditions that you can apply to determine whether a relation that is in first normal form is also in second normal form.

4. Explain how each of the following types of integrity constraints is enforced in the SQL CREATE TABLE commands:

a. entity integrity

b. referential integrity