University of South African is the biggest academic institution in Republic of South Africa and in the continent of Africa. UNISA is conducting graduation in different places in South Africa. The graduations are being conducted in Pretoria, Polokwane, Durban, and Cape Town. UNISA has a total of $9$ colleges and graduations are conducted for all the colleges. The colleges are Accounting Sciences, Economic and Management Sciences, Human Sciences, Science, Engineering and Technology, Graduate School of Business Leadership, Agriculture and Environmental Sciences, Education, Law, and Graduate Studies. All these colleges offer different qualifications. Each and every session needs to have Chancellor and someone delivering chancellor address. On top of that, there are academics that needs to be part of academic procession which include academics which includes deans of colleges and directors of the school. The sample information had been provided below. In answering the questions below, you are free to add more columns to develop a complete solution. Graduation Date College Venue Location Student Graduation Session Session Start Time Qualification Province $04/06/2021$ CSET Eskia Mphahlele Pretoria Themba Masombuka Session C $18$:$00$ PHD Gauteng $04/06/2021$ CAES Eskia Mphahlele Pretoria Samson Mthimkhulu Session B $15$:$00$ BA Gauteng $04/06/2021$ LAW Eskia Mphahlele Pretoria Sipho Mkhize Session A $10$:$00$ LLB Gauteng $04/06/2021$ CEDU Eskia Mphahlele Pretoria Mhlana Siphe Sesssion B $15$:$00$ BED Gauteng $04/06/2021$ CSET Eskia Mphahlele Pretoria Buhle Mahlangu Session C $18$:$00$ BSC Gauteng $07/07/2021$ CSET Durban Convention Centre Durban Alfred Gambu Session A $10$:$00$ BSC KwaZulu Natal $07/07/2021$ CEDU Durban Convention Centre Durban Sipho Mthethwa Session A $10$:$00$ BED KwaZulu Natal $07/07/2021$ LAW Durban Convention Centre Durban Simphiwe Mkhize Session B $15$:$00$ LLB KwaZulu Natal $07/07/2021$ Accounting Science Durban Convention Centre Durban Sipho Mthethwa Session C $18$:$00$ BACC KwaZulu Natal $23/07/2021$ Accounting Science Themba Mnguni Building Pearl Anele Davidson Session C $18$:$00$ BACC Cape Town $23/07/2021$ Accounting Science Themba Mnguni Building Pearl Patrick van Berg Session A $10$:$00$ BACC Cape Town $23/07/2021$ CEDU Themba Mnguni Building Pearl Cynthia Buthelezi Session B $15$:$00$ BED Cape Town $23/07/2021$ CSET Themba Mnguni Building Pearl Cynthia Koen Session C $18$:$00$ BEng Cape Town $29/07/2021$ CSET Kgotsong Building Polokwane Tsepo Mohlala Session A $10$:$00$ BEng Polokwane $29/07/2021$ CEDU Kgotsong Building Polokwane Thabo Moganetsi Session B $15$:$00$ BED Polokwane $29/07/2021$ Human Sciences Kgotsong Building Polokwane Tsepo Mabelane Session C $18$:$00$ BArt Polokwane $29/07/2021$ Human Science Kgotsong Building Polokwane Thokozane Masombuka Session A $10$:$00$ Bart Polokwane

 $1.$  Create a dependency diagram that is in the First Normal Form $(10)$

$2.$  Create a dependency diagram that is in Second Normal Form $(5)$

$3.$  Create a dependency diagram that is Third Normal Form $(5)$

$4.$  Using the same table, develop five business rules $(5)\mathrm{}$

$5.$  Create an entity relationship Diagram using the results of $3$ and incorporate the business.