Question: Please do it in SQL Consider the following table of Raw Data values. Analyze the values and Normalize this data into 3NF. Please use the

Please do it in SQL

Consider the following table of Raw Data values. Analyze the values and Normalize this data into 3NF.

Please use the following syntax to explain each table (Table Name, Keys and Attributes) and document each normal form: Example:

1NF Employee(Ssn, Attribute1, Attribute2, Attribute3 ...) *Underline your keys

2NF TableName1(Key, Attribute1, Attribute2, Attribute3 ...) TableName2(Key, Key, Attribute1, Attribute2, Attribute3 ...)

3NF TableName1(Key, Attribute1, Attribute2, Attribute3 ...) TableName2(Key, Key, Attribute1, Attribute2, Attribute3 ...)

here is the data

Please do it in SQL Consider the following table of Raw Data

\begin{tabular}{|c|l|l|l|l|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{ A } & \multicolumn{1}{c|}{ B } & C & F & \\ \hline San & Name & Bdate & Address & Sex & Salary & Phone_Numbers \\ \hline 438575055 & John Smith & 19890108 & 9993 Oak Valley Drive Astoria, NY 11103 & M & 100k & 2127842451,3472021511 \\ \hline 126923260 & Franklin Wong & 20031208 & 753 Rosewood Street East Elmhurst, NY 11370 M & 83k & 3472057213 \\ \hline 983205008 & Alicia Zelaya & 19900119 & 9592 Paris Hill St. Bronx, NY 10461 & F & 98k & 3472077184 \\ \hline 327480012 & Jennifer Wallace & 20080915 & 63 Redwood Lane Spring Valley, NY 10977 & F & 75k & 3472086065,3472095211 & Android Development \\ \hline 891001799 & Ramesh Narayan & 19940411 & 9815 Central St New York, NY 10016 & M & 107k & 3472135073,3472245968,3472263195 & Android Development \\ \hline 256192899 & Joyce English & 19820502 & 367 Aspen Street Brooklyn, NY 11223 & F & 86k & 3472377074 \\ \hline 682126535 & Ahmad Jabbar & 19801110 & 708 North Harvey Street Bronx, NY 10457 & M & 101k & 3472703980 \\ \hline 804101579 & James Borg & 19910329 & 376 Deerfield Dr. New York, NY 10034 & M & 85k & 3472842986,3472918921 \\ \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 Databases Questions!