How Do I Normalize Database

Table Name	Attribute	       Data Type	Relation
Department	Dept_id	               Integer	            PK	
                Dept_name              Varchar(100)

Program	         Prog_id	       Integer	            PK
                 Prog_name	       Varchar(150)
                 Dept_id	       Integer 	            FK

Semester	 Sem_id	               Integer	            Pk
                 Prog_id	       Integer	            Fk
                 Sem_no 	       Varchar(150)	

Session	         Session_id	       Integer	            Pk
	      Session_startyear        Varchar(20)	
	      Session_endyear	       Varchar(20)	
	         Dept_id	       Integer        	    FK

ClassRoom	Room_id	               Integer	            Pk
	        Room_label	       Varchar(50)	
	        Room_type	       Varchar(50)	
	        Room_id	               integer	            Fk
			
Subject	        Sub_id	               Integer	            Pk
	        Sub-name	       Varchar(150)	
	        Sem_id	               integer              Fk
	        Credithour	       Varchar	

Day	        Day_id	               Integer	            Pk
	        Day_name	       Varchar(150)	
	        Day_status	       Varchar(20)	
	        Time_id	               Integer	            FK

Teacher	        Teacher_id	       Integer	            Pk
	        Teacher_name	       Varchar(150)	
	        Teacher_address	       Varchar(150)	
	        Teacher_nic	       Varchar(20)	
	        Teacher_cellNo 	       Varchar(50)	
	        Teacher_email	       Varchar(100)	
	  Teacher_qualification	       Varchar(150)	
	    Teacher_interest	       Varchar(200)	
	        Dept_id	               integer	            Fk
	      Teacher_status	       Varchar(20)	

Time	        Time_id	               Integer   	    Pk
	        Duration	       Varchar(50)	
	        Starting_time	       Varchar(50)	
	        Ending_time	       Varchar(50)	
	        Day_id	               integer	            Fk
	        Class_id	       integer	            Fk
			
Subjectteacher	Subtech_id	       integer	            Pk
	        Sub_id	               integer        	    Fk
	        Teacher_id	       integer  	    Fk