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. Posted solutions are meant to be 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 complete the form.
Please provide a valid email address and we will get back to you within 24 hours.
Payment is through PayPal, Buy me a Coffee
or Cryptocurrency.
We are a nonprofit organization however we need funds to keep this organization operating
and to be able to complete our research and development projects.