View Source

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 BPR1: Track Employee Information Electronically
Manufacturers	DR2: Manufacturer Contact Information BPR2: Track Manufacturer Information Electronically
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 DR5i. Interior Color of Vehicle
Vehicle Statuses	DR5k. Vehicle's Current Status
Rental Agreements	DR6: Rental Agreements Form Information
RentalAgreementOptions (sub-type entity)	DR6u. Rented Accessories DR6v. Quantity of Each Rented Accessory DR6w. Rented Accessories Present on Return DR6x. Rental Accessory Comments
Rental Options	DR6u. Rented Accessories
Customers	DR6c. Customer Name DR6d. Customer Email Address DR6e. Customer Main Mailing Address DR6g. Customer Main Contact Phone Number
CustomerAddresses (sub-type entity)	BPR5: Allow Multiple Addresses and Phone Numbers for Customers DR6f. Customer Other Address(es)
CustomerPhones (sub-type entity)	BPR5: Allow Multiple Addresses and Phone Numbers for Customers DR6h. Other Phone Number(s)
Service Tickets	DR7: Service Form Information BPR22: Track Vehicle Servicing Information Electronically

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).

Entity Relationship Diagram