Relational databases:
Assume that you run an oil company. The information that you have includes:
- customer id number
- customer name
- customer address(need easy access to street, city, state and zip)
- capacity of tank
- house type code
- for each house type code you need to carry the average summer, fall, spring and winter use
- delivery information for the year including
- the date of the delivery
- the number of gallons delivered
- the price per gallon for each delivery that is made
Note that the house type is a code to help determine the predicted usage. The system will have an average use for
capes or ranches in the summer, fall etc. A customer is assigned that code to help predict the usage for that type of house.
Your assignment is to design the tables that you would need to
develop to implement this database. Show me the tables, the
fields/columns contained in each table and the designate the field or
fields that would be used as the primary keys.