60 likes | 204 Vues
Order Processing System for The Supply Branch. Group 13. Objectives. Create purchasing form with specification Can get printed copy of purchasing form. Compare specification with supplier’s specification. Send quotation and tender application using mail. Check financial state.
E N D
Objectives • Create purchasing form with specification • Can get printed copy of purchasing form. • Compare specification with supplier’s specification. • Send quotation and tender application using mail. • Check financial state.
Database Structure Users :(UserID, User Name, Password, DepartmentID, AccesslevelID) Accesslevel :(AccesslevelID, Accesslevel) Suppliers :( SuppID, Name, ContactNo ) Product :(ProductID, Name, Description ) Department :(DepartmentID, Name) Order :( OderID, orderdetailsID, Orderdate, UserID) Order Details :(OrderdetailsID, OrderID, ProdutID, Quantity )
Software Used LAMP DREAM VIEWER(for interface)
TASK LIST W.M.D.M.WEERAKOON DEPARTMENT INTERFACE W.M.A.H.SAMARASINGHE DEANS, INTERFACE G.Y.C.FONSEKA SUPPLIER BRANCH INTERFACE H.M.S.R.WIJERATHNE TECHNICAL COMMITTEE INTERFACE Y.G.C.B.ABERATHNE TENDER BOARD INTERFACE