Data Model

Here are the entities and their attributes: 

1. Assets
   • Id 
   • Asset 
2. Asset Type
   • Id 
   • Asset Type 
3. Vendors
   • Id 
   • Vendor ID 
   • Vendor Name 
   • Contact Person 
   • Contact Number 
   • Email Address 
4. Personnel
   • Id 
   • Personnel ID 
   • First Name 
   • Last Name 
   • Date of Birth 
   • Gender 
5. Locations
   • Id 
   • Location ID 
   • Location Name 
   • Address 
6. Asset Assignments
   • Id 
   • Assignment ID 
   • Asset ID 
   • Personnel ID 
   • Location ID 
   • Assignment Date 
7. Incident Reports
   • Id 
   • Incident Report ID 
   • Incident Date 
   • Incident Type 
   • Asset ID 
   • Personnel ID 
   • Description 
8. Inspection Reports
   • Id 
   • Inspection Report ID 
   • Asset ID 
   • Inspection Date 
   • Inspector ID 
   • Inspection Type 
9. Service Schedules
   • Id 
   • Service Schedule ID 
   • Asset ID 
   • Service Type 
   • Service Description 
   • Service Interval 
10. Maintenance Records
    • Id 
    • Maintenance Record ID 
    • Asset ID 
    • Maintenance Date 
    • Maintenance Type 
    • Performed By 

2. Defining Relationships 

Relationships are defined based on foreign key references. The primary keys are unique identifiers for each entity, while foreign keys reference primary keys from other entities to establish relationships. Here’s a more detailed look at the relationships: 

• Assets to Asset Type: Assets have a type that categorizes them. 
• Assets to Vendors: Assets may be procured from vendors. 
• Assets to Locations: Assets are located at specific locations. 
• Assets to Personnel: Assets may be assigned to personnel. 
• Assets to Asset Assignments: Assets are assigned to personnel or locations. 
• Assets to Incident Reports: Incident reports are linked to assets. 
• Assets to Inspection Reports: Inspection reports are linked to assets. 
• Assets to Service Schedules: Service schedules are linked to assets. 
• Assets to Maintenance Records: Maintenance records are linked to assets.