Databases: Entity and Unique Identifiers

Below are three examples of Entities in a Database, including 5 properties of each Entity and which I would label a Unique Identifier.

  • Entity: Equipment
  • Properties
  1. Manufacturer
  2. Model
  3. Description
  4. Serial Number
  5. Equipment Tag
  • Unique Identifier: Serial Number

  • Entity: Case
  • Properties
  1. Case Number
  2. Subject
  3. Description
  4. Type
  5. Status
  • Unique Identifier: Case Number

  • Entity: Equipment Loans
  • Properties
  1. Equipment Loan Number
  2. Equipment Name
  3. Loan Type
  4. Loan Start Date
  5. Estimated Return Date
  • Unique Identifier: Equipment Loan Number

 

Leave a Reply

Your email address will not be published. Required fields are marked *