how can I create create 5 ALTER Table Statements for the Homework Database.  The Collection of ALTER TABLE Statements should include at least one of the following   ADD Clause Modify Clause CHANGE COLUMN Clause RENAME TO Clause.

how can I create

create 5 ALTER Table Statements for the Homework Database.  The Collection of ALTER TABLE Statements should include at least one of the following

1. ADD Clause
2. Modify Clause
3. CHANGE COLUMN Clause
4. RENAME TO Clause. 

• Each of the ALTER TABLE Statements must be preceded by a statement to display the structure of the table being modified.
  
  
• After successfully executing each ALTER TABLE Statement, the ALTER TABLE statement should be followed by another statement displaying the modified structure of the table.  

• Relational schema

The primary key is bold and the foreign key is italic

Region(regionID, regionName, director)

StateOfRegion(stateCode, stateName, statePopulation, RegionID)

Store(StoreID, phone, manager, address, regionID)

Employee(empID, storeID, empName, hireDate, birthDate, socSecNum)

Supplier(supplierID, SupplierName, contact, email, phone)

StoreSupplier(storeID, supplierID, startDate)

• Meta dataThe metdata for each table from the given ER diagram is as below 

• The create table script:

DROP DATABASE IF EXISTS RegionStore;

CREATE DATABASE RegionStore;

USE  RegionStore;

CREATE TABLE Region

(

regionID         VARCHAR(10),

regionName       VARCHAR(50),

supervisor       VARCHAR(50),

CONSTRAINT PRIMARY KEY (regionID)

);

CREATE TABLE Store 

(

storeID           VARCHAR (10),

storeAddress      VARCHAR (50),

phone             VARCHAR (10),

Manager           VARCHAR (10),

regionID_FK       VARCHAR (10),

CONSTRAINT PRIMARY KEY (storeID),

CONSTRAINT FOREIGN  KEY (regionID_FK)  

REFERENCES REGION (regionID)

);

CREATE TABLE Employee

(

empNum             VARCHAR (10),

empName            VARCHAR (50),

hireDate           DATE,

birthDate          Date, 

socSecNum          CHAR(9),

storeID_FK         VARCHAR(10),

CONSTRAINT PRIMARY KEY (empNum),

CONSTRAINT FOREIGN KEY (storeID_FK)

REFERENCES Store(storeID)

);

CREATE TABLE Supplier

(

supplierID             VARCHAR (10),

supplierName           VARCHAR (50),

contact                VARCHAR (50),

phone                  CHAR (10),

email                  VARCHAR (50),

CONSTRAINT PRIMARY KEY (supplierID)

);

CREATE TABLE Supplies

(

supplierID_FK          VARCHAR (10),

storeID_FK             VARCHAR (10),

startDate              DATE,

CONSTRAINT PRIMARY KEY (supplierID_FK,storeID_FK )

);

CREATE TABLE StateOfRegion

(

stateCode                CHAR(2),

stateName                VARCHAR(50),

regionID_FK              VARCHAR(10),

statePopulation          INT,

CONSTRAINT PRIMARY KEY (stateCode),

CONSTRAINT FOREIGN KEY (regionID_FK )

REFERENCES REGION(regionID)

);

INSERT INTO region (regionID,regionName,supervisor)

VALUES ('001','Alabama','Henry');

INSERT INTO Region (regionID,regionName,supervisor)

 VALUES ('003','wellington','katty');

INSERT INTO Region (regionID,regionName,supervisor)

 VALUES ('004','hamilton','ross');

INSERT INTO Region (regionID,regionName,supervisor)

 VALUES ('005','auckland','robert');