Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Ronggen Liu
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic