Question: begin { tabular } { | c | c | c | c | c | c | c | } hline ProjectID

\begin{tabular}{|c|c|c|c|c|c|c|}
\hline ProjectID & ProjectName & Countyld & CountyName & ProiMnglD & ProiMngName & ProiMiles \\
\hline 1 & Road X & 1 & Wilson & M1 & Bob & 10.00\\
\hline 1 & Road X & 2 & Ottawa & M1 & Bob & 17.00\\
\hline 1 & Road X & 3 & Davis & M1 & Bob & 12.00\\
\hline 2 & Road Y & 4 & Pony & M2 & Sue & 23.00\\
\hline 3 & Bridge A & 1 & Wilson & M3 & Lee & .50\\
\hline 3 & Bridge A & 2 & Ottawa & M3 & Lee & .30\\
\hline 4 & Tunnel Q & 2 & Ottawa & M1 & Bob & 2.00\\
\hline 5 & Road W & 4 & Pony & M4 & Carl & 23.00\\
\hline
\end{tabular}
1. Given these attributes and dependencies normalize this table to 1 NF .
2. Given these attributes and dependencies normalize this table to 3NF.- Be sure to include Primary Keys and Foreign Keys
\ begin { tabular } { | c | c | c | c | c | c | c

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 Programming Questions!