How to make database design for booking system ?

Creating tables and queries
Post Reply
ahmedsa
Posts: 3
Joined: Thu Jul 13, 2017 2:49 pm

How to make database design for booking system ?

Post by ahmedsa »

this is database design expected to website http://www.egypte.nl
* every package have only one hotel .
* every package have only one program .
* package have more duration may be 8 or 15 or 21 days only so that i have many in package duration table .
* day details data is fixed meaning not every day change hotel accommodation per program or flight or transfer or excursion .
hotel booking include period accommodation + flight cost + transfer cost
program tourists booking include hotels accommodation + flight costs + transfer costs + excursion costs

Code: Select all

PackagePackageID  PackageName Duration
  01             hotelpackage 8,15
PackageDuration
PD01  01  8  7
PD02  01  15 14 (7,14 represent nights,nights=days-1)
DurationDetails
DD01  PD01 DAY1
DD02  PD01 DAY2
DD03  PD01 DAY3
Until 8 days etc
DayDetails
Day1  Hilton Hotel
Day1  flight
Day2  Hilton Hotel
Day3  Hilton Hotel
Day4  Hilton Hotel
Day5  Hilton Hotel
Day6  Hilton Hotel
Day7  Hilton Hotel
Day8  flight
DayDetailsCost
26/06/2017 50
26/06/2017  500
27/06/2017  50
28/06/2017  50
29/06/2017  50
30/06/2017  50
01/07/2017  50
02/07/2017  50
03/07/2017  500
OpenOffice 3.1 on Windows Vista
User avatar
keme
Volunteer
Posts: 3699
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: How to make database design for booking system ?

Post by keme »

Database design is a fairly complex matter, requiring intimate knowledge about your data (how data elements connect and otherwise relate) and the rules of normalizing up to BCNF at least.

Some would argue that 3NF is sufficient. Example data sets often fail to illustrate the overlapping key issue which may make a 3NF database break BCNF constraints. In real world databases, the issue is not so rare. With a non-BCNF structure, some queries may require 2-3 times the complexity that a properly normalized BCNF structure does. Going to 4NF and beyond may be useful, but 4NF+ constraints may also be better implemented by other scripting than SQL.

While there certainly are helpers here who have the knowledge and experience required, the full design process is outside the usual scope of our assistance. You may get the help you request, but it is likely that you will need to pay for it. (For myself, I have the knowledge as such, but not enough recent experience to work efficiently, nor the time available for such a task.)

If you have the time, read up on normal forms (NF) and find online exercises/tutorials. If you need this done any time soon and have little or no experience in DB normalizing, do not venture to build a production base of any complexity. Look for ready made solutions that can be tweaked to your needs, or get professional help. Mistakes can get really expensive (in terms of money as well as business reputation).
Apache OO 4.1.12 and LibreOffice 7.5, mostly on Ms Windows 10
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: How to make database design for booking system ?

Post by John_Ha »

I fully agree with keme.

As a business, you are much better advised to buy a web-enabled booking database package than you are to write one yourself and it will save you endless heartache. Google booking database for numerous examples - they will be designed to work seamlessly and effectively with PCs, tablets and mobile phones. Remember the problems British Airways had - it cost BA £ hundreds of millions.

Once you have the database, you can then design your own queries and reports but purchase a fully supported, robust, business strong database to start with.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
ahmedsa
Posts: 3
Joined: Thu Jul 13, 2017 2:49 pm

Re: How to make database design for booking system ?

Post by ahmedsa »

How can i buy that and how much does it cost ?
OpenOffice 3.1 on Windows Vista
User avatar
keme
Volunteer
Posts: 3699
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: How to make database design for booking system ?

Post by keme »

ahmedsa wrote:How can i buy that and how much does it cost ?
See this:
https://www.getapp.com/customer-managem ... -database/
Note the compare feature.

Take a look at a few free trials and see whether your required features are available.

Do not hurry!
Apache OO 4.1.12 and LibreOffice 7.5, mostly on Ms Windows 10
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: How to make database design for booking system ?

Post by John_Ha »

ahmedsa wrote:How can i buy that and how much does it cost ?
In addition to keme's useful link ...

Google booking database for numerous examples.

Check out some other company web sites similar to your own and see what they use and who designed their site. Contact the site webmaster at that website to see what they use and why. If you contact a website which is not a direct competitor they are almost always willing to speak to you. Contact the site designer of a similar website to see how much he would charge to do it for you.

Can you find a Business Software Fair - go to it. Check IT magazines for adverts.

Are you a member of an industry organisation? If so, ask their advice.

The Netherlands almost certainly has an organisation which is set up to give advice to small businesses. Check with them.

You may find it is more cost effective to buy a complete web service - a bookings database and an integrated secure payments system - than to buy the two things separately and integrate them.

Remember that management will not praise you for doing all the work yourself to save money; and that they will come down on you like a ton of bricks if your system ever fails. What is the business cost of being down for 48 hours? A week? It's an old adage "You remember the quality long after you have forgotten the cost".
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Post Reply