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

    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,293
    Likes Received:
    365
    Trophy Points:
    83
    Moved thread to database forum.
     

Share This Page