need help with this

im new to java

and how to connect this mysql to java eclipse

Using the software installed for this course:

Create following in MySQL database, following table scripts will be part of assignment submission:

Create following tables called TransactionType , AccountType, Accounts and Transaction. All the id fields are primary keys

TransactionType ( String: TranTypeId, String : TransactionDesc) Values (A:Authorization,C:Credit,P:Payment)

AccountType( int : AcctTypeId, String : AccountTypeDesc ) Values (10:Single, 20:Joint, 30:Minor)

Accounts ( int : AccountId, int : AcctTypeId, int : Balance ) Values ( 100, 10, 3000), ( 200, 20, 1000), ( 300, 30, 5000), ( 400, 10, 3000)

Transaction ( int : TransId, String : TranTypeId, int : AcctIdFrom, int: AcctIdTo, int Amount ) Values (1, A , 100, 200, 100), (1, C , 300, 200, 1000), (1, A , 400, 200, 100)

Eclipse Java Project:

Create Java class files for each tables above to insert, delete and update operations

Validate TransactionType is validated before inserting into Transaction table

Validate AccountType is validated before inserting into Accounts table

Validate TranTypeId, AcctIdFrom and AcctIdTo validated before inserting into Transaction table