We plan to construct a database for the Boca Raton Water Billing system. The city of Boca Raton hires employees who can read a water meter and store daily water consumption data in the database system.

A customer has id and name.

A water meter has id and brand.

A customer can own multiple water meters but a water meter is owned by at most one customer.

A water meter creates meter data including date and water consumption.

A employee has id, name, and supervisor id.

A supervisor can supervise more than one employee and an employee can be supervised by more than one supervisor.

A employee reads meter data from a water meter.

Draw an ER diagram for this application. Specify key attributes of each entity type and structural constraints on each relationship type. Note any unspecified requirements, and make appropriate assumptions to make the specification complete. Write DDL statements to create the tables for the ER diagram