مطلوب مني تسليم الشيت بكرا وحالوت احل واعرف المشكله بس مافهمت مره يقولي invaled sql statment ومره
يقولmissing keyword سوت رن لكل البرنامج ولا جزئيه من البرنامج صوتلي رن لو سمحتو شوفيلي الكود في شي خطا
create tabel Employee(
First varchar(20)nout null,
Last varchar(20)not null,
ID integer not null,
Age integer,
constraint check Age
check(Age<61),
city varchar(10),
Dep_no integer default'7',
salary integer,
primary key(id),
foreign key(Dep_no)references Department(Dep_id),
on delete set default,
);
create domin dep_id_type as integer
check(value>0 and value<10);
creat table Department(
Dep_name varchar(10),
Dep_id Dep_id_type,
location varchar(10),
primary key (dep_id),
insert into Employee values('John','Jhons',99980,45,'Payson',1,3400);
insert into Employee values('Maray','Jones',99982,25,'Payson',1,5000);
insert into Employee values('Joine','Weber',88232,32,'San Diego',4,8000);
insert into Employee values('Ginger','Howell',98002,42,'Arizona',7,5000);
insert into Department values('Research',1,'Payson');
insert into Department values('Administration',4,'San Diego');
insert into Department values('Headquarters',7,'Arizona');
create table Family (
Employee_id integer not null,
MemberOfFamily_Name varchar(10) not null,
Sex char(1),
Age integer,
Relationship varchar (10),
primary key (Employee_id , MemberOfFamily_Name ),
foreign key (Employee_id) references Employee (ID)
on update cascade
on delete cascade);
insert into family values (99980, 'Majedah', 'F', 35, 'Spouse');
insert into family values (99980, 'Waleed', 'M', 5, 'Son');
insert into family values (99980, 'Maha', 'F', 16, 'Daughter');
insert into family values (99982, 'Ahmad', 'M', 25, 'Spouse');
insert into family values (99980, 'Hanan', 'F', 8, 'Daughter');
add column Marriage varchar(3);
update Employee
set Marriage = 'Yes'
where ID = 99980;
update Employee
set Marriage = 'Yes'
where ID = 99982;
update Employee
set Marriage = 'No'
where ID = 88323;
update Employee
set Marriage = 'No'
where ID = 98002;
select distinct City from Employee;
Select First, Last
from Employee E, Family F
where E.ID = F.Employee_id
and City = 'Payson'
and Relationship = 'Daughter';
select First, Last, MemberOfFamily_Name
from Employee E, Family F
where E.ID = F.Employee_id
and Marriage = 'Yes'
order by ID desc, MemberOfFamily_Name;
select First, Last
from Employee E, Family F
where E.ID = F.Employee_id
and Marriage = 'Yes'
and E.Age = F.Age;
select First, Last, Age
from Employee
where Age >= 25 and Age <= 32;
select max(Age), min (Age), avg(Age)
from Employee
where Marriage = 'Yes';
select count(*)
from Employee E, Family F
where E.ID = F.Employee_id
and First = 'John' and Last = 'Johns';
select ID, count(*), avg (F.Age)
from Employee E, Family F
where E.ID = F.Employee_id
group by ID
order by ID;
select First, count(*)
from Employee E, Family F
where E.ID = F.Employee_id
group by ID
having count(*) >1
order by ID;
create view Employee_Marriage as
select First, Last, MemberOfFamily_id
from Employee E, Family F
where E.ID = F.Employee_id
and Marriage = 'Yes'
and Relationship = 'Spouse';