Scenario

The mission of the Boston College Football Club is to nurture and develop young football talent while also enriching their lives through academic brilliance. The Club provides student$-$athletes with the opportunity to develop as graduates and professional football players by providing competent coaches. To enable smooth registration of aspiring footballers at your support centre you have been asked to develop an Android application that uses SQLite to store student details.

The proposed system should have the following specifications:

The application should use a Navigation Drawer Activity template.

The app should allow a user to insert, view and delete student records $($student number, name, gender, and faculty$).$

The app should be able pull$-$to$-$refresh the list when a record has been deleted.

Insert Student

Name

Student Number

Gender

Female

Male

Faculty

Question $1$

$[70$ marks$]$

Develop the Android app described in the scenario above. Use SQLite as your database.

NB$.$ A zipped folder of the main folder of the application project should be submitted on Colcampus

$2$

HASD$200-1-$Jul$-$Dec$2022-$SA$1-$RM$-$V$2-31052022$