Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ANSWER MUST BE Crows Foot ER DIAGRAM!!!!! NOT TEXT There is an ER diagram for the calculation process. Each calculation operation performed here is called

ANSWER MUST BE Crows Foot ER DIAGRAM!!!!! NOT TEXT

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.

image text in transcribed

\begin{tabular}{|l|l|l|} \hline \multicolumn{3}{|c|}{ Person } \\ \hline PK & pIDname & integertext \\ \hline & \\ & Joins \end{tabular} Calculation \begin{tabular}{|l|l|l} \hline PK & calD & integer \\ \hline calculationName & text \\ \hline calculationLength & numeric \\ \hline calculationLengthUnit & {km,meter,cm} \\ & calculationLastUpdate & date \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Management Systems

Authors: Mark L. Gillenson

3rd Edition

978-1119907466

More Books

Students also viewed these Databases questions

Question

Explain the meaning of ergonomics.

Answered: 1 week ago