Reference no: EM13335089

Conceptual Design

You have been asked to develop a data model for the Drip Drip Water Company (DDWC). DDWC is the sole supplier of water to the citizens and businesses of the town of Drip Drip.

Each of DDWC's customers is classified as being either residential or non-residential. Each customer may have a water meter that measures the water consumed by the customer at a particular service address. Customers may have more than one service address.
Water meters must be replaced when they have been in use for 5 years. We can assume that a meter will never be damaged or become unserviceable and will not be re-assigned to another service address.

All customers are billed monthly for each service address. Meter readers, who are employed by DDWC, are paid per meter they read. They are each allocated up to 1000 meters to read each month.

Once the reader has read the meter, the reading is recorded and the bill for that service address is calculated based on the consumption since the last reading.

For example, if the last meter reading was 123580 kilolitres (kl) and the next reading was 123683kl, the consumption for that period would be 103kl. Residential customers' bills are calculated as follows: for each residential service address, the customer is billed a flat rate of $25 supply charge. They are then billed a further 24c for each kl consumed since the last reading. There are no GST or other taxes imposed.

Non-residential customers' bills are calculated as follows: there is no supply charge. They are charged only for the consumption since the last reading. They are charged 24c for the first 100 kl, 30c for the second 100 kl and 50c for each kl in excess of 200kl.

All customers are given 30 days from the billing date to pay their account. They can pay by cash, paypal, or EFT. Customers who do not pay within the 30 days will have an accounting charge of $5 added to the bill. After 45 days a further $10 accounting charge is added. At 60 days, the customer's water supply at the affected service address is cut off. Once a customer has had their supply cut off, the person or business responsible for the bill will not be able to create a new account at a different service address until their arrears have been cleared. Each customer has the right to request a report that details the historical consumption of water at any of their service addresses, whether they were the customer at the time or not.