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
Database creation query
Moderator: General Moderators
Re: Database creation query
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
- 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
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?
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?