Question: design it not write code please Design (draw shape) database schema with its related relationships and database constraints For these tables: category(catNo, catogeryName), Items(itemNo, ItemName,
Design (draw shape) database schema with its related relationships and database constraints For these tables: category(catNo, catogeryName), Items(itemNo, ItemName, Price, total _quantity, catNo), Items_stor_entry.(entry_no number primary key, itemNo,entry_date, quantity), Employee (employeeNo, employee Name,job), branch(No,Name), Customer (customerNo, costomerName, gender), ,Invoice (employee No, customerNo, total price ,invoiceNo,InvoiceDate, branchNo) InvoiceDeatail contain List Of Purchase Items contain detail information related to the invoice (invoice No, ItemNo, paidPrice, quantity)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
