Medical Shop Management System: A Comprehensive Project Synopsis, Cheat Sheet of Java Programming

Download Medical Shop Management System: A Comprehensive Project Synopsis and more Cheat Sheet Java Programming in PDF only on Docsity!

Synopsis of Medical Shop Management System

Page No. Topic Title 1 Title of the project 3 Introduction of the Project 4 Abstract of the Project 5 Objective of the Project 6 Scope of the Project 7 Reports of the project 7 Modules of the Project 8 Input data and validation of the project 9 Features of the project 10 Software Requirement Specification 11 Identification of need 12 Feasibility Study 13 System design of the project 14 User Interface Design 15 Preliminary Product Descriptions 17 Project Category 18 Implementation Methodology 19 Tools and Platform – Software Requirements 19 Tools and Platform – Hardware Requirements 20 System Analysis 22 Data Dictionary 23 Conclusion of the Project 24 Future scope of the Project 25 Limitations of the Project 26 Bibliography and references

Abstract of the Project Medical Shop Management System:

The purpose of Medical Shop Management System is to automate the existing manual system by the help of computerized equipments and full-fledged computer software, fulfilling their requirements, so that their valuable data/information can be stored for a longer period with easy accessing and manipulation of the same. The required software and hardware are easily available and easy to work with. Medical Shop Management System, as described above, can lead to error free, secure, reliable and fast management system. It can assist the user to concentrate on their other activities rather to concentrate on the record keeping. Thus it will help organization in better utilization of resources. The organization can maintain computerized records without redundant entries. That means that one need not be distracted by information that is not relevant, while being able to reach the information. The aim is to automate its existing manual system by the help of computerized equipments and full-fledged computer software, fulfilling their requirements, so that their valuable data/information can be stored for a longer period with easy accessing and manipulation of the same. Basically the project describes how to manage for good performance and better services for the clients.

Objective of Project on Medical Shop Management System:

The main objective of the Project on Medical Shop Management System is to manage the details of Medical Shop, Medicines, Stocks, Company, Inventory. It manages all the information about Medical Shop, Sells, Inventory, Medical Shop. The project is totally built at administrative end and thus only the administrator is guaranteed the access. The purpose of the project is to build an application program to reduce the manual work for managing the Medical Shop, Medicines, Sells, Stocks. It tracks all the details about the Stocks, Company, Inventory. Functionalities provided by Medical Shop Management System are as follows:  Provides the searching facilities based on various factors. Such as Medical Shop, Stocks, Company, Inventory  Medical Shop Management System also manage the Sells details online for Company details, Inventory details, Medical Shop.  It tracks all the information of Medicines, Sells, Company ect  Manage the information of Medicines  Shows the information and description of the Medical Shop, Stocks  To increase efficiency of managing the Medical Shop, Medicines  It deals with monitoring the information and transactions of Company.  Manage the information of Medical Shop  Editing, adding and updating of Records is improved which results in proper resource management of Medical Shop data.

Scope of the project Medical Shop Management System

It may help collecting perfect management in details. In a very short time, the collection will be obvious, simple and sensible. It will help a person to know the management of passed year perfectly and vividly. It also helps in current all works relative to Medical Shop Management System. It will be also reduced the cost of collecting the management & collection procedure will go on smoothly. Our project aims at Business process automation, i.e. we have tried to computerize various processes of Medical Shop Management System.  In computer system the person has to fill the various forms & number of copies of the forms can be easily generated at a time.  In computer system, it is not necessary to create the manifest but we can directly print it, which saves our time.  To assist the staff in capturing the effort spent on their respective working areas.  To utilize resources in an efficient manner by increasing their productivity through automation.  The system generates types of information that can be used for various purposes.  It satisfy the user requirement  Be easy to understand by the user and operator  Be easy to operate  Have a good user interface  Be expandable  Delivered on schedule within the budget.

Reports of Medical Shop Management System:

 It generates the report on Medical Shop, Medicines,Sells  Provide filter reports on Stocks, Company, Inventory  You can easily export PDF for the Medical Shop,Sells, Company  Application also provides excel export for Medicines, Stocks, Inventory  You can also export the report into csv format for Medical Shop, Medicines, Inventory

Modules of Medical Shop Management System:

 Medical Shop Management Module: Used for managing the Medical Shop details.  Inventory Module : Used for managing the details of Inventory  Sells Module : Used for managing the details of Sells  Medicines Management Module: Used for managing the information and details of the Medicines.  Stocks Module : Used for managing the Stocks details  Company Module : Used for managing the Company informations  Login Module: Used for managing the login details  Users Module : Used for managing the users of the system

 Commenting standard in the source files. The software quality plan we will use the following SQA Strategy:  In the first step, we will select the test factors and rank them. The selected test factors such as reliability, maintainability, portability or etc, will be placed in the matrix according to their ranks.  The second step is for identifying the phases of the development process. The phase should be recorded in the matrix.  The third step is that identifying the business risks of the software deliverables. The risks will be ranked into three ranks such as high, medium and low.

