Drugs to be purchased Patient Detail Doctors Pharmaceutical Management System

Drugs to be purchased patient detail doctors

This preview shows page 35 - 42 out of 53 pages.

Drugs to be purchased Patient Detail Doctors Pharmaceutical Management System Request Patients Dosage Receive Number and type of drugs Drugs Requested Pharmacists
Image of page 35
5.4 Proposed system use case Diagram It is a graphic deception of interactions among elements of the pharmacy management system Admin Patient Doctors Pharmacy Office 36 Billing of Drugs Log Into the System Purchase Drugs Book Appointment Purchase Drugs Update profile Update Profile Log into The System Billing Of Drugs Billing of Drugs Update profile Number of drugs Take Patient Detail Manage Medicine Number of drugs
Image of page 36
5.5Proposed system data flow diagram 37 Pharmacy Management Doctor Management Pharmacy Management System Patient Management Sales Management Company Management Medicine Management
Image of page 37
5.6System Modules Flow Chart 5.7Sequence Diagram 38 Admin
Image of page 38
5.8 Database Design Database Design is a collection of processes that facilitate the designing , development, implementation and maintenance of enterprise data management systems. .The main objectives of database designing are to produce logical and physical designs models of the proposed database system. 5.8.1Conceptual Database design Conceptual design of a database means the early stage of a design process which includes design interactions, experience and strategies. Its shows one how the interface will look like and the feel also it gives a view on steps taken to design database of the system Doctors Table Field Name Data Type Description Doctor's Ref No Short Text Uniquely identifies the Supplier Doctor's NHS No Short Text Captures the service number of doctor Surname Short Text Captures Name Medical Centre Name Short Text Capture Centre name Medical Centre Ref Short Text Captures ref of The Centre Office Phone 2 Short Text Mobile number Fax No Short Text Patient NHS Number Short Text EMIS Number Short Text Patient ID Short Text 39
Image of page 39
Gp Appointment Field Name Data Type Description GP Appointment Ref Short Text Gives the Appointment Ref Patient NHS Number Short Text Identify Number EMIS Number Short Text Identify Number GP Appointment Short Text Cature general patient appointment Patient Full Name Short Text Capture name Patient ID Short Text Medical Centre Name Short Text Doctor's NHS No Short Text Patient Table Field Name Data Type Description NI Number Short Text The Person identification First name Short Text Identifies the name of the person Surname Short Text Identifies the name of the person Date of Birth Short Text Birthday Of Patient Billing Name Short Text Name to be Used in billing Address Short Text Post Code Short Text City Short Text Country Short Text Home Phone Short Text Mobile Phone Short Text Fax Phone Short Text Patient ID Short Text Patient NHS Number Short Text EMIS Number Short Text GP Appointment Ref Short Text Payment Table Field Name Data Type Description 40
Image of page 40
Invoice No Short Text Identity of the customer Amount Paid Short Text Cash paid Method of Payment Short Text Whether it is cash or Credit Visa Card Short Text Card Number Debit Card Short Text Card Number Master Card Short Text Card Number Visa Debit Card Short Text Card Number Cash Paid Short Text Card Number Patient ID Short Text Identify patients
Image of page 41
Image of page 42

You've reached the end of your free preview.

Want to read all 53 pages?

  • Fall '15
  • Mr waweru
  • Project Management, Requirements analysis, Database management system

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors