$\backslash$table$[[$ame$,$andy,Prometion Ceodo$],[$Aabat$,$w$,$cos$],[$Ansat$,$w$,$con$],[$Ansat$,|\_($n$),$coN$],[$Ansost$,$w$,$con$],[$Adera$,\backslash$kappa $,$REN$],[$Adare$,$w$,$REN$],[$Adary$,$w$,$REN$],[,$w$,$cos$],[$Avens$,$w$,$cos$],[,$w$,$con$],[,$w$,$con$],[$Aevnest$,$N$,$cos$],[$Aemout$,$w$,$cos$],[$Aemust$,$w$,$con$],[$Aement$,$w$,$con$],[$Duans$,$N$,$cos$],[$Aumes:$,$w$,$coN$],[$Duane:$,$w$,$coN$],[$Chang$,$w$,$cos$],[$Chang$,$w$,$cos$],[$Ctang$,$w$,$con$],[$Donenen$,$w$,$con$],[$Deneson$,$w$,$cos$],[$Donenen$,$w$,$cos$],[$Dete$,$r$,$ous$],[$Det$,|,$ous$],[$Easien$,$N$,$cos$],[$Esasen$,|,$cos$],[$Esdesn$,$w$,$con$],[$Froat$,|$r$,$ous$],[$Froat$,|$r$,$ous$],[$Gepa$,$w$,$cos$],[$G$$pa$,$w$,$coN$],[$Gepo$,$N$,$cos$],[$Gons$,\backslash$gamma $,$ous$],[$and$,|$r$,$ous$],[$Grey$,|$r$,$ous.$],[$Hastan$,$N$,$cos$],[$Hastan$,|,$cos$],[$Hastan$,$w$,$con$],[$Hastan$,$w$,$con$],[$Heanthoms$,$w$,$REN$],[$Heantoors$,$w$,$REN$],[$Heantoms$,$w$,$REN$],[$togas$,$w$,$CoN$],[$maga$,$w$,$cos$],[$hags$,$w$,$con$],[$Aarma$,|,$coN$],[$Sarmat$,$w$,$cos$],[$sarmat$,$w$,$cov$],[$Jeres$,$w$,$coN$],[$seres$,$w$,$con$],[$Nead$,\backslash$gamma $,$cos$],[$Naded$,|$r$,$coN$],[$Kadd$,|\backslash$gamma $,$cos$],[$Luave:$,$N$,$coN$],[$Lurnet$,$w$,$cov$],[$Luave:$,$w$,$coN$],[$Lurne$,$w$,$con$],[$u$,\backslash$kappa $,$cos$],[$u$,$w$,$cov$],[$u$,$w$,$cos$],[$u$,$w$,$con$],[$Logen$,\backslash$kappa $,$REN$],[$Login$,$w$,$REN$],[$Logen$,$w$,$REN$],[$hastr$,$n$,$REN$],[$hask$,$w$,$REN$],[$weata$,$w$,$coN$],[$meata$,$w$,$con$],[$neate$,$w$,$con$],[$hearian$,$w$,$REN$],[$mesrum$,|,$REN$],[$mestan$,$w$,$REN$],[$Pyriner$,$N$,$cos$],[$Pyiner$,$w$,$coN$],[$Pyrrer$,$w$,$CoN$],[$Parrer$,$w$,$cos$],[$Pony$,$w$,$cov$],[$Pany$,$w$,$con$],[$Pany$,$w$,$con$],[$Prids$,$N$,$cos$],[$Pilde$,$w$,$coN$],[$Pride$.,$w$,$cos$],[$Pride$,$w$,$CoN$],[$Piber$,$N$,$REN$],[$Riber$,|,$REN$],[$Riber$,$N$,$REN$],[$Wheer$,$N$,$CON$],[$Wheer$,$N$,$cos$],[$Wheer$,$w$,$cos$],[$Wroer$,$w$,$CON$],[77$nith.,n$,$REN$],[$Zerith$,$n$,$REN$],[$Zonith$,$w$,$REN$]]$A spreadsheet has been created to store the results of students at Greendale Community College. This includes the annual promotion codes REN $($excluded$),$ CON $($can continue$),$ or QUA $($qualifies$),$ along with information about the courses, their prerequisites, and lecture periods. A mark out of $100$ and a grade symbol are also included in the dataset.

The symbol AB represents being absent from the exam, while DPR indicates duly performed refusal $$ not permitted to write the examination in the course due to poor attendance or failing to meet the minimum requirement.

You are required to normalize data given in the spreadsheet $($GreendaleCommunityCollege$)$ to $3$NF$.$

Show all the steps in your normalization process and present your final solution as relation schemas, and data tables $($i$.$e$.,$ each table must show sample data$),$ and normalized ERD. Clearly label the normal form at each stage of your normalization.