Database creation query

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
DonthDragon
Forum Newbie
Posts: 14
Joined: Sun Jan 10, 2010 4:03 am

Database creation query

Post by DonthDragon »

Hi.
I am fairly new to mysql database design, so am not sure about the best route to take on my next project.
I am creating a website that accommodates the following categories :
1. Conference venues
2. Wedding venues

Both conference and wedding venues will have accommodation facilities.
I would like for example : if someone clicks on a conference venue, they will be presented with information about that venue.
Then on that same page I would like a link going to another page that shows the accommodation facilities.

Should I have a database for the conference and weddings; and then another one for the accommodation?

Thanks
Donovan
mikosiko
Forum Regular
Posts: 757
Joined: Wed Jan 13, 2010 7:22 pm

Re: Database creation query

Post by mikosiko »

One Database ... and, I don't know your final objectives.. so I'm just guessing, but I'll suggest 4 tables:

- Venues Types (Conferences, Weddings,<+whatever you want in the future>)
- Accommodations Types (could contain : room, audio equipment, tables, chairs, etc..etc)

- Venues
- AccomVenues ( will contain all the accommodations (or resources) assigned to each specify venue. It represent the relationship between Accommodations and Venues)

hope this help
DonthDragon
Forum Newbie
Posts: 14
Joined: Sun Jan 10, 2010 4:03 am

Re: Database creation query

Post by DonthDragon »

Thanks for your response.

That does pretty much sound like what I need.
I have been doing some research and think a "left-join" might be the right approach to get the tables to relate to each other.
Am I on the right track?
Post Reply