Question about db design & webpage implementation

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

  1. jhenry2808

    jhenry2808 New Member

    Joined:
    Oct 31, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Hello,

    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

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    Moved thread to database forum.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice