MySQL Forums
Forum List  »  Database Design & Data Modelling

Advanced Search
New Topic

Re: Theme Park Database
Posted by: Tenn Seven
Date: July 26, 2011 10:39AM

Well, if by "no data" you mean there was a visit but no rides, then the table structure I proposed above would handle that. If by "no data" you mean no visits at all, then I'm not sure why you would want to report it, but the very absence of a date in the table I proposed above would denote that there were no visits on that date.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Theme Park Database
Sparkle Girl
July 13, 2011 06:33PM
Re: Theme Park Database
Peter Brawley
July 15, 2011 07:28AM
Re: Theme Park Database
Rick James
July 15, 2011 10:19PM
Re: Theme Park Database
Peter Brawley
July 16, 2011 03:34AM
Re: Theme Park Database
Rick James
July 16, 2011 01:32PM
Re: Theme Park Database
Tenn Seven
July 24, 2011 02:03AM
Re: Theme Park Database
Peter Brawley
July 24, 2011 07:22AM
Re: Theme Park Database
Tenn Seven
July 26, 2011 10:39AM
Re: Theme Park Database
Peter Brawley
August 22, 2011 11:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.