online clinical management system, Essays (university) of Research Methodology

Download online clinical management system and more Essays (university) Research Methodology in PDF only on Docsity! Pharmacy Management System Project Documentation of Pharmacy Management System A Desktop Application Pharmacy Management System 2 Table Of Content Chapter Name of Topics Page 1 Introduction 3 2 Definitions 4 3 Time Plan 5 4 Project Summery 6 5 Features 11 6 Target Users 11 7 Tools and Technology 12 8 User Manual Description 12 9 Further Development 22 10 Conclusion 25 Pharmacy Management System 5 Chapter – 3 Time Plan Sl. No Milestone In Details Start Date End Date 1 A Project Proposal Will contain deliverables, development plan, analysis, evaluation and test plan 02.05.2016 03.06.2016 2 Analysis and Design Will mapped the logical models and produces a detailed design specification. 04.06.2016 15.06.2016 3 Implementation, Testing and Evaluation Will include the implementation method, Its justification and the assessment of the project 16.06.2016 07.09.2016 4 Demonstration and Presentation The technology that will used to show a briefly presentation according to the project 08.09.2016 16.10.2016 Pharmacy Management System 6 Chapter – 4 Project Summery  DATA FLOW DIAGRAM Module Flow Chart Start Process Purchase Stock Company & Supplier Sale Customer & User Product Stop Pharmacy Management System 7 Purchase Management Purchase Entry Return Purchase Management Start Purchases Entry Process Report Start Return Purchases Entry Process Report Pharmacy Management System 10 ERD of PHARMACY MANAGEMENT SYSTEM Products prod_id (pk) number prod_name varchar2 type_id (fk) number gen_id (fk) number com_id (fk) number com_name varchar2 unit_price number stock_qty varchar2 Generics gen_id (pk) number gen_name varchar2 gen_desc varchar2 Product_type type_id (pk) number type_name varchar2 type_desc varchar2 Purchase_Details pur_id (fk) number prod_id (fk) number prod_name varchar2 unit_price number unit_size varchar2 quantity number expiry_date date Damage_products prod_id(fk) number reason varchar2 quantity number dam_date date Sales _details voucher_id(fk)number prod_id (fk) number prod_name varchar2 unit_price number quantity number Suppliers supp_id (pk) number supp_name varchar2 address varchar2 phone_no varchar2 email_id varchar2 Sales _master voucher_id(pk)number User_id (fk) number Cust_id (fk) number Receive_amount number Date date Discount_on_amount number Customers Cust_id (pk) number Cust_name varchar2 Cust_phone varchar2 Address varchar2 Users User_id (pk) number Password varchar2 User_name varchar2 user_type varchar2 Phone_no varchar2 Address varchar2 Purchase_Master pur_id (pk) number pur_date date supp_id (fk) number invoice_no number paid_amount number User_id (fk) number Company com_id (pk) number com_name varchar2 address varchar2 website varchar2 Pharmacy Management System 11 Chapter – 5 Features  Functional Feature  Main Screen shots (Forms & Reports)  Functional Features: (Forms) 1.Purchase Details 2.Sale Details 3.Stock Information 4.Product Information 5.Damage Product Information 6.Company Details 7.Supplier Details 8.Customer Details 9.User Details  Reports: 1.Stock Quantity Information 2.Purchase & Sale Information 3.Cash Memo 4.Damage product Information Chapter – 6 Target Users  Any Kind of Pharmacy  Any kind of Inventory Management System Pharmacy Management System 12 Chapter – 7 Tool and Technologies Technologies: o SQL, PL/SQL, REPORTS DEVELOPER o FORMS DEVELOPER Front End: o ORACLE 10g DEVELOPER SUITE. Tools: o SQL PLUS, SQL DEVELOPER, TOAD Database: o Oracle 11g Server: o ORACLE APPLICATION SERVER 11g Operation System: o WINDOWS XP, WINDOWS 7, WINDOWS 8, WINDOWS 10 Chapter – 8 User Manual Description (Forms) Login Page Pharmacy Management System 15 Supplier List Create Generic User can check or found Supplier information from this page. User can create generic information from this page. Pharmacy Management System 16 Generic List Purchase Entry page User can entry purchase from this page. User can check generic information from this page. Pharmacy Management System 17 Purchase Return Entry Page Stock Detail User can check stock information from this page. User can give entry purchase return from this page. Pharmacy Management System 20 Customer List User List with Create Form User can check or found customer information from this page. Only Admin User can create user information from this page. Pharmacy Management System 21 User Change Password Form Only Admin User can change the password of existing user information from this page. Pharmacy Management System 22 User Manual Description (Reports) Stock Information Report Stock Information Report By Product Name.