Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Normalisation (2000)

    Hi All,
    I have to create a medical access database, but with the perspective of building ASP pages upon it. So there will be no need
    for forms, queries etc. Just need the right tables and their respective relations.
    Basically, it involves 2 main entities.
    - Patient
    - Doctor.

    Doctor:
    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.

    ------
    My db has to take into consideration that...

    1. Booking cycle Weeks= 1 2 3 4 (Some doctors have roster that repeat every week or 2 weeks or 3 weeks or 4 weeks, They
    need to select their repeating cycle)

    Under each date the Doctor needs to select what section of times need to be booked as

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Normalisation (2000)

    Welcome to woody's Lounge!

    The application you describe is quite complicated; it will require a large amount of coding. Do you really want to spend a lot of time and money to develop something that already exists? There are existing applications for online scheduling of medical appointments.

  3. #3
    New Lounger
    Join Date
    Feb 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Normalisation (2000)

    Thanks Hans,
    I didn't know it was that complicated. But if you do have any clue as to how to break down the tables, then that would be great. I'm currently searching for medical appointment db's, still cant find any appropriate one.

  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: Normalisation (2000)

    The Database Answers website has a lot of sample data models which might be helpful.
    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
  •