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
• current charge
• amount past due
• delivery information for the last five years including
• the date of the delivery
• the number of gallons delivered
• the price per gallon for each delivery that is made

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.