posted 16 years ago
Hi Jeffry Kristianto,
Thanks and sure I 'll share my experience.
Hi All,
I have some doubts regarding the assignment.
The below is the sample database.
name location specialties size rate owner
1.A Smallville Air Conditioning, Painting, Painting 10 $40.00
2.B Smallville Painting, Air Conditioning 7 $55.00
3.C Whoville Air Conditioning 7 $65.00
4.D Bali Hai Air Conditioning 5 $35.00
5.E EmeraldCity Painting 9 $75.00
6.C Atlantis Air Conditioning, Painting, Drywall 10 $40.00
7.A Bali Hai Plumbing, Air Conditioning, Air Conditioning 9 $70.00
1. Here in record 1, the same specilaity say Painting is repeated two times and in record 7, Air Conditioning is repeated twice. Does this mean any thing special or just I have to ignore it.
2. "They take requests from home owners for a type of service, and offer the homeowner one or more contractors that can provide the required services"
According to this, the customer's first input is type of service. So, suppose CSR checks (JcheckBox) Air Conditioning and Painting as the services needed by the customer. Then all the records (1,2,3,4,5,6,7) will be listed matching this criteria.
Option 1: Now CSR (based on customer's input) locks record 1 or 2 offering all the needed services.
Option 2: Or might lock records (4 and 5) or (3 and 5) clubbed together offering all the needed services.
Option 3: If record 6 is locked for minimum rate then that might include the service which is not specified by the customer as the contractor's one of the specialities.
Option 4: If CSR lock records 5 and 7, then that record 7 might include the service (Plumbing) which is not specified by the customer as the contractor's one of the specialities.
3. But as per "It must allow the user to search the data for all records, or for records where the name and/or location fields exactly match values specified by the user".
Here the customer's first input is name and/or location fields of the contractor (dropdown list). Suppose customer gives the location as Bali Hai, the records 4 and 7 displayed. Then if the service needed is Plumbing only, then the CSR has to choose record 7.(This might include the service which is not specified by the customer as the contractor's one of the specialities)
These 3 and 4 contradicts in their way of approach and please suggest which one would be appropriate to proceed.
4. Locking a record for a particular service needed by the customer but which also includes other unwanted services as the contractor's specialiies. Is this ok?
Please give your valuable suggestions and clear my doubts.
Thanks,
Preethy Sekhar alias Kavitha