Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1161
  • Last Modified:

Database Design for Holiday Packages

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
sivakugan
Asked:
sivakugan
1 Solution
 
mbatuchicCommented:
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
 
ssisworoCommented:
try... Sybase PowerDesigner... powerfull...
http://www.sybase.com/products/modelingdevelopment/powerdesigner
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
Jeffrey CoachmanMIS LiasonCommented:
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
 
sivakuganAuthor Commented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now