Question about db design & webpage implementation

jhenry2808's Avatar, Join Date: Oct 2007
Newbie Member
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.
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Moved thread to database forum.