[LTU]1016資料庫系統employee table

create table employee(
fname char(20) not null,
minit char(20) not null,
lname char(20) not null,
ssn int(10) not null primary key,
bdate date,
address varchar(50),
sex char(2) not null,
salary int(10) not null,
super_ssn int(10),
dno char(2));

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