You have been hired by Service Plans USA to maintain their client records. They are responsible for Appliance plans and HVAC units their customers.
Every Account has a customer (name, phone – 10 digits, street address and zip – 5 digits) and an account number (automatically generated beginning at 100.) When an account is opened, it is either an Appliance account or an HVAC account.
If it is an appliance account, there can be multiple appliances registered (each with type – refrigerator, stove, microwave or dishwasher; model number – 7 characters all digits or letters; replacement cost – between $400 and $8000).
If it is an HVAC unit, there is only one and all that is needed is a vendor name. Your application should provide the user with the following menu options:
If appliance customer, register up to 10 appliances (do not allow for duplicate model numbers)
If appliance customer, register up to 10 appliances (do not allow for duplicate model numbers). If customer already exists (same phone number), add appliance to existing list of appliances
If HVAC customer, register one unit. If customer already exists (same phone number), do not add account .
List all current customers
Number of HVAC units registered
Total replacement costs of all appliances registered
It is not our intention to break the school's academic policy. Projects posted are only used as a reference
and should not be submitted as is. We are not held liable for any misuse of the solutions.
Please see the frequently asked questions page
for further questions and inquiries.
Kindly fill out the form.
Please provide a valid email address and we'll get back to you in less than 24 hours.
We will be sending an invoice through PayPal upon confirmation.
We are a non profit organization however we need an amount to keep this organization running,
and to be able to complete our research and development.