DATABASE MANAGEMENT(MYSQL) Normalization

How will the tables of the data be after applying 1NF, 2NF, 3NF

(Whether Boyce-Codd Normal Form is applied or not is optional)

GYM_ID 1 GYM_Name Max Fitness Max Fitness 2 Max Fitness 3 GYM_Address 3001 sok no 3 Izmir 5069 sok no 1 Izmir 8257 sok no 8 zmir GYM_PhoneNumber 2322264639 2322386745 2325247890 GYM_Email maxfitness@gmail.com maxfitness2@gmail.com maxfitness3@gmail.com GYM_OpeningYear 2005 2012 2020 Table1 2 3 Manager_ID Manager_Name 1 Volkan 2 Emel 3 Murat NULL NULL Manager_Surname Ekinci Ekinci Manager_Salary(s) Manager_StartingDate Manager_PhoneNumber 15000 2005-02-02 5347234598 10000 2012-01-01 5325792837 8000 2020-03-03 5379478235 NULL Table2 Ekinci NULL NULL NULL Employee_ID Gym_ID 1 1 2 Manager_ID 1 1 1 Employee_Name Employee_Surname Employee_Gender Employee_Job Ekin Togay Male Personel Trainer Yonca Gken Female Personel Trainer Atakan Arabac Male Personel Trainer Alaattin Egemen Male Cleaning staff Hasan Doramac Male Personel Trainer Ayegl Adigzel Female Personel Trainer Employee_Salary($) 5000 5000 5000 2000 5000 5000 Employee_StartingDate Employee_PhoneNumber 2006-09-01 5324256789 2008-10-02 5428628492 2007-02-06 5055518012 2005-03-08 5428628496 2013-09-11 5067624769 2016-05-03 506 7648724 1 1 3 4 5 6 Table 3 1 1 2 2 2 2 2 Customer_ID 1 1 Membership_ID 1 2 3 4 5 2 3 Table 4 4 Membership_Type Fitness BodyBuilding BodyBuilding Fitness BodyBuilding BodyBuilding Fitness BodyBuilding BodyBuilding Fitness BodyBuilding Membership Fee($) 10000 20000 20000 10000 20000 20000 10000 20000 20000 10000 20000 5 6 7 8 9 10 11 6 6 7 8 8 Customer_Name Customer_ID 1 2 3 4 Customer Surname Tun ay akrak ztekin Gkek Akgl Erol Musa Atakan Bra Murat Sultan Jale Erdin Customer_Gender Male Male Female Male Female Female Male Customer_CardNo 492987672728 1852 4532439059168673 4556367020263607 5454878142695328 532887 1652265891 5296085538280838 6011388440531914 Customer_Phone Number 5055518066 5555570158 5355579367 5486254186 5070498042 5067648769 5567194278 Customer_Address 3027 sok no 2 d 2 Izmir 3058 sok no 6 d 8 zmir 3092 sok no 8 d 3 Izmir 3047 sok no 3 d 5 Izmir 5029 sok no 2 d 9 zmir 5235 sok no 6 d 2 Izmir 5862 sok no 9 d 1 zmir Table 5 5 6 7