Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

database fields

 
mark crannage
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

The "database" flat file that I got with my certification specifications has only the following fields:

Hotel Name
City
Maximum Occupancy
Smoking/Non-Smoking
Price per night
Date available
Customer holding this record

These fields are not adequate due to:
* a room cannot be uniquely identified
* a customer cannot book a room for certain periods, eg. in advance 10/5/2007 to 10/10/2007
* cannot check when a room is booked(ie. between certain date) only when its available

Does anyone have any idea if the above inadequacies are intentional and if so how to work around this? The specifications say that a search of the database will only be based on name and/or location..

thanks in advance,

Mark C
 
Musab Al-Rawi
Ranch Hand
Posts: 231
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Some of requirements are left for you to decide based on your understanding mainly and whatever you think is appropriate.

I suggest that you read the requirements again.
But consider to make things as simple as possible for example: if a room is reserved then it is simply occupied NOW/TODAY, don't worry about dates and periods of days unless you are asked to.

hope that helps.
 
mark crannage
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Thanks for the response. Well even if I wanted the application to be able to book rooms in advance by specifying duration of booking I would have to modify the database file format and content which is not allowed per my understanding.

thanks,

M.C
 
Romeo Kienzler
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Marc,
some suggestions:

a room cannot be uniquely identified

Use the "position" / recNo of the record in the file as primary key,
see http://www.coderanch.com/t/189413/java-developer-SCJD/certification/search-update


a customer cannot book a room for certain periods, eg. in advance 10/5/2007 to 10/10/2007

This is not a requirement

cannot check when a room is booked(ie. between certain date) only when its available

This is not a requirement


Greetings
Romeo
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic