
Following is the table schema and the insert statements for assignment 3:              
create table supplier( sno integer, sname varchar(30), city varchar(30));

create table part( pno integer, pname varchar(30), colour varchar(30), weight number(3,2), city varchar(20));

create table project( jno integer, jname varchar(30), city varchar(30) );

create table spj( sno integer, pno integer, jno integer, qty integer );

insert into supplier values( 1, 'S1',  'Pune' );
insert into supplier values( 2, 'S2',  'Bombay' );
insert into supplier values( 3, 'S3',  'Thane' );
insert into supplier values( 4, 'S4',  'Delhi' );
insert into supplier values( 5, 'S5',  'Calcutta' );
insert into supplier values( 6, 'S6',  'Chennai' );
insert into supplier values( 7, 'S7',  'Madurai' );

insert into part values( 1, 'P1', 'Red', 1.23, 'Pune' );
insert into part values( 2, 'P2', 'Blue', 2.23, 'Bombay' );
insert into part values( 3, 'P3', 'Red', 5.24, 'Thane' );
insert into part values( 4, 'P4', 'Green', 7.12, 'delhi' );
insert into part values( 5, 'P5', 'Yellow', 3.87, 'Calcutta' );
insert into part values( 6, 'P6', 'Red', 8.88, 'Chennai' );
insert into part values( 7, 'P7', 'Blue', 1.45, 'Madurai' );

insert into project values( 1, 'J1', 'Pune' );
insert into project values( 2, 'J2', 'Bombay' );
insert into project values( 3, 'J3', 'Thane' );
insert into project values( 4, 'J4', 'Delhi' );
insert into project values( 5, 'J5', 'Calcutta' );
insert into project values( 6, 'J6', 'Chennai' );
insert into project values( 7, 'J7', 'Madurai' );

insert into spj values( 1, 1, 1, 10 );
insert into spj values( 1, 2, 1, 12 );
insert into spj values( 1, 1, 2, 30 );
insert into spj values( 2, 1, 1, 11 );
insert into spj values( 2, 2, 1, 50 );
insert into spj values( 1, 1, 3, 40 );
insert into spj values( 3, 1, 1, 45 );
insert into spj values( 1, 4, 4, 67 );
insert into spj values( 2, 1, 2, 39 );
insert into spj values( 5, 1, 1, 48 );
insert into spj values( 1, 1, 5, 36 );
insert into spj values( 2, 3, 1, 10 );
insert into spj values( 2, 2, 2, 23 );
insert into spj values( 1, 2, 2, 55 );
insert into spj values( 4, 4, 4, 76 );
insert into spj values( 2, 1, 5, 97 );
insert into spj values( 3, 2, 1, 5 );
