Implement an application with database involved. The application: $1.$Work with Postgresql database server. $2.$Provide a way to $$communicate$$with end users a$.$Graphic user interface b$.$Console $3.$Display data from database upon user requests $4.$Update $($insert$/$update$/$delete$)$data in database upon user requests Database: Postgresql database server Language: Java or C# Data model size: at least $5$entities with some relationships $($one to many, many to many$)$Team size: $23$members per team $*$Do not reuse the project you did in other classes. You can reuse the topic, but not the code. $*$You need to write program to connect to the database server, include SQL statements in program to retrieve and update data. Do not relies on existing frameworks to generate SQL statements. What to submit in the final package: $1.$Team members $(2-3$per team$)2.$Report on how the work been distributed among team members $3.$Project requirement doc a$.$Topic $($domain$)$b$.$List functionalities will be implemented in the project $($use bullet items, not paragraph$)4.$ERD for data modeling $5.$Script $(.$sql file$)$for creating tables, views, functions, index and inserting initial records Views, functions, index are optional $6.$Class design $($list classes and methods in each classes$)7.$Source code

In Java or C#

Making a rudamentry pet store inventory system.

create table breed $($

breed$\_$id serial,

breed$\_$name varchar$(100)$ unique not null,

primary key $($breed$\_$id$)$

$)$;

create table guinea$\_$pig $($

guinea$\_$pig$\_$id serial,

guinea$\_$pig$\_$name varchar$(100)$ not null,

breed$\_$id int not null,

age int,

description varchar$(256),$

availability varchar$(50),$

price decimal$(10,2),$

primary key $($guinea$\_$pig$\_$id$),$

foreign key $($breed$\_$id$)$ references breed $($breed$\_$id$)$

$)$;

create table shopper $($

shopper$\_$id serial,

first$\_$name varchar$(100)$ not null,

last$\_$name varchar$(100)$ not null,

email varchar$(200)$ unique not null,

card$\_$number varchar$(30)$ not null,

phone$\_$number varchar$(30),$

primary key $($shopper$\_$id$)$

$)$;

create table delivery$\_$address $($

address$\_$id serial,

street varchar$(100)$ not null,

city varchar $(100)$ not null,

state varchar$(100)$ not null,

zip varchar$(50)$ not null,

country varchar$(100)$ not null,

shopper$\_$id int not null,

primary key $($address$\_$id$),$

foreign key $($shopper$\_$id$)$ references shopper $($shopper$\_$id$)$ on delete cascade

$)$;

create table orders $($

order$\_$id serial,

status varchar$(50),$

total$\_$price decimal$(10,2),$

placed$\_$by$\_$shopper$\_$id int not null,

date$\_$placed timestamptz,

primary key $($order$\_$id$),$

foreign key $($placed$\_$by$\_$shopper$\_$id$)$ references shopper $($shopper$\_$id$)$ on delete cascade

$)$;

create table order$\_$detail $($

order$\_$id int not null,

guinea$\_$pig$\_$id int not null,

primary key $($order$\_$id$,$ guinea$\_$pig$\_$id$),$

foreign key $($order$\_$id$)$ references orders $($order$\_$id$)$ on delete cascade,

foreign key $($guinea$\_$pig$\_$id$)$ references guinea$\_$pig $($guinea$\_$pig$\_$id$)$

$)$;

Please show code in java, and show complete code for all classes involved. Like Shopper, Order, and Guinea Pig and these should all relate to each other, please.