create table sales_order_master(s_order_no varchar2(6),
 s_order_date date,
 client_no varchar2(6),
 address varchar2 (20),status varchar(2),dely_type varchar2 (1),
 dely_date date );
 
 create table sales_order_details (s_order_no varchar2(6),
product_no varchar2(6),
product_rate numeric (8,2),
qty_ordered numeric (8),
qty_disp numeric (8));

create table client_master (client_no varchar2(6),
name varchar2 (20),
address varchar (20),
city varchar2 (15),
state varchar2 (15),
pincode numeric (6),
bal_due numeric (10,2));


create table product_master (product_no varchar2 (6),
description varchar2 (25),
unit_measure varchar2 (10),
qty_on_hand numeric (8),
reorder_lvl numeric (8),
cost_price numeric (8,2),
selling_price numeric (8,2));


insert into product_master VALUES ('T290','Metal Box','Nos',23,2,220,295);
insert into product_master VALUES ('T320','Tool Kits','Nos',52,25,121,189);
insert into product_master VALUES ('T150','Screw Drivers','Nos',21,13,5,8);
insert into product_master VALUES ('T651','Knives','Nos',21,03,12,25);
insert into product_master VALUES ('T452','Ladder','Nos',41,30,89,119);
insert into product_master VALUES ('T132','Chair','Nos',90,010,20,60);