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

Ken is performing the activity of designing the validation rules for the "office" field in the new database.

Step-by-step explanation:

Ken is performing the activity of designing the validation rules for the "office" field in the new database. Validation rules are used to ensure that the data entered into a field meets certain criteria. In this case, Ken is specifying that the "office" field can only have values of Fort Worth, Boston, or Tacoma.

Answer 2

Identifying an attribute domain

Step-by-step 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.