Relational databases:
Assume that you run an oil
company. For this example we are going to assume that a customer and a house
are the same, in other words a customer only has one house and a house is owned
by one customer. The information that you have includes:
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. So for example you might have a house type that is for 6 room capes and would tell the average usage for that type of house in each of the four seasons. 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.