Solved

Database Design for Holiday Packages

Posted on 2011-03-14
6
1,032 Views
Last Modified: 2012-05-11
Hi,

I am developing an Holiday package website.
I would like to see some similar,( sample) relational database design?
Can anyone post the relational DB design plz?

Thanks
0
Comment
Question by:sivakugan
6 Comments
 

Expert Comment

by:mbatuchic
ID: 35134795
Well, there are lots of database design tools.  One of them is SQL Server.  Do you want a free version, then you can download the Express SQL Server at :

http://www.freewarefiles.com/Microsoft-SQL-Server-Express-Edition-Service-Pack-1_program_17936.html

Or you can use a free open source database design at :

http://flagrantdisregard.com/free-database-modeling-software/

0
 
LVL 3

Expert Comment

by:ssisworo
ID: 35135148
try... Sybase PowerDesigner... powerfull...
http://www.sybase.com/products/modelingdevelopment/powerdesigner
0
 
LVL 9

Expert Comment

by:kaminda
ID: 35135431
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35139217
There really is no template for something this specif

But to be sure, can you clearly define what you mean by: "Holiday package website"?
("Holiday vacation package website",... perhaps?)
...And be a bit more specific about your requirements.
0
 

Author Comment

by:sivakugan
ID: 35142500
My requirement is this
--------------------------
It is a holiday vacation package website. There are 5 different holiday vacation package.
It will be increase in future. I would like to know how the Relational Database Design would be for this?.For an example ..How many entities and what are they in normal scenario of  holiday vacation package.?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 35144354
That depends on the entire scope of your app.

Will you be tracking:
Prices
Fights
Airlines
tickets
Refunds
Reschedules
Package  organizers (Perillo, Sandals, Disney, Carnival, ..etc)
Specials
Discounts
Credit card data
Payments
Partial Payments
travel agents
Contacts
...etc

In other words there really is no "Normal Scenario of holiday vacation package"
...you need to be a bit more specific about the scope of your application.

JeffCoachman
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question