Scheduling time in slots for appointment in android -

i have requirement application wherein have schedule appointments in time slots. when patient comes doctor, patient ask schedule appointment on particular date. if time slot available, receptionist schedule appointment. consider if particular date appointment not scheduled, when clicked on particular date first time should create new row of time slots day. when appointment scheduled time slot allotted patient should set true, slot values set false. please see time slot below...

10am-11am 11am-12pm 12pm-13pm 13pm-14pm break break 16pm-17pm 17pm-18pm 18pm-19pm 19pm-20pm

guys please me...

thank in advance

you use sqlite database looks this:

date primary key , slots booleans default value false.

whenever new patient comes in , asks appointment on particular date:

• query table see if date exists
• if not:
  • create new row in table
  • set true time slot patient has requested
• if does:
  • check if requested slot available
  • if is, assign patient , set true slot value
  • if not, tell patient pick slot

all pretty simple , straightforward program. if need sqlite , android, check out these tutorials:

• http://developer.android.com/training/basics/data-storage/databases.html
• http://www.vogella.com/articles/androidsqlite/article.html