From: Claudio Nanni Date: February 20 2012 7:20pm Subject: Re: Design advice for hotel availability program List-Archive: http://lists.mysql.com/mysql/226822 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=bcaec553fee873b73604b96a30bc --bcaec553fee873b73604b96a30bc Content-Type: text/plain; charset=ISO-8859-1 Hi, Nobody answers because this is a very wide question about software engineering, Trust me, It seems like a simple question but it is not. The only advice I can give you is to try to imagine all possible scenarios/use-cases before starting the design. Cheers Claudio 2012/2/20 Jan Steinman > Where are your domain experts? You *are* consulting with them, no? > > If you don't know the answers, and don't have access to domain experts to > help you, I would design for the most general case, and factor out > exceptions as they prove to be so. "Pre-optimization" for exceptions almost > always turns out to be a bad choice. > > > From: Tompkins Neil > > > > .... Am > > I best using the following pattern > > > > (1) Default rates/rooms stored in a generic table > > (2) Any exceptions/changes/closed days to the daily rates are store in > > a separate table. > > (3) Any special offer exceptions are stored as a rule > > > > All, should I consider that for any hotel, for any room, for any day I > have > > a record in a huge single table ??? > > ---------------- > Everything we think we know about the world is a model... None of these is > or ever will be the real world. -- Donella H. Meadows > :::: Jan Steinman, EcoReality Co-op :::: > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > > -- Claudio --bcaec553fee873b73604b96a30bc--