1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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