Verify the regulation that a Hotel should submit, read the part of the
occupation reports, information gathering, ask management for their
currents report...
Remember the data output should came from the data stored...
On Mon, Feb 20, 2012 at 4:42 PM, Chaim Rieger wrote:
> On 2/17/2012 4:01 AM
On 2/17/2012 4:01 AM, Tompkins Neil wrote:
Hi,
I'm in the process of starting to design a hotel booking system that will
eventually consist of over 10,000 hotels all with different room types,
rates and availability for different dates. My question is does anyone
have any experience with regard
Hi
I am trying to get some background information with regards the design. I have
a fair idea but would like advice from anyone that has previously worked on
similar projects.
On 20 Feb 2012, at 17:22, Jan Steinman wrote:
> Where are your domain experts? You *are* consulting with them, no
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
Hi,
I'm in the process of starting to design a hotel booking system that will
eventually consist of over 10,000 hotels all with different room types,
rates and availability for different dates. My question is does anyone
have any experience with regards the best way to store the daily rates. Am
On 10/8/2010 3:31 PM, Neil Tompkins wrote:
Hi Shawn
Thanks for your response. In your experience do you think I should still
retain the data used to generate the computed totals ? Or just compute
the totals and disregard the data used ?
In my experience, the details matter. Also in my experie
Hi Shawn
Thanks for your response. In your experience do you think I should
still retain the data used to generate the computed totals ? Or just
compute the totals and disregard the data used ?
Regards
Neil
On 8 Oct 2010, at 19:46, "Shawn Green (MySQL)"
wrote:
Hi Neil,
On 10/5/2010
Hi Neil,
On 10/5/2010 5:07 AM, Tompkins Neil wrote:
Hi
I have a number of tables of which I use to compute totals. For example I
have
table : players_master
rec_id
players_name
teams_id
rating
I can easily compute totals for the field rating. However, at the end of a
set period within my ap
Wonder if anyone can help me ?
-- Forwarded message --
From: Tompkins Neil
Date: Tue, Oct 5, 2010 at 10:07 AM
Subject: Design advice
To: "[MySQL]"
Hi
I have a number of tables of which I use to compute totals. For example I
have
table : players_master
rec_id
pl
Hi
I have a number of tables of which I use to compute totals. For example I
have
table : players_master
rec_id
players_name
teams_id
rating
I can easily compute totals for the field rating. However, at the end of a
set period within my application, the values in the rating field are
changed.
> If you are not using 5.0 and don't want to switch to 5.0, then using
> database "view" will also work. This link tells how to create views:
>
http://www.mysql.com/documentation/maxdb/6d/117c44d14811d2a97400a0c9449261/content.htm
What version does this work for? We're using 4.0.14 and it doesn'
tation/maxdb/6d/117c44d14811d2a97400a0c94492
61/content.htm
-Original Message-
From: Ed Lazor [mailto:[EMAIL PROTECTED]
Sent: Friday, February 27, 2004 7:18 AM
To: 'Zhao, Charles'
Subject: RE: Design Advice?
Hi Charles,
Thought of a question... the stored procedure sounds like
Hi =)
How would you approach the design of a database that models the
following information?
- Users
- Invoices
- Purchase Orders
- Sales Orders
- Adjustments
- Products
We were originally working with Users, Purchase Orders, Sales Orders,
and Products. Everything was pretty easy at first... I
PROTECTED]
Sent: Thursday, February 26, 2004 11:15 AM
To: [EMAIL PROTECTED]
Subject: Design Advice?
Hi =)
How would you approach the design of a database that models the
following information?
- Users
- Invoices
- Purchase Orders
- Sales Orders
- Adjustments
- Products
We were originally wo
Hi Charles,
Answers:
1. Frequent web viewers
2. Medium... internal website
3. An invoice will get frequent views while it's active, but very few
views after it's completed.
4. About 1200 entries a month.
Are there approaches other than what I described?
-Ed
-Original Message-
Your
ry 26, 2004 12:16 PM
To: 'Zhao, Charles'; [EMAIL PROTECTED]
Subject: RE: Design Advice?
Hi Charles,
Answers:
1. Frequent web viewers
2. Medium... internal website
3. An invoice will get frequent views while it's active, but very few
views after it's completed.
4. About 12
erver, or blob data in a separate table. Partitioning your invoice
table based on time periods would also be an idea.
-Original Message-
From: Ed Lazor [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 26, 2004 12:16 PM
To: 'Zhao, Charles'; [EMAIL PROTECTED]
Subject: RE: Desi
arrgg, sorry i made a mistake and my precedent mail
was sent before i finished wrting it :-{,
the query is:
INSERT INTO `TBL_COUNT_EXCLUDE`
SELECT MAIN.id, SUM(IF(EX.excl_date BETWEEN
MAIN.start_date AND MAIN.end_date, 1, 0)) AS
excl_count
FROM TBL_MAIN_DATE AS MAIN, TBL_EXCLUDE_DATE AS EX
GROUP
hi all,
i've a question concerning the calculation of the
number of days between 2 dates, and after searching
the mailing list i'm still stuck, any help will be
appreceiated :}
actually i've a table with a lot of rows (varying
between 5 to 15 millions), each row has a unique id
and 2 date:
start_
20 matches
Mail list logo
