Question

In working on the conceptual design of the new database, Ken determines that the "office" field in one of the tables must include one of the following values: Fort Worth, Boston, or Tacoma. What database design activity is Ken performing?

Answer 1

Answer:

Identifying an attribute domain

Explanation:

In computing, the attribute domain is the set of values allowed in an attribute. For example: Rooms in hotel (1-300) Age (1-99) Married (yes or no) Nationality (Nepalese, Indian, American, or British) Colors (Red, Yellow, Green) For the relational model it is a requirement that each part of a tuple be atomic.

Attribute domains are rules that describe the legal values of a field type, providing a method for enforcing data integrity. Attribute domains are used to constrain the values allowed in any particular attribute for a table or feature class. If the features in a feature class or nonspatial objects in a table have been grouped into subtypes, different attribute domains can be assigned to each of the subtypes. A domain is a declaration of acceptable attribute values. Whenever a domain is associated with an attribute field, only the values within that domain are valid for the field. In other words, the field will not accept a value that is not in that domain. Using domains helps ensure data integrity by limiting the choice of values for a particular field.