473,320 Members | 1,991 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

need a little help with creating database

Hello!

I am in the process of creating a database listing tours, something
similar to what you can find on www.infohub.com.

This means that I need to create a database which can be searchable
with destination, category, price and so forth. Unfortunately I can
not seem to be able to create the relationships, neither can I make my
head learn how to do this. I would be extremely happy if anyone could
help me solve this problem for me or at least help me a little on the
way!
Thanks a lot!
Erik
Nov 12 '05 #1
3 1426
do you have any tables defined yet ?
which relationship(s) are you having trouble with ?

here's a quick start...

tblRegion
regionId
region

tblCountry
countryId
country
regionId

tblArea (state, province, region, county)
areaId
area
countryId
parentAreaId (county within a state, city within a province)

tblActivity
activityId
activity
startDate
endDate
dailyRate
weeklyRate

tblContact
contactId
name
address
areaId
phone
fax
email
etc

tblRental
rentalId
rental
rental type (lodge, hotel, ranch, resort)
contactId
marketingDocumentLink
webSiteLink

tblRentalActivity
rentalId
activityId
contactId

er**@freestyletravel.no (Erik Thorsen) wrote in message news:<ed**************************@posting.google. com>...
Hello!

I am in the process of creating a database listing tours, something
similar to what you can find on www.infohub.com.

This means that I need to create a database which can be searchable
with destination, category, price and so forth. Unfortunately I can
not seem to be able to create the relationships, neither can I make my
head learn how to do this. I would be extremely happy if anyone could
help me solve this problem for me or at least help me a little on the
way!
Thanks a lot!
Erik

Nov 12 '05 #2
Hello Roger!

Thanks for getting back to me so quickly. Here is what I have got so
far:

tblTours
tourId
description
longdescription
image1
image2
baseprice

tblCategories
categoryId
categoryname

tblDestinations
destinationId
destinationname

tblOptions
optionsId
optGroup
optName
optPriceDiff
optWeightDiff

I am aware that I probably need to create a junction table or something
like that but I can't seem to get things working. I need each tour to be
available to several different categories and at the same time available
for different destinations.
Like the tour Scandinavian Capitals. This tours goes to Norway, Sweden,
Denmark and Finland. The tour includes husky safari, fishing, cruising,
sightseeing and fjord tour. So somehow I need to make this work by
setting my database up in a many to many relationship way I guess but I
have tried so many times I guess I am as blind as batman right now...
:-) Hope you can help me! Thanks!


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3
Erik Thorsen <er**@freestyletravel.no> wrote in message news:<40***********************@news.frii.net>...
Hello Roger!

Thanks for getting back to me so quickly. Here is what I have got so
far:

tblTours
tourId
description
longdescription
image1
image2
baseprice

tblCategories
categoryId
categoryname

tblDestinations
destinationId
destinationname

tblOptions
optionsId
optGroup
optName
optPriceDiff
optWeightDiff

I am aware that I probably need to create a junction table or something
like that but I can't seem to get things working. I need each tour to be
available to several different categories and at the same time available
for different destinations.
Like the tour Scandinavian Capitals. This tours goes to Norway, Sweden,
Denmark and Finland. The tour includes husky safari, fishing, cruising,
sightseeing and fjord tour. So somehow I need to make this work by
setting my database up in a many to many relationship way I guess but I
have tried so many times I guess I am as blind as batman right now...
:-) Hope you can help me! Thanks!


tblTourCategories
TourID (PK1)
CategoryID (PK2)

tblTourDestinations
TourID(PK1)
DestinationID(PK2)

just take the two PKs from the other tables, make them the joint PK of
the join table, and that's it. And change the type from autonumber to
long.
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

19
by: James Fortune | last post by:
I have a lot of respect for David Fenton and Allen Browne, but I don't understand why people who know how to write code to completely replace a front end do not write something that will automate...
4
by: Amy Snyder | last post by:
I am trying to discern the difference between creating a web service or using IIS Virtual Directory Management for SQL Server Utitly if I want to provide xml data from a database. I have created...
1
by: Ddraig | last post by:
Howdy, I've got a little project going and I am trying to figure out a good way to do this. But since I'm still learning I'm probably missing a few obvious steps. Also not sure if I have my...
1
by: Ddraig | last post by:
Howdy, I've got a little project going and I am trying to figure out a good way to do this. But since I'm still learning I'm probably missing a few obvious steps. Also not sure if I have my...
12
by: nephish | last post by:
Hello there, i am getting to need to make my web stuff more OO. i have a project at work that we are porting to the internet, and i started learning php to do so. the project is now mamoth is...
11
by: Alan Mailer | last post by:
A project I'm working on is going to use VB6 as a front end. The back end is going to be pre-existing MS Access 2002 database tables which already have records in them *but do not have any...
1
by: John Wright | last post by:
I am running a console application that connects to an Access database (8 million rows) and converts it to a text file and then cleans and compacts the database. When it runs I get the following...
2
by: zafar | last post by:
I need to creating backup of database on user defined location in hard disk. thanx for helping in this regard
3
by: dieselfuelonly | last post by:
<?php //Connect to the database and select the data from the table $username="asdfasdf"; $password="asdfasdf"; $database="asdfasdf"; mysql_connect(localhost,$username,$password);...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.