CREATE TABLE salesman(s_id INT PRIMARY KEY,name VARCHAR(20),city Varchar(20),commission FLOAT, salary INT)

CREATE TABLE Customer(c_id INT PRIMARY KEY,name VARCHAR(20),city Varchar(20),Grade FLOAT, s_id INT,Foreign key(s_id )REFERENCES salesman(s_id));


CREATE TABLE 'Order' (o_no INT PRIMARY KEY ,purchase_Amount INT ,Order_date DATE, c_id INT, s_id INT , FOREIGN KEY (s_id),REFERENCES salesman(s_id),FOREIGN KEY (c_id)
REFERENCES customer(c_id));

INSERT INTO salesman VALUES (1,"Rabbi","Dhaka",0.21,10000);
INSERT INTO salesman VALUES (2,"Atik","Cumilla",0.14,12000);
INSERT INTO salesman VALUES (3,"Fardin","Chittagong",0.21,13000);
INSERT INTO salesman VALUES (4,"Rahim","Rajshahi",0.21,15000);