create tabel Department and Employee related with a one to many relationship

 

Consider the following Department-employee database.  

Department (dno integer, dname varchar(20),city varchar(20)) 

Employee (eno  integer, ename varchar(20), salary  money) 

Department and Employee are related with a one to many relationship 

Create Tabel Department

 

Department (dno integer, dname varchar(20),city varchar(20)) 

create table Department (dno int  primary key, dname varchar(20),city varchar(20));

Insert values Department table

 insert into Department values (1,'AAA ',' nashik ' );

 insert into Department values (2,' BBB','  pune' );

 insert into Department values (3,' CCC',' sinnar ' );

 insert into Department values (4,' DDD',' nashik ' );

 insert into Department values (5,' EEE',' ozer ' );

Output of table

Acode3=# select * from department;

o\p

Acode3=# select * from department;

 dno | dname |   city   

-----+-------+----------

   1 | AAA   |  nashik 

   2 |  BBB  |   pune

   3 |  CCC  |  sinnar 

   4 |  DDD  |  nashik 

   5 |  EEE  |  ozer 

(5 rows)

Create Tabel Employee 

Employee (eno  integer, ename varchar(20), salary  money) 

create table  Employee (eno int primary key , ename varchar(20), salary money, dno int references Department(dno));

Insert values Employee table

insert into Employee values ( 1 ,'aaa ',20000    ,1  );

insert into Employee values (  2,' bbb',   450000 , 2 );

insert into Employee values (  3,' ccc',  50000 ,  2);

insert into Employee values (  4,' ddd',    35000, 3 );

insert into Employee values (  5,' eee',    15000, 4 );

Output of table

Acode3=# select * from employee;

o\p

 Acode3=# select * from employee;

 eno | ename |   salary    | dno 

-----+-------+-------------+-----

   1 | aaa   |  â‚¹20,000.00 |   1

   2 |  bbb  | ₹450,000.00 |   2

   3 |  ccc  |  â‚¹50,000.00 |   2

   4 |  ddd  |  â‚¹35,000.00 |   3

   5 |  eee  |  â‚¹15,000.00 |   4

(5 rows)