DBMS--SQL

Title: Pharmacy Management

What is the normalization (1NF, 2NF, 3NF) For this:

TABLE Supplier (Sup_ID INT PRIMARY KEY NOT NULL, Sup_Name VARCHAR(255) NOT NULL, Sup_Address VARCHAR(255), Sup_Phone_No INT(11), Sup_Email VARCHAR(255));

TABLE Products (Prod_ID INT PRIMARY KEY NOT NULL, Prod_Name VARCHAR(75) NOT NULL, Description VARCHAR(255), Manufacturer VARCHAR(75), Prod_Manufacturing_Date DATE , Prod_Expiry_Date DATE, Prod_Type VARCHAR(25), Quantity INT, Price DECIMAL(10,2), Sup_ID INT, FOREIGN KEY (Sup_ID) REFERENCES Supplier(Sup_ID));

TABLE Customers (Cust_ID INT PRIMARY KEY NOT NULL, Cust_FName VARCHAR(25) NOT NULL, Cust_LName VARCHAR(25) NOT NULL, Gender VARCHAR(10), Cust_Age INT, Cust_Phone_No INT(11) , Cust_Address VARCHAR(255) , PostCode INT(5), Email VARCHAR(255), Password VARCHAR(255));

Table Employees (Emp_ID INT PRIMARY KEY NOT NULL, Emp_FName VARCHAR(25) NOT NULL, Emp_LName VARCHAR(25) NOT NULL, Emp_Age INT, Gender VARCHAR(20), Emp_Phone_No INT(11) , Emp_Address VARCHAR(255) , PostCode INT(5), Email VARCHAR(255), Password VARCHAR(255));

TABLE CustomerOrder (Order_ID INT PRIMARY KEY NOT NULL, Cust_ID INT, Emp_ID INT, Prod_ID INT, Quantity INT, Price DECIMAL(10,2), OrderDate DATE, FOREIGN KEY (Cust_ID) REFERENCES Customers(Cust_ID), FOREIGN KEY (Prod_ID) REFERENCES Products(Prod_ID), FOREIGN KEY (Emp_ID) REFERENCES Employees(Emp_ID));