ANDRIOD STUDIO - In this assignment you will begin development of the Wildlife Tracking application (Animal Tracker). The application will store data within a SQLite database (http://www.sqlite.org/) and present the user with the functionality to add a new sighting, update an existing siting, and delete a sighting.

At this point, the database will consist of a single table, called ANIMALS, which is shown below.

Table Name: ANIMALS

_id INTEGER PRIMARY KEY AUTOINCREMENT

animal_type_cd INTEGER FOREIGN KEY TO ANIMAL TYPE TABLE. THE ANIMAL TYPE TABLE WILL BE CREATED IN THE FUTURE. THE DEFAULT VALUE IS 0.

count_no INTEGER THE NUMBER OF ANIMALS SEEN DURING THE SIGHTING

seenon_dtm TEXT THE DATE AND TIME OF THE SIGHTING

comments_txt TEXT FREE FORMAT COMMENTS

In SQLite, TEXT is a reasonable data type to store date, time, and datetime values. See http://www.sqlite.org/lang_datefunc.html for details.

Create a class that interacts with the SQLite database to perform the following operations:

ADD, UPDATE, DELETE (physical), LIST (select all records), and INQUIRE (select one record, by key).

Figure 1 (below) shows the overall flow of the complete the wildlife sightings application. The application will allow the user to view the list of all animal sightings, add a new sighting, view details on a single sighting, modify a sighting, and remove a sighting.

Develop the Animal Sighting List activity and the Add activity so that new animal sightings may be created and stored in the database. Only the List and Add activities need to be completed for this assignment. '

All literal string data must be contained within the strings files (SQL/DML/DDL strings are exempt).

The application must not crash due to invalid or missing input.