what is normalization and explain why it is 3NF?

this is my database for the hostel management system..according to this provide me answer for normalization and why it is 3NF

and please provide unique answer

o hostel userregistration id: int(11) regNo: varchar(255) firstName : varchar(255) e middleName : varchar(255) @lastName : varchar(255) gender: varchar(255) # contactNo: bigint(20) email : varchar(255) @ password : varchar(255) a regDate: timestamp updation Date : varchar(45) passUdateDate : varchar(45) VO hostel admin & id: int(11) username : varchar(255) email : varchar(255) @ password: varchar(300) reg_date: timestamp o updation_date: date o hostel adminlog #id: int(11) # adminid : int(11) ip: varbinary (16) o logintime : timestamp 0 hostel userlog aid: int(11) # userld: int(11) userEmail: varchar(255) userlp: varbinary (16) city : varchar(255) country : varchar(255) login Time: timestamp hostel registration id: int(11) # roomno : int(11) # Seater: int(11) # feespm : int(11) #foodstatus : int(11) o stay from : date # duration : int(11) course : varchar(500) # regno: int(11) @firstName : varchar(500) @middleName: varchar(500) lastName : varchar(500) gender : varchar(250) # contactno: bigint(11) emailid : varchar(500) # egycontactno: bigint(11) guardianName : varchar(500) guardianRelation : varchar(500) # guardian Contactno: bigint(11) @corres Address : varchar(500) corres City : varchar(500) corres State: varchar(500) # corres Pincode : int(11) @ pmntAddress : varchar(500) @ pontCity : varchar(500) @pmnatetState: varchar(500) # pmntPincode : int(11) postingDate: timestamp @updation Date : varchar(500) o hostel rooms id: int(11) # Seater: int(11) # room_no: int(11) # fees : int(11) o posting_date: timestamp o hostel states o hostel courses 2 id: int(11) e course_code : varchar(255) course_sn : varchar(255) @ course_fn : varchar(255) posting_date: timestamp id: int(11) State: varchar(150)