Database Write the SQL command for the following statement based on the Figure 1.a)Drop the constraint PropertyForRent_branchNo_fk from table PropertyForRent.b)Change the table name PropertyForRent to PropertyRent.Add column ownerBirthDate with appropriate data type to Owner, containingdates.d)Drop column ownerType from Owner table.e)Disable temporary the foreign key Branch_mgrstaffNo_fk in the Owner table. 7. Assume the SQL command in Figure 1 have been executed.CREATE TABLE OwnerownerNo NUMBER(6),ownerType NUMBER(1),CONSTRAINT Owner ownerNo_pk PRIMARY KEY (ownerNo));CREATE TABLE Branch(branchNo NUMBER(6),mgrstaffNo NUMBER(6),CONSTRAINT Branch branchNo_pk PRIMARY KEY (branchNo),CONSTRAINT Branch mgrstaffNo_fk FOREIGN KEY (mgrstaffNo)REFERENCES Manager(staffNo));CREATE TABLE StaffstaffNo NUMBER(6),supervisorStaffNo NUMBER(6),branchNo NUMBER(6),CONSTRAINT Staff_staffNo_ pk PRIMARY KEY (staffNo));CREATE TABLE PropertyForRentpropertyNo NUMBER(6),ownerNo NUMBER(6),staffNo NUMBER(6),branchNo NUMBER(6),CONSTRAINT PropertyForRent propertyNo_pk PRIMARY KEY (propertyNo),CONSTRAINT PropertyForRent ownerNo_fk FOREIGN KEY (ownerNo)REFERENCES Owner(ownerNo),CONSTRAINT PropertyForRent_staffNo_fk FOREIGN KEY (staffNo)REFERENCES Staff(staffNo),CONSTRAINT PropertyForRent_branchNo_fk FOREIGN KEY (branchNo)REFERENCES Branch(branchNo));

A.ALTER TABLE PropertyForRent DROP CONSTRAINT PropertyForRent_branchNo_fk; B.RENAME TABLE…

Write the SQL command for the following statement based on the Figure 1. a) Drop the constraint PropertyForRent_branchNo _fk from table PropertyForRent. b) Change the table name PropertyForRent to PropertyRent. Add column ownerBirthDate with appropriate data type to Owner, containing dates. d) Drop column ownerType from Owner table. Disable temporary the foreign key Branch_mgrstaffNo_fk in the Owner table.