The following entities will be created with the Aptify Framework to build the database structure required to capture the information specified in the Motor Loaner System Requirements.
Entity Name | Requirement Satisfied |
Associates | DR1: Associate Contact Information; |
Manufacturers | DR2: Manufacturer Contact Information; |
Vehicle Models | DR3: Model Specific Vehicle Information |
Vehicle Types | DR3d. Type of Vehicle |
Maintenance Schedule | DR4: Vehicle Maintenance Schedule Information |
Vehicles | DR5: Vehicle Specific Information |
Vehicle Colors | DR5h. Exterior Color of Vehicle; |
Vehicle Statuses | DR5k. Vehicle's Current Status |
Rental Agreements | DR6: Rental Agreements Form Information |
RentalAgreementOptions (sub-type entity) | DR6u. Rented Accessories; |
Rental Options | DR6u. Rented Accessories |
Customers | DR6c. Customer Name; |
CustomerAddresses (sub-type entity) | BPR5: Allow Multiple Addresses and Phone Numbers for Customers; |
CustomerPhones (sub-type entity) | BPR5: Allow Multiple Addresses and Phone Numbers for Customers; |
Service Tickets | DR7: Service Form Information; |
The following Entity Relationship Diagram (ERD) illustrates how these entities link together to form the database structure for the Motor Loaner System:
Note that the ERD does not include entities that already exist in the Aptify Framework (i.e., the Addresses and Phone Numbers entities).
