Android: Online Timetable Sharing backend for assignment 1

From CDOT Wiki
Jump to: navigation, search

I. Requirements and Design for the Android app (the Android client)

  • Add the app feature to search for a person's timetable that will find matches online, and allow to select one.
  • Cache any timetable data downloaded from the online database in the local sqlite database.
  • When adding a person - create an autocomplete mechanism that will check what people exist in the online database already that match what the user is typing, and if so - present those as options to be selected.
  • When adding a new period - do the same autocomplete mechanism for course codes and room numbers.
  • Every time the application starts - check to see whether any of the local timetables have been updated online, and if so - update the local copies as well.
  • Fix any bugs found in Assignment 1.

II. Requirements and Design for the Web Service (the server).

  • The appropriate MySQL schema to serve for this purpose.
  • The PHP code needed to get data from and write/overwrite data to the MySQL database.