Style Guidelines for Final Year Project ReportsMedicine Surveillance System

Final Year Project Proposal

Session 2012-2016

A 4th Year Student

A project submitted in partial fulfilment of the

COMSATS-Lancaster Dual Degree

of

BSc. (Hons.)BS in Computer Science / Software Engineering (CIIT)

BS in Computing / Software Engineering (LU)

Department of Computer Science

COMSATS Institute of Information Technology, Lahore

26 February 201518 February 2015

Project Registration

Project ID(foroffice use)
Type (Nature of project) / [ ] Development [ ] Research [ ] RD
Area of specialization
Project Group Members
Sr.# / Reg. # / Student Name / CGPA / Email ID / Phone # / Signature
(i) / DDP-BCS-SP12-097 / Zeeshan Ahmad / 2.37 / / 03246470789
(ii) / DDP-BCS-SP12-019 / FawadRamzan / 2.49 / / 03157010032
(iii) / DDP-BCS-SP12-073 / MuzammalAslam / 2.72 / / 03066846171
Name& Signature of Batch Advisor

Plagiarism Free Certificate

This is to certify that, I amZeeshan Ahmad S/oMuhammad Afzal, group leader of FYP under registration no CIIT/DDP/BCS-SP12-097/LHR at Computer Science Department, COMSATS Institute of Information Technology, Lahore. I declare that my FYP proposal is checked by my supervisor and the similarity index is ______% that is less than 20%, an acceptable limit by HEC. Report is attached herewith as Appendix A.

Date: ______Name of Group Leader: Zeeshan Ahmad Signature:______

Name of Supervisor: M. Mohsin MehdiCo-Supervisor (if any):______

Designation:______Designation:______

Signature:______Signature:______

Approval of FYP Management Committee

Committee Member 1: Name: ______

[ ] Accept[ ] *Defer[ ] *RejectSignature:______

*Remarks: ______

Committee Member 2: Name: ______

[ ] Accept[ ] *Defer[ ] *RejectSignature:______

*Remarks: ______

Convener: Name: ______

[ ] Accept[ ] *Defer[ ] *RejectSignature:______

*Remarks: ______

Project Abstract:

The basic purpose of this project is to track medicines from pharmaceutical companies where they are manufactured and packed to every single sale point where they delivered and at the end point where these medicines are consumed. In this process, we have number of distributor companies and hospitals from where these medicines further delivered to medical stores or consumed by patients .We will track medicine by its batch number/serial from pharmaceutical company where it will be prepared to distributor companies, medical stores and hospitals where it will be used. For this purpose, High Level authority related to Health Care and Medicine will enforce them to put their record online on every single transaction of medicine. Furthermore, it will provide comprehensive reports on medicine consumption and regular updates on expired medicines.

Introduction:

  • Problem Statement:
    When a patient use medicine recommended by any doctor from any medical store or hospital and unfortunately it will cause a damage of any kind to patient due to any reason, at that time authorities are unable to find the source who sold that medicine. There is no available system in our country which can trace medicine level by level from manufacturing (pharmaceutical) company to medicine selling point i.e. hospital or pharmacy. At that time, Authority lacks the skill of investigation and incompetent to discover the main reason beyond the accident.
  • Objective:
    Our Medicine Surveillance System will help to avoid unintended consequences as well as help Ministry of Health to backtrack medicine from patient to pharmaceutical companies or vice versa in case of any inconvenient result. There are lots of problems which make it necessary to track medicines or drugs for safety reasons. We need to track them from each location they pass through, so it will become easy to trace them retrospectively.
  • Procedure:

The Ministry of Health will give authorized license to pharmaceutical companies, distributors, hospitals, medical stores or any other medicine selling point after passing through process of verification. These departments will officially register by the Ministry of Health. Medicines will only be manufactured, packed, distributed and sold by these authorized departments. The Ministry of Health will strictly endorse these departments to update medicine inventory at every single step of buying and purchasing from the day of manufacture by a pharmaceutical company to the day of sell to a patient. A centralized database system will be designed by us that will be administrated by the Ministry of Health who will keep record of every medicine inventory. These records involve every isolated step of producing, packing, distributing, selling and consuming by a person. All Departments will be responsible of updating the record at each single transaction.

Motivation and Scope:

Many people die every day by using expire, defective or faulty medicines and now a days it is very inconvenient to figure out who is responsible for such loses.
Our main objective is to stop the trend of illegitimate and hazardousforgedhazardous forged medicines in the pharmaceutical industry.Central authority has no enough information which is necessary to figure out medicines or drugs in thecountrywhich are below from actual standard, has a fraudulent imitation and fraud. The Ministry of Health can preserve against damages by developingsuccessfuldeveloping successful product authentication system across the country and using properdiscoveringproper discovering solutions.
Every registered pharmaceutical company, distributor, medical store and hospital will be involved in this project and they were responsible of updating record at every instance of buying or selling of medicine.

Related Work:

Currently there is no such related work available in market for tracking medicine from pharmaceutical companies to patients in Pakistan in such a way that you can trace medicine/drug at any step.

System Architecture:

Please describe basic system architecture (optional) using flow charts or diagrams.

Goals and Objectives:

  • Front-End Development:
    We will design a website with administrator, supervisor and staff module. Each module contains detail of each and every registered pharmaceutical company, distributor, hospital, medical store and other medicine selling point. These departments will get login username and password after process of verification. There would be a login panel for each department on the website and departments can login their account by using given username and password. After this step, departments would be able to work. The front-end will be developed by using CSS, JavaScript, Bootstrap and jQuery.
  • Database:
    A complete database will be designed which will contain all information regarding to medicines and drugs in it. This database will be a centralized database system. It will contain information of pharmaceutical companies, distributors, hospitals, medical stores and other medicine selling points. All department work will be updated in this database. The database will be developed by using SQL.
  • Business Design and Development:

The business end designwilldesign will be made by using ASP.NET. It will then connect with database. Both the business end design and database will then configure out with front-end design.

Individual Tasks:

  1. Zeeshan Ahmad:

Business level design

Logical design

Model view control

Database connectivity and configuration

Asp.net

SQL

  1. FawadRamzan:

Website design

Graphic design – Adobe Photoshop

Documentation

HTML, CSS, JavaScript, Bootstrap

SQL

  1. MuzammalAslam:

Logical design of database

SQL server configuration

SQL

Future Work:

Authority can easily assess which diseases are more common in an area and which are contagious by using data of particular area.

Authority can take precautions to prevent people from different diseases by accessing that data.

Both types of applications can also be made in future:

Desktop Application

Mobile Application

Tools and Technologies:

Visual Studio 2013

Microsoft SQL Server

Adobe Photoshop / Adobe Dreamweaver

ASP.NET 4.5 / MVC 5.3

HTML 5 /CSS 3

Bootstrap

JavaScript / JQuery

SQL - Structured Query Language

Appendix A

Include here the 1st page of Turnitin Report

Every supervisor has his/her ownTurnitinaccount. If not thensupervisors are requested to get the account from Library as soon as possible.

1 of 7