I am designing a database for a travel website. Primarily, the site will be selling golf rounds. On top of the rounds there will also be packages including golf rounds, as well as hotels and transportation.
The information for the rounds will be very detailed and trying to model a hotel booking from a round would be impratical.. or would it? I am wondering how i might design the database. Would you all suggest seperate tables for each "product" (rounds, hotels, transportation etc.) ? The orders and subequent vouchers will also be very detailed for each specific "product" . Hope this question makes sense.
Also how might i represent a package and the pricing for packages in this situation?
I am creating an ERD using Visio. I actually have a site built and a seperate backend that has a more up to date model.. Neither are perfect so i am building a completely new system. In the backend EVERYTHING is explicitly defined. So there are tables for transportation, hotels, rounds, etc. I know this model works BUT i just don't know if it's the way to go.. As the site and business change will the model scale? I have all these use cases in my head and i know where the problems will arise... BUT i am sure that someone with more experience can probably see a bigger picture.
How's your project coming along? Do you have any links for reference? I haven't found any tutorials, books etc. that use a travel site as an example.