use sql command line to create the these

pls run them to be sure the cood is working

--

The system must contain tables such as

category(catNo ,catogeryName) ,

Items(itemNo,ItemName,Price,total_quantity, catNo),

Items_stor_entry(entry_no number primary key, itemNo,entry_date , quantity),

Employee (employeeNo,employeeName,job) ,branch(No,Name), Customer(customerNo,costomerName,gender) ,

Invoice (employeeNo,customerNo,total price ,invoiceNo,InvoiceDate,branchNo )

InvoiceDeatail contain List Of Purchase Items contain detail information related to the invoice InvoiceDeatail(invoiceNo,ItemNo, paidPrice, quantity) .

create getItemTotalPrice function which to return quantity*paidPrice .