Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   Question about db design & webpage implementation (http://www.go4expert.com/forums/question-db-design-webpage-t7132/)

jhenry2808 31Oct2007 14:56

Question about db design & webpage implementation
 
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.

shabbir 31Oct2007 17:15

Re: Question about db design & webpage implementation
 
Moved thread to database forum.


All times are GMT +5.5. The time now is 15:55.