sql example project

//--------------- Create table ------------------
 create table Employee(
Emp_id char(20)  primary key,
F_name varchar(15),
M_name varchar(15),
L_name varchar(15),
Gender varchar(15),
Salary numeric(8,2),
Address varchar(15),
Dept_no varchar(20));

create table Department(
Dept_no char(20) primary key,
Dept_name varchar(20),
Location varchar(15),
Employees varchar(15),
Manager_id char(10),
Start_date varchar(15))

create table Project(
P_id char(20) primary key,
P_name varchar(20),
P_loc varchar(20),
Leading_dept char(20));

create table Relative (
Emp_id char(20),
F_name varchar(20),
M_name varchar(20),
L_name varchar(20),
DOB varchar(20),
Gender varchar(20),
Relation varchar(20));

create table Workson(
Emp_id char(20),
P_id char(20),
Worked_hours varchar(20),
primary key (Emp_id ,P_id));

//-------------------- Insert All Table -----------------------------------------------------
** Employee Table

insert into Employee values ('0000001','Abd','zuher','abukaraki','male','10000','Aqaba','100');
insert into Employee values ('0000002','Khalid','zuher','abukaraki','male','500','Amman','101');
insert into Employee values ('0000003','Ahmad','Ibrahem','Matar','male','900','Zarqa','102');
insert into Employee values ('0000004','Eid','Ahmad','Seed','male','10500','Irbad','103');
insert into Employee values ('0000005','Yosif','Sami','Hamed','male','5550','Aqaba','104');
insert into Employee values ('0000006','Sara','Mohammed','Rabie','female','5800','Irbad','105');
insert into Employee values ('0000007','Ruba','Ahmad','Fwaz','female','6550','Alkarak','106');
insert into Employee values ('0000008','Fesal','Ibrahem','Mansor','male','7550','Amman','107');
insert into Employee values ('0000009','Fadwa','Basl','Deab','female','10500','Aqaba','108');
insert into Employee values ('0000010','Omar','Fares','Kamil','male','9500','Zarqa','109');

** Department Table

insert into Department values('100','Account','Building1','20','3120027','25_3_2005');
insert into Department values('101','Sales','Building2','15','3120028','2/5/2008');
insert into Department values('102','Management','Building3','13','3120035','3/5/2001');
insert into Department values('103','Insurance','Building3','9','3120030','6/1/2006');
insert into Department values('104','Human Resources','Building1','25','3120029','9/3/2009');
insert into Department values('105','IT','Building2','18','3120033','21/7/2007');
insert into Department values('106','Marketing','Building5','27','3120036','35/6/2004');
insert into Department values('107','Finance Affairs','Building5','6','3120034','17/5/2008');
insert into Department values('108','Public Relations','Building4','11','3120032','11/5/2010');
insert into Department values('109','Reception','Building','14','3120031','2/1/2012');

** Project Table

insert into Project values('3200','Ayla','Aqaba','1000');
insert into Project values('3201','Saraya','Amman','1001');
insert into Project values('3202','School','Aqaba','1002');
insert into Project values('3203','Flats','Zarqa','1003');
insert into Project values('3204','Banks','Irbad','1004');
insert into Project values('3205','Museum','Alkarak','1000');
insert into Project values('3206','Mole','Jerash','1002');
insert into Project values('3207','Restaurant','Jerash','1003');
insert into Project values('3208','Mole3','Amman','1006');
insert into Project values('3209','Mole2','Jerash','1005');

** Relative Table
insert into Relative values('3120027','Nader','Abdlarahman','Alahewat','2/1/2002','male','Descendant');
insert into Relative values('3120027','Baian','Abdalrahman','Alahewat','3/5/2001','female','Descendant');
insert into Relative values('3120028','Dawod','Khalid','Naser','12/2/2005','male','Descendant');
insert into Relative values('3120028','Saja','Khalid','Naser','3/5/2000','female','Descendant');
insert into Relative values('3120029','Sami','Ahmad','Matar','5/5/2004','male','Descendant');
insert into Relative values('3120030','Belal','Eid','Seed','2/3/2000','male','Descendant');
insert into Relative values('3120030','Marwa','Eid','Seed','1/8/2007','female','Descendant');
insert into Relative values('3120033','Fares','Ahmad','Fwaz','5/6/2000','male','Descendant');
insert into Relative values('3120032','Fatima','Omar','Kamil','4/7/1999','male','Descendant');
insert into Relative values('3120036','Eman','Omar','Kamil','5/4/1997','female','Descendant');

** Workson Table

insert into Workson values('3120027','3200','12');
insert into Workson values('3120028','3201','11');
insert into Workson values('3120029','3202','10');
insert into Workson values('3120030','3203','11');
insert into Workson values('3120031','3204','12');
insert into Workson values('3120032','3205','10');
insert into Workson values('3120033','3206','11');
insert into Workson values('3120034','3207','9');
insert into Workson values('3120035','3208','12');
insert into Workson values('3120036','3209','10');

//----------------------------- Add Foreign Key --------------------------------------
Alter Table Employee ADD(Foreign key (Dept_no)
References Department (Dept_no));

Alter Table Department ADD(Foreign key (Manager_id)
References Employee (Emp_id));

Alter Table Project ADD(Foreign key (Leading_dept)
References Department (Dept_no));

Alter Table Relative ADD(Foreign key (Emp_id)
References Employee (Emp_id));

Alter Table Workson ADD(Foreign key (Emp_id)
References Employee (Emp_id));

Alter Table Workson ADD(Foreign key (P_id)
References Project (P_id));