Android: Online Timetable Sharing backend for assignment 1

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.