1. create table store(num number(5) primary key,number & type varchar2(30) notnull,quntity number(5) notnull,sellprice number(5) notnull,puyprice number(5) notnull);
--------------------------------------

2. insert into store values(1,'tiger,rice',10,10,8);
--------------------------------------

3.create table puy invoice(no. puy invoice number(5) primary key,invoice_date,customer no. number(3) notnull);
--------------------------------------

4. insert into puy invoice values(233,(1,1,2007),3);
--------------------------------------

5. create table sell invoice(no. sell invoice number(5) primary key,invoice_date,customer no. number(3) notnull);
--------------------------------------

6. nsert into sell invoice values(333,(3,3,2007),5);
--------------------------------------

7. create table imports data(no. number(5), primary key,name varchar2(20),import type varchar2(30) notnull,address varcgar2(30) notnull,phone no. number(10) notnull,e-mail varchar2(35));
--------------------------------------

8. insert into imports data values(3,'Ayman Karasneh','Company','Ramtha',0796653975,'ayman_alkarasneh@yahoo.co.uk');
--------------------------------------

9. create table customer data(no. number(5), primary key,name varchar2(20),import type varchar2(30) notnull,address varcgar2(30) notnull,phone no. number(10) notnull,e-mail varchar2(35));
--------------------------------------

10.insert into customer data values(99,'ali ali','supermarket','Irbid',0779079432,'');