1. Is the final target is to display a list of contractors for the CSRs to generate a list of contractors? and if so how would we get the customers criteria?Is it assumed that the CSRs know the customers criteria and a search box would be sufficient i.e after storing the values in the database file a simple search box is to implemented so that the CSRs can enter the search criteria and get their results in the JTable.I hope I need to implement a search box
The next is regarding the Database Schema
2.Regarding the database schema.
Number of staff in organization- The number of workers available when the record is booked.
Is this number has to be changed or manipulated I don't exactly understand why this field is given.Is this just the data that has to be presented to the CSRs or if i have to manipulate this number.
I have this doubt since it says the workers available when this record is booked.What does booking mean?Is it the GUI that is presented when the CSRs enter in the GUI(following this the call to the createRecord) or a user interface for booking the record matching the user(home owner) criteria) has to be given separately by which the staff in the organization has to be modified
In Customer holding this Record it says
The id of the customer who has booked this.Note that for this application, you should assume that customers and CSRs know thier customer ids.The system you are writing does not ineract with these numbers rather it simply records them. If this field is all blanks the record is available for sale
I don't get the last line.It says if all blanks the record is available for sale.But it has also been mentioned that our system does not deal with these numbers.So i would like to know When this field will be filled and when this field will be left empty. i.e i don't exactly understand what the record is available for sale means.
I heart fully thank all of you for patiently reading my long query and i request you to please clarify them
I think you may be asking too many questions at once. This makes it difficult for people to patiently read your request and then come up with solutions for you. You may try to ask a question (or group of questions) per post. I guess it will also make the responses clearer.
I am not quite familiar with the B&S but I think I may be able to answer some of your questions.
I hope I need to implement a search box
Yes. Most of the projects would require you to have some kind of textbox (or other input system you come up with) to type in a criteria that is used to search for appropriate records.
Is the final target is to display a list of contractors for the CSRs to generate a list of contractors?
I am not sure what you mean here. But I think that the database (or file) would have all records (in this case, I guess, the list of all contractor records). Your aim is to use the criteria provided by the CSRs to filter out the records that match the specified criteria. There may however be cases where the CSR is interested in seeing all records in the database.
Is it assumed that the CSRs know the customers criteria and a search box would be sufficient
Yes. You may assume that the customer has informed the CSR of the criteria and the CSR types in the criteria in the application to find available records that may suite the customer. HOWEVER, it is IMPORTANT that you carefully read your 'requirements document' to ensure you have your details correct.
Would you need a JTable?
Most likely, Yes. You may want to search the forum for user interface designs (or application window snapshot) that have been posted in the past. Reading an SCJD book should also make this clearer.
Regarding the database schema...
I am not familiar with the B&S so I may not be able to appropriately answer this question. But I doubt that you are required to modify fields in the database other than specifying whether or not a customer (via the CSR) has reserved a particular record. Usually you mark the record by the customer's identity number (customer ID).
In Customer holding this Record it says... I don't get the last line...
Generally, Whenever the CSR reserved a record for a customer (using the application), the application would mark that record with the customer's ID. you should assume ficticious IDs for your customers. Just allow the CSRs a textbox where they can type in some funny customer ID to identify the current customer. When the CSR clicks the reserve record button for the customer, the record should be marked as reserved with the customer's ID if it is free or an application error should be triggered to inform the CSR that the record has already been occupied by another customer as may be visible by an already existing customerID on the customerID field.
That was a long one. I have tried to be very direct. Please confirm from your specification that you are doing the right thing (which may defer slightly from my explanations). Hope you understood my response.
Take care and have fun coding.