3NF Normalization Database Design Check

by Cyanocobalamin   Last Updated March 10, 2018 08:06 AM

Hello Database Administrators!

For homework, I am tasked with designing a 3NF database for a water company. After much thinking I have come up with the below design. The database has to store the following information:

  1. Client infomation
  2. Rates (different rates, 1 rate per meter)
  3. Services (install fee, etc)
  4. Meter information and meter administrator
  5. Usage amount
  6. Bill

enter image description here

Would the above design meet the criteria? Any insight would be appreciated.

Thank you.

Related Questions

3NF Decomposition Check

Updated November 21, 2017 06:06 AM

Questions Concerning the Chase Test

Updated July 10, 2018 05:06 AM

First Normal Form: Definitive Definition

Updated July 14, 2017 18:06 PM

Making database tables 1NF

Updated July 25, 2017 01:06 AM

How to normalize a table

Updated February 01, 2018 19:06 PM