Good questions, I need to talk to the client to determine the exact
requirements and
specifications. Thank you every one for helping me to figure out the
potential db-scheme
and for opening my view with your answers :)
On Wed, Aug 19, 2009 at 10:39 PM, Bob McConnell wrote:
> From: Ashley Sherida
From: Ashley Sheridan
> On Tue, 2009-08-18 at 19:15 +0430, Behzad wrote:
>>
>> I'm faced with an interesting and challenging problem.
>>
>> Consider a database, designed for a hotel.
>> At any given time, each room has a different status: It's Busy or
Reserved,
>> or Free.
>>
>> It's easy to ret
At 2:46 PM -0400 8/18/09, Floyd Resler wrote:
I would create a room history table that contained three fields:
room number, status, date stamp. Each time the status of a room
changes insert a new record into the table with the current status
and date/time.
Take care,
Floyd
That's the way I
I would create a room history table that contained three fields: room
number, status, date stamp. Each time the status of a room changes
insert a new record into the table with the current status and date/
time.
Take care,
Floyd
On Aug 18, 2009, at 10:45 AM, Behzad wrote:
Dear list,
e-Gr
-Original Message-
From: Behzad [mailto:behzad.esl...@gmail.com]
Sent: 18 August 2009 04:46 PM
To: PHP General Mailing List
Subject: [PHP] DB Question | A hotel reservation scenario
Dear list,
e-Greetings!
I'm faced with an interesting and challenging problem.
Consider a dat
On Tue, Aug 18, 2009 at 10:45 AM, Behzad wrote:
> Dear list,
> e-Greetings!
>
> I'm faced with an interesting and challenging problem.
>
> Consider a database, designed for a hotel.
> At any given time, each room has a different status: It's Busy or Reserved,
> or Free.
>
> It's easy to retrieve nu
On Tue, 2009-08-18 at 19:15 +0430, Behzad wrote:
> Dear list,
> e-Greetings!
>
> I'm faced with an interesting and challenging problem.
>
> Consider a database, designed for a hotel.
> At any given time, each room has a different status: It's Busy or Reserved,
> or Free.
>
> It's easy to retriev
Dear list,
e-Greetings!
I'm faced with an interesting and challenging problem.
Consider a database, designed for a hotel.
At any given time, each room has a different status: It's Busy or Reserved,
or Free.
It's easy to retrieve number of Free rooms at the current time.
But how can I count the n
8 matches
Mail list logo
