Create table in mysql

click here to download DBMS 1 practical 5
answers for dbms 1 practical 5


create table dept_1 (
dno int primary key,
dname varchar(30)
);




create table emp (
eno int primary key,
nic varchar(30),
ename varchar(30),
address varchar(30),
dnum int
references dept_1(dno)
);




create table project_1(
pno int primary key,
pname varchar(30),
location varchar(30),
);


create table worked_on(
eno int,
pno int,
hired_date datetime,
houres int,
primary key (eno,pno),
constraint worked_on_fk1 foreign key (eno)
references emp,
constraint worked_on_fk2 foreign key (pno)
references project_1


);






insert into dept_1 values(5,'IT')
insert into dept_1 values(6,'IS')
insert into dept_1 values(7,'CSN')
insert into dept_1 values(8,'IT')




insert into emp values(100,'901250087V','Smith,John B','731 Fondren Houston',5)
insert into emp values(101,'895290452V','Wrong, Franklin T.','638 Voss Houston',5)
insert into emp values(102,'923859070V','Zelaya,f Alicia J.','33321 Castle Spring',4)
insert into emp values(103,'918257988V','Wallace, Jennifer S','291 Berry Bellaria',4)
insert into emp values(104,'904850045V','Narayan, Remesh K.','975 Fire Oak Humble',5)
insert into emp values(105,'889950600V','English, Joyce A.','5631 Rice Houston',1)
insert into emp values(106,'915850123V','Jabbar, Ahamad V','980 Dallas Housr',1)




insert into project_1 values(1,'Road Construction','Bellaire')
insert into project_1 values(2,'Power plant','Sugarland')
insert into project_1 values(3,'Reproduction','Houston')
insert into project_1 values(4,'Recycling','Stafford')




insert into worked_on values(100,1,12-04-2011,12)
insert into worked_on values(101,2,25-02-2011,1)
insert into worked_on values(102,3,15-05-2011,20)
insert into worked_on values(103,4,02-06-2011,50)
insert into worked_on values(104,5,08-06-2011,5)
insert into worked_on values(105,6,12-07-2011,3)
insert into worked_on values(106,7,20-07-2011,40)
insert into worked_on values(100,1,18-05-2011,1)
insert into worked_on values(100,1,01-07-2011,11)
insert into worked_on values(100,1,27-06-2011,1)