Stuck building Hotel database ! (1 Viewer)
- Thread starter coda7777
- Start date
GinaWhipp
AWF VIP
- Local time
- Today, 12:16
- Joined
- Jun 21, 2011
- Messages
- 5,876
From what I understood... A Customer on a Tour could be going to several Countries or multiple locations within the same Country thereby staying at multiple Hotels.
As for my Naming Convention... to each their own.
Don't really want to add on to this thread with that discussion.
As for my Naming Convention... to each their own.
Don't really want to add on to this thread with that discussion.
GinaWhipp
AWF VIP
- Local time
- Today, 12:16
- Joined
- Jun 21, 2011
- Messages
- 5,876
No problem.
I got the impression it was handling tours and the reservations during such tour. So I did the Customer > Destination(s) > Hotel(s). Side note, I originally posted a Hotel Reservation Data Model and then it was explained that the Reservations were not the primary.
As to the prefixes, I too have been doing for more years then I care to mention and 99.9$ of my Functions and code already take them into account. So, if I changed now, not that I would to as I like them, I would have have tons of re-usable code and Functions to update. Well, maybe not Functions as only about .5 % take actual table and\or field names into account.
I got the impression it was handling tours and the reservations during such tour. So I did the Customer > Destination(s) > Hotel(s). Side note, I originally posted a Hotel Reservation Data Model and then it was explained that the Reservations were not the primary.
As to the prefixes, I too have been doing for more years then I care to mention and 99.9$ of my Functions and code already take them into account. So, if I changed now, not that I would to as I like them, I would have have tons of re-usable code and Functions to update. Well, maybe not Functions as only about .5 % take actual table and\or field names into account.
Similar threads
