create table Employee (firstNAme varchar2(15) not null,LastName varchar2(15) not null,Minit char,SSN char(9) not null,Bdate date,Address Varchar2(30),Sex char,Salary  Decimal(10,2), Super_Ssn  char(9),Dno int not null,PRIMARY KEY(SSN))


--insert into Employee values("John","Smith","B",123456789,'1965-01-09',"731 Fondren,Houston, TX", "M",30000,333445555,5)
--insert into Employee values("Franklin","Wong","T",333445555,'1955-12-08',"638 Voss,Houston, TX", "M",40000,888665555,5)
--insert into Employee values("Alicia","Zelaya","J",999887777,'1968-01-19',"3321 Castle,Spring, TX", "F",25000,987654321,4)
--insert into Employee values("Jennifier","Wallace","S",987654321,'1941-06-20',"291 Berry,Ballaire, TX", "M",38000,333445555,5)
--insert into Employee values("Ramesh","Narayan","K",666884444,'1962-09-15',"975 Fire Oak,Humble, TX", "M",43000,888665555,4)
--insert into Employee values("Joyce","English","A",453453453,'1972-07-31',"5631 Rice,Houston, TX", "F",25000,333445555,5)
--insert into Employee values("Ahmad","Jabbar","V",987987987,'1969-03-29',"980 Dallas,Houston, TX", "M",25000,987654321,4)
--insert into Employee values("James","Borg","E",888665555,'1937-11-10',"450 Stone,Houston, TX", "M",55000,Null,1)insert into Employee values("John","Smith","B",123456789,'1965-01-09',"731 Fondren,Houston, TX", "M",30000,333445555,5)
--insert into Employee values("Franklin","Wong","T",333445555,'1955-12-08',"638 Voss,Houston, TX", "M",40000,888665555,5)
--insert into Employee values("Alicia","Zelaya","J",999887777,'1968-01-19',"3321 Castle,Spring, TX", "F",25000,987654321,4)
--insert into Employee values("Jennifier","Wallace","S",987654321,'1941-06-20',"291 Berry,Ballaire, TX", "M",38000,333445555,5)
--insert into Employee values("Ramesh","Narayan","K",666884444,'1962-09-15',"975 Fire Oak,Humble, TX", "M",43000,888665555,4)
--insert into Employee values("Joyce","English","A",453453453,'1972-07-31',"5631 Rice,Houston, TX", "F",25000,333445555,5)
--insert into Employee values("Ahmad","Jabbar","V",987987987,'1969-03-29',"980 Dallas,Houston, TX", "M",25000,987654321,4)
--insert into Employee values("James","Borg","E",888665555,'1937-11-10',"450 Stone,Houston, TX", "M",55000,Null,1O