We need an Eclipse project for Android which will run on a Samsung Galaxy Tab 10.1 Version 3.1
The system consists of 17 tables in a SQLite database and related input/viewing screens. (See Detailed Description)
## Deliverables
We need an Eclipse project for Android which will run on a Samsung Galaxy Tab 10.1 Version 3.1
The system consists of the following tables in a SQLite database
SiteDetails 14 Fields
SiteArea 27 Fields
SiteQuestion 12 Fields
SiteRA 28 Fields
SiteMisc 10 Fields
SiteDilap 17 Fields
Questions 5 Fields
QuestionList 3 Fields
QuestionListQuestion 7 Fields
QuestionListSupplementary 5 Fields
QuestionReport 5 Fields
QuestionListQuestion 7 Fields
ReportName 2 Fields
ReportParagraph 8 Fields
AreaType 2 Fields
Answer Type 2 Fields
Building Type 2 Fields
SurveyGroup 2 Fields
The first 6 tables SiteDetails, SiteArea, SiteQuestion , SiteRA ,SiteMisc, SiteDilap require screens allowing create, read, update and delete.
All other tables will need to have data deleted and then imported from an XML file (at irregular and on demand intervals).
The first six tables are linked with the SiteDetails as the parent, SiteArea (joined on SiteDetailsID) as a child, SiteRA (joined on SiteDetailsID) as a child, and the remainder as grandchildren (joined on SiteAreaID).
The opening screen needs to have a single button into a menu. (We will add our own user login screen here)
The menu needs to display a list of Sites and the option to add display a page allowing us to add a new site.
Once the site is created we need to be able to insert the SiteRA records. These will need Latitude and Longitude detecting.
Once the SiteRA is complete the SiteArea details can be entered.
Once the SiteArea details have been entered the SiteQuestion , SiteMisc, and SiteDilap details cen be entered. Each of these tables will have multiple entries for each SiteArea.
Only basic input screens are required for each area. We will add our own validation and processing later.
All code provided should allow us to build in the validation and processing with the minimum effort.