Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Feb 2014
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Designing a database

    Dear All
    I want to analyze the system and a small clinic you design tables for the patients ... but the question has to sometimes be booked by appointment Telephone Will I do the design table reservations or do I put the main data table bookings for patients immediately with

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    10,170
    Thanks
    129
    Thanked 1,138 Times in 1,049 Posts
    I don't see how the way an appointment is done would affect table design (other than maybe an attribute to represent the way appointment was done, if that is relevant), unless you want to treat appointments differently depending on the way they are done.
    Rui
    -------
    R4

  4. #3
    New Lounger
    Join Date
    Feb 2014
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    it's ok thank you my dear teacher

  5. #4
    Star Lounger
    Join Date
    Jan 2010
    Location
    Oregon
    Posts
    59
    Thanks
    8
    Thanked 0 Times in 0 Posts
    You want one table for Patient info, and a separate table for appointments. A one-to-many relationship between Patients and appointments (each patient can have many appointments, but not the other way around). Within the appointment table, looks like you'll need as many optional (Nullable) columns/attributes (such as TelephoneNumber) as necessary to facilitate an appointment. Won't matter too much, though, because the Appointment record will always tie back to the Patient table via the foreign key. What you'll really need is a flexible search input form to make appointments, and an equally good one to search/view appointments by using multiple criteria. Hope this helps.

  6. #5
    New Lounger
    Join Date
    Feb 2014
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    thank you my dear teacher

  7. #6
    New Lounger
    Join Date
    Oct 2012
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The first thing you must do in designing a database is to identify the ENTITIES. You have patients, Dr.'s and appointments to start. Each patient has a one to many relationship with appointments and also a one to many with Dr's. Each Dr. also has a one to many relationship with both appointments and patients. Probably all of your relationships for this type of system will be on to many.
    I strongly suggest that you go through the examples that came with your system. The most relevant I have seen is designing a system for video rentals. You can apply most of what you learn there to you Clinic system. Pay attention to the part of the video rentals that deals with payments. You can use that for your patient insurance entity.
    Having designed one of these myself, I can tell you to be prepared for it to grow fast, and requests for additional functionality will follow.

    HTH
    Peter

  8. #7
    New Lounger
    Join Date
    Oct 2012
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Please identify the database system you are trying to use, perhaps I can help you, or at least verify that you are setting things up correctly.
    Peter

  9. #8
    New Lounger
    Join Date
    Dec 2009
    Location
    Manchester, nh, usa
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Before you do anything, make absolutely sure you understand the full requirements for the system. Appointment systems sound simple, right? Heck, maybe you just use a standard calendar app (google, outlook, whatever) and schedule appointments that way. I can almost bet you that there are constraints to the design you don't yet know. for instance, are you booking a patient into a time slot? What about a specific exam room? What about a specific doctor/nurse/pa? What about special equipment required for the visit? What if you need to change time, room, or medical specialist? How does your system handle unusual cases?

    I'd strongly recommend you sit down and work with several of the people who handle scheduling and see what kind of issues they need to handle, THEN figure out your design.

    Good luck!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •