Three tier development example: our class roster database

1
Three tier development example our class roster
database

• Using ASP
• Using Zoho Creator

2
Class roster using ASP
3
Four screens with transitions
4
Class roster using Zoho service
5
Data entry using Zoho service
6
Features using Zoho and ASP

• View as list, spreadsheet or summary
• Add, delete, and edit records
• Create an RSS feed showing database changes
• Search and sort
• Rearrange, hide or display columns
• Import data from xls, csv, tsv or email
• Export as spreadsheet, csv, pdf, json, tsv or
  html
• Create permalink to data entry form
• Include data entry form in your Web site
• Create permalink to the database or embed any
  view of the database in your Web site

7
Develop and debug class roster

• ASP
• Four screens and plan transitions between them
• 159 lines of script code (includes comments)
• Six files
• Some knowledge of ASP, Visual Basic, and SQL
• One day (less if I were a pro)
• Zoho
• One hour