Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 System RequirementsSample 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

...

Note

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 DiagramImage RemovedEntity Relationship DiagramImage Added