There is an ER diagram for the calculation process. Each calculation operation performed here is called calculationName For example: Pipe Length calculation. The value found as a result of this calculation is the calculationLength value. CalculationLengthUnit, where the unit of this value is specified (such as km, meter, or cm). Finally, the last date of the measurement is stored as date in the calculationLastUpdate feature.

Apart from this, activities are carried out for a calculation work. In this activity, the best and worst calculation is stored in CalculationWorstAndBest separated by commas (For example 245, 249). Other than that, the name of the activity is specified in the nameOfActivity.

In light of all these explanations, the diagram below should be normalized to at least 3NF (if possible even higher). M:M problems need to be resolved.

Solution must be a Crow's Foot ERD. List the functional dependencies to demonstrate that each table is a third normal form. Also show that the functional dependencies on the list comply with third normal form criteria.

Calculation