Question: I need help inserting data using sql Table Name: DEPENDENT X Data Type Employee SSN CHAR) Constraint Foreign Employee (SSN) NOT NULL ON DELETE CASCADE

I need help inserting data using sql  I need help inserting data using sql Table Name: DEPENDENT X
Data Type Employee SSN CHAR) Constraint Foreign Employee (SSN) NOT NULL ON

Table Name: DEPENDENT X Data Type Employee SSN CHAR) Constraint Foreign Employee (SSN) NOT NULL ON DELETE CASCADE Attribute NOT NULL Name VARCHAR(15 Gender CHECK (M,F, 'm', T Sex CHAR Birthday Relationship DATE VARCHAR(8) Hint you have two ways to define forcign key, one is to define forcign key within the CREATE TABLE statement, for example CREATE TABLE products (product id numerict(10) not naull, supplier id numeric( 10), CONSTRAINT fk supplier FOREIGN 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 ALTERTABLE statement (sometimes you might have to do like this), for example ALTER TABLE Products ADD CONSTRAINT fk_supplier FOREIGN KEY (supplier id) REFERENCES suppliersupplier id) ON DELETE SET NULL 2. Insert Data Table Name: EMPLOYEE X SSN FName Mini LName BDate Address Sex |Salary! SuperSSN | Dep 554433221 543216789 E Gilbert 9-JUN-60 11 5 59 E, Salit Lake City, UT M 80000 NULL3 PAN 07-FEB-78 35 S 18 E, Salt Lake City, UT F 70000 NULL2 M14000(1554433221| 5 lem er I-Wallace 2 NUN-31 291Eerry,Bellaire,TX-F 43000 554433221 4 B Smith 09-JAN-55 731 Fondren, Houston, TX M 30000 3334455555 334455S FrnkinT Wong 08-DEC-45 638 Voss, llouston, TX | 987654321 123456789 66653444sh K Narayan15-SEP-2 975 Fire Oak, Humble, TX M 38000 33445555 453453453 oyee A Engish 31-JUL-62 5631 Riee, Houston, IX F 25000 333445555 5 888665555 James E 10-NOV-27 450 Stone, Houston, TX M 55000 543216789 99988777 AliciaZelaya 19-JUL-58 3321 Castle, Spring, IX F 25000 987654321 M 25000 9876543214 Table Name: DEPARTMENT xxx MgrSSNMgrDate 888665555 19-JUN-71 Manufacture

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!