Create table Item and Supplier are related with M-M relationship

Create table Item and Supplier are related with M-M relationship

Item(itemno integer, itemname varchar(20))

Supplier(supplier_no integer, supplier_name varchar(20), city varchar(20))

Item-Supplier: M-M relationship with rate(money) and quantity (integer) as  descriptive attributes. 

Create table item

 Item(itemno integer, itemname varchar(20))

create table item (ino int primary key, iname varchar(20));

Insert values in item Table

insert into item values ( 1,' aa' );

insert into item values ( 2,' bb' );

insert into item values ( 3,' cc' );

insert into item values ( 4,' dd' );

insert into item values ( 5,' ee' );

output of table

Acode2=# select * from item;

o\p

Acode2=# select * from item;

 ino | iname 

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

   1 |  aa

   2 |  bb

   3 |  cc

   4 |  dd

   5 |  ee

(5 rows)

 

create table  supplier

Supplier(supplier_no integer, supplier_name varchar(20), city varchar(20))

create table  supplier(sno int  primary key, sname varchar(20),city varchar(20), ino int references item (ino));

Insert values in supplier Table

insert into supplier values ( 1,' AAAA','nashik',1 );

insert into supplier values ( 2,' BBBB','sinnar',3 );

insert into supplier values ( 3,' CCCC','sukena',4 );

insert into supplier values ( 4,' DDDD','ozer',2 );

insert into supplier values ( 5,' EEEE','nashik',1 );

output of table

Acode3=# select * from supplier;

o\p

Acode3=# select * from supplier;

 sno | sname |  city  | ino 

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

   1 |  AAAA | nashik |   1

   2 |  BBBB | sinnar |   3

   3 |  CCCC | sukena |   4

   4 |  DDDD | ozer   |   2

   5 |  EEEE | nashik |   1

(5 rows)