Per Paid Plan Yesno Patient NHS Number Short Text Identify patient service

Per paid plan yesno patient nhs number short text

This preview shows page 41 - 46 out of 53 pages.

Per Paid Plan Yes/no Patient NHS Number Short Text Identify patient service Number Pharmacy Table Field Name Data Type Description Reference Number Short Text Identification of a reference number Name of Tablets Short Text Capture Name of Tablet Dose (mg) Short Text Capture Dosage Required Number of Tablets Short Text Identify number Of Tablets Issued Date Short Text Capture Date Exp Date Short Text Capture Date Daily Dose Short Text Dentify Dosage Possible Side Effects Short Text Further Information Short Text Storage Advice Short Text Administration Short Text How to Use Medication Short Text Patient ID Short Text Doctor's NHS No Short Text 41
Image of page 41
42
Image of page 42
5.8.2Logical Database Design Logical database design is the process of deciding how to arrange the attributes of the entities in a given business environment into database structures, such as the tables of a relational database . The attributes in my database have been arranged in an order suitable for pharmacies to have easy access to records thus knowing which medicine to administer before one reaches the counter . Doctor Table Gp Appointment Table Patient Table Payment Table Pharmacy Table Doctor's Ref No GP Appointment Ref NI Number Invoice No Reference Number Doctor's NHS No Patient NHS Number First name Amount Paid Name of Tablets Surname EMIS Number Surname Method of Payment Dose (mg) Medical Centre Name GP Appointment Date of Birth Visa Card Number of Tablets Medical Centre Ref Patient Full Name Billing Name Debit Card Issued Date Office Phone 2 Patient ID Address Master Card Exp Date Fax No Medical Centre Name Post Code Visa Debit Card Daily Dose Patient NHS Number Doctor's NHS No City Cash Paid Possible Side Effects EMIS Number Country Patient ID Further Information 43
Image of page 43
Patient ID Home Phone Per Paid Plan Storage Advice Mobile Phone Patient NHS Number Administratio n Fax Phone How to Use Medication Patient ID Patient ID Patient NHS Number Doctor's NHS No EMIS Number GP Appointment Ref 5.8.3Physical Database Design It translates the logical data model into a set of SQL Statements that define the database. For relational Database systems it is relatively easy to translate from a logical data model into a physical database. Spaces are not allowed in entity names in a physical schema because these names must translate into SQL calls to create the tables. Table names should therefore conform to SQL naming rules. 44
Image of page 44
CHAPTER SIX 6.1 Introduction In this chapter we are done building the system thus it is time to implement the system and test it by giving users training on how to use the system 6.2 Interface implementation Output Screen Designs Designed to allow user to freely look at the information after he or she has imput the data 6.2.1 System interface coding tools Visual basic 2012 has helped a lot in coming up with the proposed system since it contains all the relevant resources and features required to develop this type of program. Also, Microsoft Access has acted as a tool to help me store all my database information.in summary they have helped in the actual coding of the required system 6.3 Database implementation I decided to use Microsoft a access database since it contains very easy ways in
Image of page 45
Image of page 46

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