Example of using restrictions

You have new data that needs to be entered into the schema designer. Each new record contains the name of the employee and his or her department.

The Employee List schema illustrates components of Record.

The following is the new data containing the name of the employee and the department.

Steven Barlow,Doc

Heather Proust,Qa

Mary Whiting,Doc

Genie Elks,Sup

Francine Maxwell,Dev

Mark Brown,Sup

Daryl Schwartz,Acc

Harry O'Brian,Sal

Ellen Randolph,Dev

Paula Keller,Qa

Define the values of Department as a character text item.

Define the example data as valid restrictions (enter in the Include column) of Department:

If the departments are located in different offices, you can divide the data into separate files; one file per office. To do this, map the data from the main office to one file, the data from the development office to one file, and the data from the support office to another file. Then create subtypes of Department: MainOffice, DevelopmentOffice, and SupportOffice and partition Department. When you partition Department and create subtypes, you are saying that a given department data object belongs to only one of the subtypes based on its value.

The subtypes of Department inherit the restrictions of Department. Now allocate restrictions among subtypes. To do this, delete the restrictions from the subtype that do not apply to that particular office. For example, the MainOffice item has only the departments in that office, DevelopmentOffice item has only the departments in that office, and the SupportOffice item has only the departments in that office.