create table Employee AND Project related with many to one relationship

create table Employee  AND  Project  related with many to one relationship  

Consider the following database

 Employee (e_no int, e_name varchar(30), age int, date_of joining date)

 Project(p_no int, p_name varchar (25), start_date date, status varchar(10)) 

Employee and project are related with many to one relationship 

Create table Project

Project(p_no int, p_name varchar (25), start_date date, status varchar(10)) 

create table project (pno int primary key , pname varchar(50),Stratdate date , status varchar (50)   );

CREATE TABLE

Insert values in Project table

Acode2=# insert  into project values(1,'aa','2020-11-05','xyz'    );

INSERT 0 1

Acode2=# insert  into project values(2,'bb','2020-05-05','abc'    );

INSERT 0 1

Acode2=# insert  into project values(3,'cc','2010-04-08','wxy'    );

INSERT 0 1

Acode2=# insert  into project values(4,'dd','2015-01-07','wxy'    );

INSERT 0 1

 Output of table

Acode2=# select * from project;

O\P

Acode2=# select * from project;

 pno | pname | stratdate  | status 

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

   1 | aa    | 2020-11-05 | xyz

   2 | bb    | 2020-05-05 | abc

   3 | cc    | 2010-04-08 | wxy

   4 | dd    | 2015-01-07 | wxy

(4 rows)

Create table Employee

Employee (e_no int, e_name varchar(30), age int, date_of joining date)

create table employee (eno int primary key, ename varchar(50),eage int,  dateJ date, pno int references project (pno)   );

CREATE TABLE

Insert values in Employee table

Acode2=#  insert into employee values (1,'Acode', 18 ,'2020-04-28', 1   );

INSERT 0 1                                                    ^

Acode2=#  insert into employee values (2,'mujju', 18 ,'2020-05-21', 2   );

INSERT 0 1

Acode2=#  insert into employee values (3,'adharsh', 18 ,'2020-04-21', 3 );

INSERT 0 1

Acode2=#  insert into employee values (4,'rohan', 18 ,'2019-04-12', 4);

INSERT 0 1

Acode2=#  insert into employee values (5,'gaurav', 18 ,'2019-08-01', 1);

INSERT 0 1

Acode2=#  insert into employee values (6,'tejas', 18 ,'2019-06-01', 2);

INSERT 0 1

Acode2=#  insert into employee values (7,'utkarsh', 18 ,'2019-08-15', 3);

INSERT 0 1

 Output of table

Acode2=# select * from employee;

o\p 

Acode2=# select * from employee;

 eno |  ename  | eage |   datej    | pno 

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

   1 | Acode   |   18 | 2020-04-28 |   1

   2 | mujju   |   18 | 2020-05-21 |   2

   3 | adharsh |   18 | 2020-04-21 |   3

   4 | rohan   |   18 | 2019-04-12 |   4

   5 | gaurav  |   18 | 2019-08-01 |   1

   6 | tejas   |   18 | 2019-06-01 |   2

   7 | utkarsh |   18 | 2019-08-15 |   3

(7 rows)