• 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

UrlyBird : Queries

 
Ranch Hand
Posts: 53
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I got lotsa queries in my urlybird asignment

1.
Per DB description
4 byte numeric, magic cookie value. Identifies this as a data file
Q. Magic Cookie Value - What should be my role in that?? Do I need to Hardcode this somewhere and check everytime the program is executed whether the db file has this cookie ??

2.
Per Instructions,
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.

Q. Does all records mean the deleted ones too.
Do i have to provide search facility for all the columns possible like smoking,price etc or only name/location

3.
Flag indicating if smoking is permitted. Valid values are "Y" indicating a smoking room, and "N" indicating a non-smoking room
Q . Smoking Y/N
When a user opts for non smoking room Do i need to display Ones with 'Y' flag too As (Practicaly)its upto customer not smoking in a room but booking one that allows smoking.

4.
public void update(int recNo, String[] data, long lockCookie)
and delete

Assignment only describes that we should alow CSR to provide booking facility But these two methods in interfaces does it suggest that CSR can also Update and Delete a particualr record
Should the gui for the same be provided

5. public String[] read(int recNo) throws RecordNotFoundException;
thers no unique recordid in my db schema what does the int recno refer to???

Thanks in Advance
 
Ranch Hand
Posts: 531
1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I got lotsa queries in my urlybird asignment

1.
Per DB description
4 byte numeric, magic cookie value. Identifies this as a data file
Q. Magic Cookie Value - What should be my role in that?? Do I need to Hardcode this somewhere and check everytime the program is executed whether the db file has this cookie ??

- Yes, since the program must allow users to change data files or to find data files, it needs to know which file is a data file.

2.
Per Instructions,
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.

Q. Does all records mean the deleted ones too.
Do i have to provide search facility for all the columns possible like smoking,price etc or only name/location

- No, deleted ones are gone. What it may mean, depending on how you write your application, is all records or only bookable records. I chose to show all bookable records. It cuts off records that can never be used, and it cuts down network traffic.

3.
Flag indicating if smoking is permitted. Valid values are "Y" indicating a smoking room, and "N" indicating a non-smoking room
Q . Smoking Y/N
When a user opts for non smoking room Do i need to display Ones with 'Y' flag too As (Practicaly)its upto customer not smoking in a room but booking one that allows smoking.

- Since there is no search option for smoking or non-smoking fields, both will be shown.


4.
public void update(int recNo, String[] data, long lockCookie)
and delete

Assignment only describes that we should alow CSR to provide booking facility But these two methods in interfaces does it suggest that CSR can also Update and Delete a particualr record
Should the gui for the same be provided

- To book a record, the update method will need to be used. The delete method should be implemented, but it is not used for this application.

5. public String[] read(int recNo) throws RecordNotFoundException;
thers no unique recordid in my db schema what does the int recno refer to???

- The recNo refers to the sequential record numbering of records found in the data file.

Thanks in Advance[/QB]
 
Yogesh Chhawasaria
Ranch Hand
Posts: 53
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Anton Golovin:

- Since there is no search option for smoking or non-smoking fields, both will be shown.



There are seven fields in my database schema
name,location,size,smoking,rate,date,owner

Am I not supposed to provide search option (GUI Widgets) for all these columns like name, location,size,smoking,rate

As per Intructions,
The new application, using the existing data file format, must allow the CSRs to generate a list of accomodations that match a customer's criteria.
...
...
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.

So is searching should be caried out only on name/location and not on any other option???
How can we define "criteria"

 
Anton Golovin
Ranch Hand
Posts: 531
1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
In my project, it was only for name and location. I did not provide anything outside the assignment's scope.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic