This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes Developer Certification (SCJD/OCMJD) and the fly likes URLyBird: question about the column 'Date' in DB schema Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Certification » Developer Certification (SCJD/OCMJD)
Bookmark "URLyBird: question about the column Watch "URLyBird: question about the column New topic
Author

URLyBird: question about the column 'Date' in DB schema

Ronggen Liu
Ranch Hand

Joined: Jul 29, 2007
Posts: 40
Hi,

I have a doubt about the column item 'Date' in DB schema,does it mean the latest Date the customer can book the room?

so, when a customer want to book a room, we should check the customers who booked it and the Date,right?

it seems the instruction didn't contain the all fields we can identify a room, the all fields are 'Hotel Name','City','Maximum occupancy of this room','Is the room smoking or non-smoking','Price per night','Date available' and 'Customer holding this record'.

I mean following records may exist in the DB file?
-----------------------------------------------
hotel1 | NY | 2 | Y | 120 | 2008/08/08 | Kate
-----------------------------------------------
hotel1 | NY | 2 | Y | 120 | 2008/08/08 | Tom
-----------------------------------------------

Thanks,
Ronggen


SCJP 1.4,<br />SCJD Java 2,<br />...
 
Consider Paul's rocket mass heater.
 
subject: URLyBird: question about the column 'Date' in DB schema