Table Name: DEPENDENT XXX Data Type Primary Foreign Constraint Employee SSN CHAR(9)7 Employee (SSN) NOT NULL ON DELETE CASCADE Dependent Name VARCHAR(15) Sex NOT NULI Gender CHECK CHAR Birthday Relationship VARCHAR(S) DATE Hint: you have two ways to define forcign key, one is to define forcign key within the CREATET statement, for example CREATE TABLE products (product_ id numeric(10) not null, supplier_id numeric(10), CONSTRAINT fk KEY (supplier id) REFERENCES supplier(supplier id) ON DELETE SET NULL) Another way is to create table without defining foreign key and add foreign key later using the (sometimes you might have to do like this), for example ALTERTABLE statement ALTER TABLE Products ADD CONSTRAINT fk supplier FOREIGN KEY (supplier _id) REFERENCES supplier(supplier_id) ON DELETE SET NULL 2. Insert Data Table Name: EMPLOYEE xx SSN FName Mini LName BDate SuperSSN DepNo Address Sex E Gilbert0-JUN-60 1S 59 E, Salt Lake City, UT M 80000 NULL PAN T /wong- 07-FEB-78 35 S 18E, Salt Lake City, UT 543216789 Joyce NULL 08-DEC-45 638 Voss. Ilo sto . TX-- | 5 333445555 Frankin 987654321 M 40000154433221 FASO DenniferTs/wallace 20-JUN-311291 Berry, Bellaire,TX 23456789 Jon B Smith 09-JAN-55 731 Foedren, Houston, TX M 30000 333445555 s 8000 3334455 5 F 25000 333445555 5 666884444 Ramesh K Narayan 15-SEP-52 975 Fire Oak, Humble, TX M 3 453453453 888665555 ames EBorg 10-Nov-27 450 Stone, Houston, TX 999887777 Alicia 987987987 Ahmad V Jabbar 29-MAR-59 980 Dallas, Houston, TX M 25000 987654321 4 English! 31-JUL-62 Zelaya 119-JUL-58 JoyceA ve IA 5631 Rice, Houston, TX M 55000 543216789 25001987654321| 3321Castle, SprineTX-| F 4 Table Name: DEPARTMENT Xx DName Manufacture MgrSSNMgrDate 888665555 19-JUN-71