Win a copy of The Journey To Enterprise Agility this week in the Agile and Other Processes forum! And see the welcome thread for 20% off.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Jeanne Boyarsky
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
Sheriffs:
  • Paul Clapham
  • Junilu Lacar
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Ganesh Patekar
  • Tim Moores
  • Pete Letkeman
  • Stephan van Hulst
Bartenders:
  • Carey Brown
  • Tim Holloway
  • Joe Ess

B&S: Customer ID question  RSS feed

 
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!
     
    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
     
    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.
     
    author and jackaroo
    Marshal Commander
    Posts: 12218
    278
    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
     
    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.
     
    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
    Posts: 12218
    278
    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
    Boost this thread!