Create a new application which implements a simple FILE based database in Android using a disk file and an array$/$list in memory. The application will have the ability to create new records, update$/$edit records, show a list of all the records in a scrolling list, and delete records from the file. $($The word DATABASE below is the same as saying a written file and array$/$list$)$

The database will have the following fields:

recordID, name, description, price, rating, date$\_$modified, date$\_$created.

recordID, date$\_$modified, and date$\_$created will never be Editable by the user and will be auto created and updated by the program.

Name is required $-$ so you must use validation on the input field and never store an empty string for this field.

Date modified should be automatically updated when anything changes in the record. Date created is the date the record is created. These should not be editable. Rating should be a value between $1$ and $5.$

The default home page will show a RecyclableList of all the items in the database with the name, and short description, price and rating in each "cell" of the list. Clicking on one of the cells, will bring up another page which will show the detail of the page with all the other fields. From this page, the user should be able to edit the data and delete the record. There should be $4$ different activities that implement the CRUD associated with the database.

Fill the database$($file$)$ with $40$ records of sample data. Provide a button called "Test Data" that will fill your database with $40$ random records.

Example MOCKUPLinks to an external site.

I have lots of older videos that use Java as the language, but this is a case where LOTS of videos and tutorials are using Java still and it is a good lesson in converting the knowledge to work with newer languages.

Have fun!

Submit the entire project as a zip file here.

Rubric

File Based DB and CRUD

File Based DB and CRUD

Criteria Ratings Pts

This criterion is linked to a Learning OutcomeCreate Record

$20$ pts

Full Marks

$0$ pts

No Marks

$20$ pts

This criterion is linked to a Learning OutcomeRead Record

$20$ pts

Full Marks

$0$ pts

No Marks

$20$ pts

This criterion is linked to a Learning OutcomeUpdate$/$Edit Record

$20$ pts

Full Marks

$0$ pts

No Marks

$20$ pts

This criterion is linked to a Learning OutcomeDelete Record

$15$ pts

Full Marks

$0$ pts

No Marks

$15$ pts

This criterion is linked to a Learning Outcome$6$ Fields in Record

$10$ pts

Full Marks

$0$ pts

No Marks

$10$ pts

This criterion is linked to a Learning OutcomeHomePage is RecyclableList of ALL records

$20$ pts

Full Marks

$0$ pts

No Marks

$20$ pts

This criterion is linked to a Learning OutcomeClicking on one item in the list goes to SHOW page

$5$ pts

Full Marks

$0$ pts

No Marks

$5$ pts

This criterion is linked to a Learning OutcomeShow page has edit and delete buttons

$5$ pts

Full Marks

$0$ pts

No Marks

$5$ pts

This criterion is linked to a Learning Outcomedelete button has confirmation dialog and deletes properly

$20$ pts

Full Marks

$0$ pts

No Marks

$20$ pts

This criterion is linked to a Learning Outcomeedit button goes to edit page

$10$ pts

Full Marks

$0$ pts

No Marks

$10$ pts

This criterion is linked to a Learning Outcomesave changes on edit page goes to show page and saves data

$25$ pts

Full Marks

$0$ pts

No Marks

$25$ pts

This criterion is linked to a Learning OutcomeAdd Record button on Main Page goes to new activity and creates record

$25$ pts

Full Marks

$0$ pts

No Marks

$25$ pts

This criterion is linked to a Learning Outcome$40$ records created in database with a button$/$function

$5$ pts

Full Marks

$0$ pts

No Marks

$5$ pts

Total Points: $200$