Features of the project Medical Shop Management System:

 Product and Component based  Creating & Changing Issues at ease  Query Issue List to any depth  Reporting & Charting in more comprehensive way  User Accounts to control the access and maintain security  Simple Status & Resolutions  Multi-level Priorities & Severities.  Targets & Milestones for guiding the programmers  Attachments & Additional Comments for more information  Robust database back-end  Various level of reports available with a lot of filter criteria’s  It contain better storage capacity.  Accuracy in work.  Easy & fast retrieval of information.  Well designed reports.  Decrease the load of the person involve in existing manual system.  Access of any information individually.  Work becomes very speedy.  Easy to update information

Identification of need:

The old manual system was suffering from a series of drawbacks. Since whole of the system was to be maintained with hands the process of keeping, maintaining and retrieving the information was very tedious and lengthy. The records were never used to be in a systematic order. there used to be lots of difficulties in associating any particular transaction with a particular context. If any information was to be found it was required to go through the different registers, documents there would never exist anything like report generation. There would always be unnecessary consumption of time while entering records and retrieving records. One more problem was that it was very difficult to find errors while entering the records. Once the records were entered it was very difficult to update these records. The reason behind it is that there is lot of information to be maintained and have to be kept in mind while running the business .For this reason we have provided features Present system is partially automated (computerized), actually existing system is quite laborious as one has to enter same information at three different places. Following points should be well considered:  Documents and reports that must be provided by the new system: there can also be few reports, which can help management in decision-making and cost controlling, but since these reports do not get required attention, such kind of reports and information were also identified and given required attention.  Details of the information needed for each document and report.  The required frequency and distribution for each document.  Probable sources of information for each document and report.  With the implementation of computerized system, the task of keeping records in an organized manner will be solved. The greatest of all is the retrieval of

information, which will be at the click of the mouse. So the proposed system helps in saving the time in different operations and making information flow easy giving valuable reports.

System Design of Medical Shop Management System

In this phase, a logical system is built which fulfils the given requirements. Design phase of software development deals with transforming the clients’s requirements into a logically working system. Normally, design is performed in the following in the following two steps:

1. Primary Design Phase: In this phase, the system is designed at block level. The blocks are created on the basis of analysis done in the problem identification phase. Different blocks are created for different functions emphasis is put on minimising the information flow between blocks. Thus, all activities which require more interaction are kept in one block. 2. Secondary Design Phase: In the secondary phase the detailed design of every block is performed. The general tasks involved in the design process are the following: 1. Design various blocks for overall system processes. 2. Design smaller, compact and workable modules in each block. 3. Design various database structures. 4. Specify details of programs to achieve desired functionality. 5. Design the form of inputs, and outputs of the system. 6. Perform documentation of the design. 7. System reviews.

User Interface Design

User Interface Design is concerned with the dialogue between a user and the computer. It is concerned with everything from starting the system or logging into the system to the eventually presentation of desired inputs and outputs. The overall flow of screens and messages is called a dialogue. The following steps are various guidelines for User Interface Design:

1. The system user should always be aware of what to do next. 2. The screen should be formatted so that various types of information, instructions and messages always appear in the same general display area. 3. Message, instructions or information should be displayed long enough to allow the system user to read them. 4. Use display attributes sparingly. 5. Default values for fields and answers to be entered by the user should be specified. 6. A user should not be allowed to proceed without correcting an error. 7. The system user should never get an operating system message or fatal error.

  Running Cost Besides, the initial cost the long term cost will include the running cost for the system including the AMC, stationary charges, cost for human resources, cost for update/renewal of various related software.   Need for Training The users along with the administrator need to be trained at the time of implementation of the system for smooth running of the system. The client will provide the training site. We talked to the management people who were managing a the financial issues of the center, the staff who were keeping the records in lots of registers and the reporting manager regarding their existing system, their requirements and their expectations from the new proposed system. Then, we did the system study of the entire system based on their requirements and the additional features they wanted to incorporate in this system. Reliable, accurate and secure data was also considered to be a complex task without this proposed system. Because there was no such record for keeping track of all the activities, which was done by the Medical Shop Management System on the daily basis. The new system proposed and then developed by me will ease the task of the organization in consideration. It will be helpful in generating the required reports by the staff, which will help them to track their progress and services. Thus, it will ease the task of Management to a great extent as all the major activities to be performed, are computerized through this system.

Project Category

Relational Database Management System (RDBMS) : This is an RDBMS based project which is currently using MySQL for all the transaction statements. MySQL is an opensource RDBMS System. Brief Introduction about RDBSM : A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as invented by E. F. Codd, of IBM's San Jose Research Laboratory. Many popular databases currently in use are based on the relational database model. RDBMSs have become a predominant choice for the storage of information in new databases used for financial records, manufacturing and logistical information, personnel data, and much more since the 1980s. Relational databases have often replaced legacy hierarchical databases and network databases because they are easier to understand and use. However, relational databases have been challenged by object databases, which were introduced in an attempt to address the object-relational impedance mismatch in relational database, and XML databases.