Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Location
    Ljubljana, Slovenia, Europe
    Posts
    1

    Question database design >>> help

    i am building a database for event calendar to be used on website:

    i need one solution for all 3 types of events:
    a) - one day events >> one date
    b) - events - from - to >> two dates
    c) - events - different dates (10.5.2003 /12.5.2003/1.6.2003/... ) >> multiple dates

    thinking...
    ad a) one day is start and end day of event
    ad b) start day and end day of event
    ad c) fist date is start day and last date is last day of event
    ...

    i need a solution or idea how to put date data to DB.

    I will use MySQL and ASP or PHP.

    looking for any hint or suggestion

  2. #2
    Join Date
    May 2003
    Posts
    13

    Anoher approach

    Your solution is much more complex in terms of programming. You would have to make sure that category B the end date does not contain the same date as you start date. For category C you're loosing the data if you have the event repeating for more than two dates. There are many solutions to this example, here are my approaches:

    I think it should cover all your cases.

    1.) Simple.

    CREATE TABLE Event (
    *Event_Number
    *Event_Date
    Event_Name
    Event_Description_Text
    )
    go

    2.) Flexible in terms of reusing the same event for different dates.

    TABLE Event_Schedule (
    *Event_Number
    *Event_Schedule_Date
    Schedule_Description_Text
    )

    TABLE Event (
    *Event_Number
    Event_Name
    Event_Description_Text
    )

    table Event Schedule is referencing Event Number from the Event table. See picture for clarification.
    Attached Thumbnails Attached Thumbnails event.jpg  

  3. #3
    Join Date
    Sep 2003
    Posts
    3

    Re: database design >>> help

    what is the worst case and best case performance of a R-tree having N nodes and height H when searching for a q point querry ?

  4. #4
    Join Date
    Sep 2003
    Posts
    3
    What is the difference between the Grid files and the R-tree in worst case performance for searching for a point ?

  5. #5
    Join Date
    Sep 2003
    Posts
    3
    What is the difference between the Grid files and the R-tree in worst case performance for inserting a point ?

Posting Permissions

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