Question: Create Functional Dependencies and Normal Form including functional dependencies depicting major business rules. A denormalized table containing all attributes is shown. This table is then

Create Functional Dependencies and Normal Form including functional dependencies depicting major business rules. A denormalized table containing all attributes is shown. This table is then normalized followed by a statement as to the form level in which your data model is normalized and supporting evidence to support your claim. If your model is not normalized, provide a statement to explain why.

Below I've attached my er diagram, relational schemaCreate Functional Dependencies and Normal Form including functional dependencies depicting major businessrules. A denormalized table containing all attributes is shown. This table is

Bold = Primary Key Itall. = Foroign Koy \begin{tabular}{|c|c|c|} \hline EMPLOYEE & & PART \\ \hline EmployeelD & WAREHOUSE & PartiD \\ \hline FirstName & WarehouselD & SupplierlD \\ \hline LastName & WarehouseName & SiteID \\ \hline \multirow{2}{*}{\begin{tabular}{c} Position \\ Email \end{tabular}} & Location & WarehouselD \\ \hline & & EmployeelD \\ \hline Phone & & DateRecived \\ \hline \multirow[t]{3}{*}{} & & Location (Warehouse or Site) \\ \hline & & DateLeft \\ \hline & & W \\ \hline \multicolumn{3}{|l|}{ SERVICE } \\ \hline \multicolumn{3}{|l|}{ SitelD } \\ \hline SiteName & & SUPPLIER \\ \hline Location & & SupplieriD \\ \hline SiteManager & & SupplierName \\ \hline \multirow[t]{3}{*}{t} & & ContactName \\ \hline & & ContactEmail \\ \hline & & ContactPhane \\ \hline \multicolumn{3}{|l|}{ REPAIR } \\ \hline \multicolumn{3}{|l|}{ RecordiD } \\ \hline \multicolumn{3}{|l|}{ PartID } \\ \hline \multirow{2}{*}{\begin{tabular}{c} Date \\ Employeeld \end{tabular}} & & PURCHASE \\ \hline & & OrderiD \\ \hline & & PartiD \\ \hline & & SupplierlD \\ \hline & & OrderDate \\ \hline & & UnitPrice \\ \hline & & Quanity \\ \hline & & OrderStatus \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!