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
- Manufacturer
- Model
- Description
- Serial Number
- Equipment Tag
- Unique Identifier: Serial Number
- Entity: Case
- Properties
- Case Number
- Subject
- Description
- Type
- Status
- Unique Identifier: Case Number
- Entity: Equipment Loans
- Properties
- Equipment Loan Number
- Equipment Name
- Loan Type
- Loan Start Date
- Estimated Return Date
- Unique Identifier: Equipment Loan Number