DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Database design for scheduling app

  1. #1
    Join Date
    Jun 2004
    Location
    Houston, Texas
    Posts
    24

    Database design for scheduling app

    if i have a daily schedule with time booked every fifteen minutes can i show times booked and unbooked?

    here's an example of what i'm trying to show

    9:00 Booked
    9:15 Booked
    9:30
    9:45 Booked
    10:00
    10:15 Booked

    what fields would i need in the database?

    i've been working on this for quite some time now and i haven't found an effective way to do it yet.
    Men acquire a particular quality by constantly acting a particular way...you become just by performing just actions, temperate by performing temperate actions, brave by performing brave actions.
    Aristotle

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    I would probably just store the date and time for each appointment, so my Appointments table would look like this:
    Code:
    Appointments
    ------------
    ID          (identity)
    ApptDate    Date/Time
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

Similar Threads

  1. Database Design Problems (FK & Relations)
    By paolorossi999 in forum Database
    Replies: 6
    Last Post: 03-20-2007, 05:54 AM
  2. database app. design
    By greenhorn in forum VB Classic
    Replies: 3
    Last Post: 12-13-2001, 06:41 AM
  3. COM+ Database Component Design
    By Humberto Morales in forum Enterprise
    Replies: 0
    Last Post: 06-14-2001, 03:16 PM
  4. Database Design
    By Vineet in forum VB Classic
    Replies: 1
    Last Post: 10-10-2000, 11:22 AM
  5. Help with relational database design
    By Robert Waldron in forum VB Classic
    Replies: 2
    Last Post: 05-29-2000, 10:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center