Answer Happy

Database Management System
Topic: ‘Inventory Management System’.
Draw a database schema diagram from the given ER
diagram
AID Aname userID Passwd CID phone 1 N N N Cname Admin give access to User register as Customer Address 1 Email Phone placed Ename EID Bname Phone BranchID OrderNo Date Cname InventoryID Itemname N 1 N N 1 1 N Employee prepare Order prepared from Inventory has Branch N 1 Amount associate generate deliver with OrderNO InvoiceID Address Pin Code N City Street Category 1..N UserID PID 1 1 Invoice Price Product Delivery deliver to Location Pname N N 10 Cname Country supply stored SuplD 1 StorageID Sname Supplier Storage Stitem Phone quantity