Please HELP. In Android Studio using java, create a system that serves to reserve vinyl

records. The system should create and make use of a database and tables for information using

the SQLite database. The main activity, second activity, third activity, fourth activity, and fifth

activity should be fetching data, inserting data, and removing data from the required database

based on the requirements for each activity. The database design goes as follows:

Customer Table:

CustomerID $($Primary Key$)$

Username

Password

Admin Table:

AdminID $($Primary Key$)$

Username

Password

Vinyl Table:

VinylID $($Primary Key$)$

Title

Artist

Genre

ReleaseYear

Availability

RESERVATION Table:

ReservationID $($Primary Key$)$

CustomerID $($Foreign Key referencing Customer.UserID$)$

VinyIID $($Foreign Key referencing Vinyl.VinyIID$)$

DateReserved

Database Entries: Here are Entries to be inserted for the Customer, Admin, and Vinyl tables:

Customer Table:

Entry $1$: Daisy Jonessix $($Username$)$; Fl$33$twoodMac $($Password$)$

Entry $2$: PinkSlip $($Username$)$; Fr$3$akyFriday $($Password$)$

Entry $3$: TheDreams $($Username$)$; Dr$3$amG$1$rls $($Password$)$

Admin Table:

Entry $1$: MartyWolf $($Username$)$; B$1$ gFatL$1$ar $($Password$)$

Entry $2$: LuciousLion $($Username$)$; $3$mpire $($Password$)$

Entry $3$: PaperBoi $($Username$)$; At$1$anta $($Password$)$ Vinyl Table:

Entry $1$: Love Deluxe $($Title$)$; Sade $($Artist$)$; R&B$/$Soul $($Genre$)$; $1992($ReleaseYear$)$; Available

$($Availability$)$;

Entry $2$: To Pimp a Butterfly $($Title$)$; Kendrick Lamar $($Artist$)$; Hip$-$Hop$/$Rap $($Genre$)$; $2015$

$($ReleaseYear$)$; Available $($Availability$)$;

Entry $3$: Condition $($Title$)$; Salute $($Artist$)$; Alternative $($Genre$)$; $2019($ReleaseYear$)$;

$($Availability$)$;

Entry $4$: NeverMind $($Title$)$; Nirvana $($Artist$)$; Alternative $($Genre$)$; $1991($ReleaseYear$)$;

$($Availability$)$;

Entry $5$: I Want You $($Title$)$; Marvin Gaye $($Artist$)$; R&B$/$Soul $($Genre$)$; $1976($ReleaseYear$)$;

$($Availability$)$;

Main activity: Design a login page by using ConstraintLayout. Define $2$ TextViews $($one with "User

Name", and the other with "Password" as their texts$),2$ corresponding EditTexts $($for User Name

and Password$),$ and $1$ Button $($with "LOGIN" as its text$).$ Also define and put one TextView for error

message which could be used in Step $2.$ Make sure the password won't show in clear text. When

you rotate the device, make sure you persist the inputs. Define an ImageView in order to insert an

image for a logo$.$ When the LOGIN button is clicked, if User's Name and the Password match an

entry from either the Customer database table or the Admin database table $($both the username

and password columns from the row have to match$),$ then please launch the second activity and

pass the user name to the second activity. $($Hint: Passing Bundle on StartActivity$)$ Otherwise, put

some error message to prompt the user. The error message could be something like "Incorrect

login credentials. Try again." Make sure you follow the rules defined here.

Second Activity: On the second activity please put a sentence like "Welcome XXX$".$ XXX

represents the user name that is passed from the login activity. That is$,$ you can not hard code the

user name. Define $4$ Buttons $($one with "VIEW CATALOG", one with $"$MY RESERVATION", one with

"LOGOUT", and one with "EDIT CATALOG"$).$ If the user currently logged in is from the

CUSTOMER database table, then do not show the "Edit Catalog" button and make it inactive.

Otherwise, show the button and make it active. After the VIEW CATALOG button is clicked, launch

the third activity. After the MY RESERVATION button is clicked, launch the fourth activity. After the

EDIT CATALOG button is clicked, launch the fifth activity. After the LOGOUT button is clicked,

return back to the main activity and start over. Make sure you follow the rules defined here.

Third Activity: Design a catalog page by using TableLayout. This page should display the VINYL

table and the entries from it$.$ Each entry should have its own RESERVE button defined to the

VinyIID. When the RESERVE button is clicked, a entry should be made into the RESERVATION

table, matching the VinylID from the Vinyl table and the CustomerID from the CUSTOMER table,

then launching the fourth Activity $($only if the Availability cell is equal to "Available"$).$ Otherwise,

put some error message to prompt the user. The error message could be something like "The

product is not available." Define a TextView with "VINYL CATALOG" as its text. Additionally,

Define a button named RETURN, which upon clicking will return back to the second activity. Make

sure you follow the rules defined here. Fourth Activity: Design a reservation page by using TableLayout.The page should display any

created Reservation table entries passed by the third activity that is allotted to the current user.

Define a TextView with $"$MY RESERVATION" as its text. The DateReserved cell should reflect the

date that the entry was made. Additionally, Define a button named RETURN, which upon clicking

will return back to the second activity. Make sure you follow the rules defined here.

Fifth Activity: Design a catalog page by using TableLayout.