Homework $-$ Normalization

$1.(2$ pts$)$ Provide an example of data that is not in first normal form $(1$NF$).$ Then put it in $\backslash (1$ N F $\backslash ).$

$2.(2$ pts$)$ Provide an example of data that is in $1$NF but not in second normal form $(2$NF$).$ Then put it in $2$NF$.$

$3.(2$ pts$)$ Provide an example of data that is in $2$NF but not in third normal form $(3$NF$).$ Then put it in $\backslash (3$ N F $\backslash ).$

$4.(8$ pts$)$ Display the schema in $1$NF$,2$NF$,$ and $3$NF$.$ In your $3$NF solution, indicate foreign keys by marking them as $($FK$).$

StudentCourses$($student$\_$id$,$ name, major, courseid, course name, grade$)$

$5.(8$ pts$)$ Using the image and columns provided, display the schema in $1$NF$,2$NF$,$ and $3$NF$.$ In your $3$NF solution, indicate foreign keys by marking them as $($FK$).$ List any assumptions that you make.

PatientMedicalForm$($patientuld$,$ full name, ward, drug, number, drug name, description, dosage, method of administration, units, pet day, start date, end date$)$ Homework $-$ Normalization

$1.(2$ pts$)$ Provide an example of data that is not in first normal form $(1$NF$).$ Then put it in $1$NF$.$

$2.(2$ pts$)$ Provide an example of data that is in $1$NF but not in second normal form $(2$NF$).$ Then put it in $2$NF$.$

$3.(2$ pts$)$ Provide an example of data that is in $2$NF but not in third normal form $(3$NF$).$ Then put it in $3$NF$.$

$4.(8$ pts$)$ Display the schema in $1$NF$,2$NF$,$ and $3$NF$.$ In your $3$NF solution, indicate foreign keys by marking them as $($FK$).$

StudentCourses$($student id$,$ name, major, cqurseid, coursename, grade$)$

$5.(8$ pts$)$ Using the image and columns provided, display the schema in $1$NF$,2$NF$,$ and $3$NF$.$ In your $3$NF solution, indicate foreign keys by marking them as $($FK$).$ List any assumptions that you make.

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{8\}\{|$c$|\}\{$Wellmeadows Hospital Patient Medication Form$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{8\}\{|$c$|\}\{$Patient Number: Proo$34\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{3\}\{|$l$|\}\{$Full Name: Rohers MacDonad$\}$ & & $\backslash$multicolumn$\{4\}\{|$l$|\}\{$Ward Number: Ward $11\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Bed Number: $84\}$ & & & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Ward Name:$\}$ & Prehopastic & $\backslash \backslash$

$\backslash$hline Drug Number & Name & Description & Dosage & Method of & Units per & Start Date & Finish Date $\backslash \backslash$

$\backslash$hline $10223$ & Marphize & Pain Killer & $\backslash (10\backslash$mathrm$\{$ma$\}/\backslash$mathrm$\{$ml$\}\backslash )$ & Oral & $50$ & $2403/18$ & $2410474\backslash \backslash$

$\backslash$hline $10358$ & Tetracyitere & Antiloptia & $0\mathrm{.}5$mg$/$mi$.$ & N & $10$ & $24/03/13$ & $17764785\backslash \backslash$

$\backslash$hline $10223$ & Merphice & Painskitier & $\backslash (10\backslash$mathrm$\{$mg$\}/\backslash$mathrm$\{$mil$\}\backslash )$ & Oral & $10$ & $24304/14$ & $\backslash \backslash$

$\backslash$hline & & & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

PatientMedicalForm$($patientid$,$ full name, ward, drug, number, drug, name, description, dosage, method of administration, units$\_$per day, start$\_$date, end date$)$