Exercise: Using a database from an Android Application

In this exercise you must use an SQLite database from an Android application ...

More info http://developer.android.com/guide/topics/data/data-storage.html#db

Getting ready

  1. Make a database design (pen + paper): only one table with 3-4 columns, including an ID column.
  2. Make an DBAdapter class (ordinary Java class, NOT an Activity), Lee page 274.

Making Activities

  1. Program an Activity with buttons like: ShowAll, New Entry, and Search.
  2. Program the ShowAll Activity.
  3. Program the New Entry Activity.
  4. Program the Search Activity

Foreign keys

Make another SQLite database with 2 tables, and check if foreign keys work or not