• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

SCJD B&S doubts

 
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic