On exploring databases on the emulator and available devices:

Many content providers in Android use SQLite databases (http://www.sqlite.org/),

user can use tools provided both by Android and by SQLite to examine the databases.

Many of these tools reside in the \android-sdk-install-directory\tools subdirectory.

One of the tools is a remote shell on the device that allows user to execute a command-line

SQLite tool against a specified database.

Android uses another command-line tool called Android Debug Bridge (adb), which is

available as " tools\adb.exe "

Android Database Design Considerations :

There are main two considerations specific to Android that consider when designing database:

A.)  Files (such as bitmaps or audio fi les) are not usually stored within database tables.

Instead, use a string to store a path to the fi le, preferably a fully qualifi ed Content Provider URI.

B.)  While not strictly a requirement, it’s strongly recommended that all tables include an 

auto-increment key fi eld, to function as a unique index value for each row. 

It’s worth noting that if you plan to share your table using a Content Provider, 

this unique ID fi eld is mandatory.