Page 1 of 1

Database creation query

Posted: Fri Jun 04, 2010 3:33 pm
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

Re: Database creation query

Posted: Fri Jun 04, 2010 4:05 pm
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

Re: Database creation query

Posted: Sat Jun 05, 2010 3:30 am
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?