Attributes-Entities   «Prev  Next»

Attribute Domains - Exercise

Objective:Identify domain types.
Exercise scoring
This exercise is worth a total of 30 points. You will receive up to five points each time you correctly assign a domain type to one of the attributes listed below.

Background/overview

In the previous lesson, you learned about attribute domains and domain types. You also learned that choosing the correct domain type is critical to the accuracy of a database. This exercise gives you an opportunity to test your ability to select the appropriate domain type for a small group of attributes.

Instructions

To complete this exercise, you should have a copy of the case study, available for downloading here .
Examine the data entry form from the Stories on CD case study, and specify the domain type that should be assigned to each of the following entries:
  1. Last name
  2. Price
  3. CD title
  4. CD shipped?
  5. Order date
  6. Phone

Hints

You will need to use the Boolean domain.

Submitting your exercise


Type or paste your answers into the text box below, then click Submit to submit the exercise and view a results page.