How to do normalization step for this project. This is the DDL commands.

Thank you

CREATE TABLE Buyer $($ buyer$\_$id INT PRIMARY KEY, buyer$\_$name VARCHAR$(250),$ buyer$\_$address VARCHAR$(250),$ buyer$\_$contact INT, occupation VARCHAR$(250),$ salary INT, credit$\_$score INT$)$;CREATE TABLE Properties $($ prop$\_$id INT PRIMARY KEY, parcel$\_$num VARCHAR$(250),$ prop$\_$adress VARCHAR$(250),$ num$\_$rooms INT, total$\_$sq FLOAT, purchase$\_$amt FLOAT, purchase$\_$date DATE, market$\_$value FLOAT,FOREIGN KEY $($arch$\_$id$)$ REFERENCES Architecture$\_$Style$($arch$\_$id$),$FOREIGN KEY $($buyer$\_$id$)$ REFERENCES Buyer$($buyer$\_$id$),$FOREIGN KEY $($ag$\_$id$)$ REFERENCES Agents$($ag$\_$id$))$;CREATE TABLE Architecture$\_$Style $($ arch$\_$id INT PRIMARY KEY, arch$\_$name VARCHAR$(250),$ arch$\_$descrip VARCHAR$(250))$;CREATE TABLE Employee $($ emp$\_$id INT PRIMARY KEY, emp$\_$name VARCHAR$(250),$ emp$\_$address VARCHAR$(250),$ emp$\_$phone VARCHAR$(20),$ emp$\_$role VARCHAR$(250))$;CREATE TABLE Contractor $($ con$\_$id INT PRIMARY KEY, con$\_$name VARCHAR$(250),$ con$\_$address VARCHAR$(250),$ con$\_$phone INT