Use this table and the detailed discussion of normal forms on pages $99-100$ to answer the following questions:

$1.)$ Define $1$NF$.$ Is the STUDENT table in $1$NF$?$ If not, why not, and what would have to be done to put it into $1$NF$?$ Make any changes necessary to put STUDENT into $1$NF and show the updated design. If this step requires you to create an additional table, make sure that the new table is also in $1$NF$.$

$2.)$ Define $2$NF$.$ Now that STUDENT table is in $1$NF$,$ is it also in $2$NF$?$ If not, why not, and what would have to be done to put it into $2$NF$?$ Make any changes necessary to put STUDENT into $2$NF and show the updated design. If this step requires you to create an additional table, make sure that the new table is also in $2$NF$.$

$3.)$ Define $3$NF$.$ Now that STUDENT table is in $2$NF$,$ is it also in $3$NF$?$ If not, why not, and what would have to be done to put it into $3$NF$?$ Make any changes necessary to put STUDENT into $3$NF and show the updated design. If this step requires you to create an additional table, make sure that the new table and any other tables created in previous steps are also in $3$NF$.$

$4.)$ Define BCNF$.$ Now that STUDENT table is in $3$NF$,$ is it also in BCNF$?$ If not, why not, and what would have to be done to put it into BCNF$?$ Make any changes necessary to put STUDENT into BCNF and show the updated design. If this step requires you to create an additional table, make sure that the new table and any other tables created in previous steps are also in BCNF$.\backslash$table$[[$StudentID$,$CourseNo,LastName,FirstName,GPA,CourseDescription,RoomNumber$],[$S$0000001,$CPD$121,$Hoover,Bob,$4\mathrm{.}0,$Data Modeling and Database Design,C$215],[$S$0000002,$CSE$121,$Yaeger,Fred,$3\mathrm{.}6,$Programming Logic,K$106],[$S$0000003,$GIS$123,$Ray,Linda,$3\mathrm{.}9,$Maps and Map Reading,C$213],[$S$0000004,$CPD$121,$Loomis,Jessica,$3\mathrm{.}8,$Data Modeling and Database Design,C$215],[$S$0000005,$CSE$121,$Ison,Mike,$3\mathrm{.}7,$Programming Logic,K$106],[$S$0000006,$CPD$121,$Goe,Melinda,$4\mathrm{.}0,$Data Modeling and Database Design,C$215]]$