Program 2 (Create and Insert)

Creation of Tables

CREATE TABLE SALESMAN(Salesman_id int PRIMARY KEY,Name varchar(30),City varchar(15),Commission number(5,2));

CREATE TABLE CUSTOMER(Customer_id int PRIMARY KEY,Cust_name varchar(30),City varchar(15),Grade varchar(3),Salesman_id int REFERENCES SALESMAN(Salesman_id) ON DELETE SET NULL);

CREATE TABLE ORDERS(Ord_no int PRIMARY KEY,Purchase_amt number(8,2), Ord_date date,Customer_id int REFERENCES CUSTOMER(Customer_id)ON DELETE CASCADE,Salesman_id int REFERENCES SALESMAN(Salesman_id)ON DELETE CASCADE);

Insertion of rows to the table

INSERT INTO SALESMAN VALUES('&Salesman_id','&Name','&City','&Commission');

INSERT INTO CUSTOMER VALUES('&Customer_id','&Cust_name','&City','&Grade', '&Salesman_id');

INSERT INTO ORDERS VALUES('&Ord_no','&Purchase_amt','&Ord_date','&Customer_id', '&Salesman_id');