For 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$)$

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

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 ConstraintLayout. This page should display the

VINYL table and the entries from it using TextViews. 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 VinyIID 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 ConstraintLayout.The page should display

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

user using TextViews. 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: cont. in last image.