The following entities will be created with the Aptify Framework to build the database structure required to capture the information specified in About the Requirements for the Motor Loaner Sample Application.
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).
