Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started