Title: Select unique identifiers (UIDs).
Course: Database Design and Management (Oracle) (10052) > Section: Identifying Business Requirements

Selection should be based on

- identifying attributes, relationships, or both
- determining whether a natural UID exists
- using a sequence to artificially generate a number if a natural UID does not exist
- validating the attribute by asking

  - Is the attribute unique?
  - Is the attribute mandatory?

A UID may be one attribute or more than one attribute combined.