Notes

create table client_master69(clientno varchar2(6)primary key check(clientno like 'c%') ,name varchar2(20) check(name is not null),address1 varchar2(30),address2 varchar2(30),city varchar2(15),pincode number(8),state varchar2(15),bladue number(10,2));


create table product_master69(productno varchar2(6) primary key check(productno like '%p'),description varchar2(15) not null,profitpercent number(4,2) not null,unitmeaasure varchar2(10) not null,qtyonhand number(8) not null,recorderlvl number(8) not null,sellprice number(8,2)not null check(sellprice!=0),costprice number(8,2) not null check(costprice!=0));

create table salesman_master69(
salesmanno varchar2(6) Primary key check(salesmanno like '%s'),
salesmanname varchar2(20) not null,
address1 varchar2(30) not null,
address2 varchar2(30),
city varchar2(20),
pincode number(8),
state varchar2(20),
salamt number(8,2),
tgttoget number(6,2),
ytdsales number(6,2),
remarks varchar2(60));
create table sales_order69(orderno varchar2(6) primary key check(orderno like '%o'),clientno varchar2(6)foreing key reference clientno of client_master69,orderdate date,delyadder varchar2(25),salesmanno varchar2(6) foreign key reference salesmanno of salesman_master69 )