Win a copy of The Business Blockchain this week in the Cloud forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Calling all SCJDs!

 
Antonio Vieira
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I was hoping that would get your attention

I�m beginning my URLyBird assignment and I would like to get some clarification on a few things. I�ve identified, pretty obviously, the �Make Customer Booking� use case which describes the interactions a CSR performs when booking a customer with a given accommodation provider. My first iteration of this use case can be summarized as follows:

1.The CSR requests a listing of accommodation providers from the URLyBird System.
2.The URLyBird System displays all accommodation providers.
3.The CSR selects an accommodation provider from the returned list.
4.The CSR provides all required information and makes the booking.
5.The URLyBird system records the booking.

Here�s where I need help:

If an accommodation provider is already booked then how are other bookings recorded? If this were a relational db then we would most likely see an entity called Accommodation Provider and another called Reservation. The relationship would then be described as one-to-many, that is, an Accommodation Provider would have one or more Reservations. How is this described when using a flat file?

Thanks very much and I look forward to gaining and providing insight during the SCJD experience.

Thanks very much.
 
Frans Janssen
Ranch Hand
Posts: 357
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Antonio Vieira:
If an accommodation provider is already booked then how are other bookings recorded? If this were a relational db then we would most likely see an entity called Accommodation Provider and another called Reservation. The relationship would then be described as one-to-many, that is, an Accommodation Provider would have one or more Reservations. How is this described when using a flat file?


Hi Antonio,

For this assignment it is safe to assume that there is a one-to-one relation, i.e. every accomodation can only have one booking. Not quite a realistic situation, but appararently it is not Sun's purpose with the assignment to test our data modeling skills

You'll probably have a field in your flat table in which you can put a customer ID? Put an ID there when it's booked and leave it empty if it isn't.

Frans.
 
Antonio Vieira
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the input.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic