Data Quality

26(~ APPENDIX A Examples of Rules

A.4 Structure Rules

There are a lot of primary key, primary key/foreign key pair, and duplicate

data examples in this set of tables. It shows how quickly these can get complex

and interrelated.

Primary Keys

Table:

Key:

Rules:

INVENTORY

PART_N UMBER

Unique, not null, and not blank

Table:

Natural Key:

Rules:

INVENTORY

DESCRIPTION, TYPE

Unique, not null, and not blank

Table:

Key:

Rules:

INVENTORY ttlSTORY

PART_N UMBER,YEAR,QUARTER

Unique, not null, and not blank

Table:

Key:

Rules:

SUPPLIER

SUPPLIER ID

Unique, not null, and not blank

Table:

Natural Key:

Rules:

SUPPLIER

COMPANY_NAME,COMPANY_ADDRESS,C ...