Core Java project

Tables Login, User and Leaves created in local DB
•Able to write CRUD operations using SQL add/edit/delete leaves
•Able to use foreign keys and constraints
•Able to connect to local DB using JDBC connection in Java
• Able to use classes, objects and OOPS concepts to connect to DB
1. User, Login and Leave tables created
2. All tables should have constraints as shown below
3. Login should have foreign key of user
4. Leave should have foreign key of user table
5. A java project is created in eclipse/intellij
6. Java Connection of DB should be static and a single instance for whole application( Db connection code i have)
7. Java - A Separate class for DB connection and a method which returns DB connection object
8. Java-1 select query for User table- to select and display all users using java main method should be implemented.
User Table
Userid primary key
Name not null
Address
DOB not null

Login
Id-primary key
Username not null
Password not null
User Id Foreign key reference to user table

Leave
Id-primary key not null
Name of user - not null
From - not null
To - not null
Reason can be null
Type of leave not null
User id foreign key not null