WpHG16mc

1create table if not exists DEPT_LOCATION
2(
3	Dnumber int,
4    Dlocation varchar(50)
5);
6
7
8
9create table if not exists PROJECT
10(
11	Pname varchar(50),
12    Pnumber int,
13    Plocation varchar(100),
14    Dnum int
15);
16
17
18
19create table if not exists WORKS_ON
20(
21	Essn long,
22    Pno int,
23    Hours float
24);
25
26
27
28create table if not exists DEPENDENT
29(
30		Essn long,
31        Dependant_name varchar(50),
32        Sex varchar(1),
33        Bdate date,
34        Relationship varchar(50)
35);