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

\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
Get step-by-step solutions from verified subject matter experts
