1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Question about db design & webpage implementation

Discussion in 'SQL Server' started by jhenry2808, Oct 31, 2007.

  1. jhenry2808

    jhenry2808 New Member

    Oct 31, 2007
    Likes Received:
    Trophy Points:

    I have a question regards to ASP.NET 2.0

    I'm developing a travel website, using a SQL Server 2000 database. This database contains COMPANIES table, which stores all travel company info.

    Now, I would like to store some extra info for some kinds of travel companies (not all companies), for ex only for tour operators, hotels and travel agents.

    I intend to design the database like this:

    COMPANIES (id, name, ...)
    TOUR_OPERATORS (id, company_id, ...)
    HOTELS (id, company_id, ...)
    TRAVEL_AGENTS (id, company_id, ...)

    Each tour operators, hotels and travel agents has all properties from COMPANIES table (company_id is foreign key) and some specific properties.

    Now I have to build a listing page, a search page, and a detailed page for all companies.

    I would like to know if there is a better solution to design the database and how to build the listing, search and detailed pages. Do I have to build 3 different pages for each type of companies or should I use only 1 page and use "if/else" there?

    Thank you very much.
  2. shabbir

    shabbir Administrator Staff Member

    Jul 12, 2004
    Likes Received:
    Trophy Points:
    Moved thread to database forum.

Share This Page