Sales_order_details Column name Datatype Size Attributes S_order_no Varchar2 6 Primary key/foreign key references s_order_no of sales_order Product_no Varchar2 6 Primary key/foreign key references product_no of product_master Qty_order Number 8 Qty_disp Number 8 Product_rate Number 10,2 Insert the following data into their respective tables: Data for sales_man master table: Salesman Address City Pin State name code no 500001 Kiran A/14 worli Bombay 400002 Mah 3000 100 50 Goo 500002 Manish 65,narim an Bombay 400001 Mah 3000 200 100 Goo 500003 Ravi P-7 Bandra Bombay 400032 Mah 3000 200 100 Goo 500004 Ashish A/5 Juhu Bombay 400044 Mah 3500 200 150 Goo Data for salesorder table: S_orderno S_orderdate Client no Dely Bill Delay date Orderstatus type yn no 019001 12-jan-96 0001 F N 50001 20-jan- 96 Ip 019002 25-jan-96 0002 P N 50002 27-jan- 96 C 016865 18-feb-96 0003 F Y 500003 20-feb- 96 F 019003 03-apr-96 0001 F Y 500001 07-apr- 96 F 046866 20-may-96 0004 P N 500002 22- may-96 C 010008 24-may-96 0005 F N 500004 26- may-96 Ip Data for sales_order_details table: S_order no Product no Qty ordered Qty disp Product_rate 019001 P00001 4 4 525 019001 P07965 2 1 8400 019001 P07885 2 1 5250
Sales_order_details Column name Datatype Size Attributes S_order_no Varchar2 6 Primary key/foreign key references s_order_no of sales_order Product_no Varchar2 6 Primary key/foreign key references product_no of product_master Qty_order Number 8 Qty_disp Number 8 Product_rate Number 10,2 Insert the following data into their respective tables: Data for sales_man master table: no Salesman name Address City Pin code State 500001 Kiran A/14 worli Bombay 400002 Mah 3000 100 50 Goo 500002 Manish 65,narim an Bombay 400001 Mah 3000 200 100 Goo 500003 Ravi P-7 Bandra Bombay 400032 Mah 3000 200 100 Goo 500004 Ashish A/5 Juhu Bombay 400044 Mah 3500 200 150 Goo Data for salesorder table: S_orderno S_orderdate Client no Dely type Bill yn no Delay date Orderstatus 019001 12-jan-96 0001 F N 50001 20-jan- 96 Ip 019002 25-jan-96 0002 P N 50002 27-jan- 96 C 016865 18-feb-96 0003 F Y 500003 20-feb- 96 F 019003 03-apr-96 0001 F Y 500001 07-apr- 96 F 046866 20-may-96 0004 P N 500002 22- may-96 C 010008 24-may-96 0005 F N 500004 26- may-96 Ip Data for sales_order_details table: S_order no Product no Qty ordered Qty disp Product_rate 019001 P00001 4 4 525 019001 P07965 2 1 8400 019001 P07885 2 1 5250