Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    May 2003
    Location
    Perth, Western Australia, Australia
    Posts
    150
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Normalization Issues - Please help (2000)

    Hi guys,
    Apologies for the long message, my main question is at the bottom.
    I have to create a database, and just finding doing the erd a bit tricky.
    I have to create a medical appointment database, yet do not know the best way of
    approaching it. The db will be created in access and Asp.
    Basically, it involves 2 main entities.
    - Patient
    - Doctor.

    To put it in a nutshell,
    Doctors have a roster, they should be able to select 7 day working week, to indicate when they are available and at what time. So for Doctor Jim, he can select three weeks in advance and which day and time he is available. So he can say select Mondays, Wednesdays and Thursdays as his/her available days. Then they can select the timeslot of when they are available. Usually the timeslots are divided by 30min, 15min, it really depends on the doctor.

    Patient:
    When the patient comes to do a booking online, he/she must be able to book an appointment with a specific doctor, and the time that doctor has allocated for appointments. Once that booking has been done, there can be no other bookings in that timeslot, as we want to prevent cross-bookings. So basically, the patient can only see appointment time periods that are available. They can choose up to 3 time periods. The patient enters all details such name, phone, DOB, and email. A confirmation email is sent to both patient and selected Doctor.

    ------
    To expand on the doctor entity..
    The info varies according to each doctor and needs. To be filled out and altered by doctor from time to time.

    DOCTOR

  2. #2
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Normalization Issues - Please help (2000)

    Have you had a look at the Database Answers web-site ?

    This may have something close to what you want.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  3. #3
    2 Star Lounger
    Join Date
    May 2003
    Location
    Perth, Western Australia, Australia
    Posts
    150
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Normalization Issues - Please help (2000)

    Hi Steve,
    Thanks for that, the site is very useful and has some things I never considered before. But it doesnt quite address the problem I'm trying to resolve, as I'm a bit stuck on how to breakown the doctor/schedule part. Its messing my brain up <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

  4. #4
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Normalization Issues - Please help (2000)

    Try this http://www.advanced-ict.info/?databases/clash.html&

    It might help get you closer
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

Posting Permissions

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