Lab 0: Class Exercise Problem Statement

This document presents the scenario you will use in lab exercises for the course.

Steps:

1. Here's the scenario:

   You are in the IT department for an exotic-car leasing company. Your job is to write a system to automate the business process, which is currently done by hand. Here is a description of the business:

   1. We import cars, accruing a one-time import duty based on the country of origin and the price. We currently import cars from Germany and Japan with duty of 10% and 15% respectively. We need to pay the total duty annually for all cars imported in that year. Each duty payment is considered to be a general expense (see #3 and #4) and must be recorded on a yearly basis.
   2. We do not accept rental requests from the general public -- all of our customers are dues-paying associates of the company so we need to track the dues paid and membership list.
   3. We need to track "capital" expenses on each car and would like to break these expenses down by type (e.g. repairs, bodywork, etc.).
   4. We need to track "general" expenses per car (e.g. gasoline purchases, duty and scheduled maintanence) and wish to track miles per gallon.
   5. We need to track the number of times each associate leases a car and the number of miles driven and gas purchased (we require receipts).
   6. We need to pay license fees yearly on each car based on the car's purchase price.
   7. We have plans in the future to lease other exotic transportation means (e.g. boats, Segway scooters).