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

B&S: Customer ID question

 
Jared Chapman
Ranch Hand
Posts: 81
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello everyone! In my database schema, the last field is the owner of the contractor. The detailed description states
The id value (an 8 digit number) of the customer who has booked this. Note that for this application, you should assume that customers and CSRs know their customer ids. The system you are writing does not interact with these numbers, rather it simply records them. If this field is all blanks, the record is abailable for sale.

My question is this: if I do not interact with the numbers, how do I record them? I guess I just don't understand what Sun wants me to do.
Do I
  • 1. Prompt the user to enter an 8 digit number and record it
  • 2. Record a generic value to simulate a customer/CSR entering the correct id
  • 3. None of the above
  • Any feedback would be greatly appreciated. Thanks!
     
    Javini Javono
    Ranch Hand
    Posts: 286
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Hi,


    The id value (an 8 digit number) of the customer who has booked this. Note that for
    this application, you should assume that customers and CSRs know their customer ids.
    The system you are writing does not interact with these numbers, rather it simply records
    them. If this field is all blanks, the record is abailable for sale.


    One small warning: I don't have your assignment, so I hope those that are perhaps
    better informed will speak up. Possible hint: have you scanned the instructions to
    see if there are any other topics which relate to this question, and shed light on it
    directly or indirectly?

    Here is what I have done so far; but, please note that there are a myriad of choices
    people have made in the past (I have UrlyBird). If I did not have what they called
    the client ID stored, I randomly generated it, and documented that this simulates
    some process where the new user is assigned a client ID. In the user interface, the
    user is free to modify the text that represents the client ID. And, when the user
    books a record, I simply store their client ID in the appropriate field in the database.

    Thanks,
    Javini Javono
     
    Mike Keller
    Greenhorn
    Posts: 9
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    I believe it is the CSR's responsibility to know the customer ID. Assume the CSR knows it and allow them to enter it.
     
    Andrew Monkhouse
    author and jackaroo
    Marshal Commander
    Pie
    Posts: 12014
    220
    C++ Firefox Browser IntelliJ IDE Java Mac Oracle
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Hi Jared,

    Welcome to JavaRanch and this forum.

    You might want to check whether your assignment has text similar to:


    Note that for this application, you should assume that customers and CSRs know their customer ids. The system you are writing does not interact with these numbers, rather it simply records them. If this field is all blanks, the record is available for sale.


    If so, then the end user (the CSR) will know what the number is, and they will enter it into your application when they book the record - this means that you will need to have some data entry facility (a text field / a dialog box / ...).

    Javini's concept is intreresting, and certainly makes testing easier. I don't think it would work in a real life application though.

    Regards, Andrew
     
    Clivant Yeo
    Ranch Hand
    Posts: 124
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    I simply take in the customer id submitted by the CSR. But I check for one thing: the number cannot be greater than the size in bytes as specified in the schema; otherwise my backend data storage classes will throw a IllegalArguementxception. I still assume that the CRS know the Id, but just in case my data storage goes chaos, I checked for the maximum allowed size the cust id can have.

    Hope my humble opinion helps.
     
    Jared Chapman
    Ranch Hand
    Posts: 81
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Thank you all! I think I'll use a dialog box to ask for the customer id, check to make sure the input is valid, and (if valid) write it to the db.
     
    K Huang
    Ranch Hand
    Posts: 55
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    How about "find" ? Sounds like I should not let user find by this field because my system does not interact with these numbers.
     
    Andrew Monkhouse
    author and jackaroo
    Marshal Commander
    Pie
    Posts: 12014
    220
    C++ Firefox Browser IntelliJ IDE Java Mac Oracle
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Hi K,

    Correct - you do not need to interact with these numbers at all, and that includes not needing to search for them.

    Regards, Andrew
     
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic