Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2008
    Posts
    2

    Small Tourist Database

    Hello everyone

    I'm new to the forum, indeed to the database world at an advanced level and hoping some of you seasoned professionals can point me in the right directions.

    I'm trying to put together a database of "features" or "things of interest" of my local area that would be appealing to a visitor - it's going to be the database of a small tourist web site.

    So far I've come up with a schema of two tables, "features" and "feature_type".

    The "features" table includes such things as parks, lakes, rivers, hotels, etc.

    The "feature_type" table includes acronyms for all the features, i.e., "prk", "lk", "htl", etc.

    I am wondering if I should consider splitting my "features" table into multiple tables, i.e., one for "parks", one for "lakes", one for "rivers", etc.

    Is this going a bit too far? What would be recommended in this case?

    Any help or suggestions would be great before I move on with my design and add more supporting tables.

    Many thanks

    Programan

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    No. Do not split your features into different tables.
    Keep it the way you have it.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Oct 2008
    Posts
    2

    Keep it the way it is..

    Many thanks for the reply.

    I will accept your wisdom and go with this.

    Many thanks

    Programan.

Posting Permissions

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