Now, let's execute the SQL scripts and configure the database connection in your Spring Boot application. Here's how to do it: 1. First, add the H2 database dependency to your `pom.xml`: ```xml com.h2database h2 runtime ``` 2. Add the Spring Boot Starter Data JPA dependency for database operations: ```xml org.springframework.boot spring-boot-starter-data-jpa ``` 3. Configure your `application.properties` file with the following settings: ```properties # Database configuration spring.datasource.url=jdbc:h2:file:./banking_db spring.datasource.driverClassName=org.h2.Driver spring.datasource.username=sa spring.datasource.password= # H2 Console configuration spring.h2.console.enabled=true spring.h2.console.path=/h2-console # SQL initialization configuration spring.sql.init.mode=ALWAYS spring.sql.init.schema-locations=classpath:sql/schema.sql spring.sql.init.data-locations=classpath:sql/data.sql ``` 4. After making these changes, when you run your Spring Boot application: - The database will be created at the specified location - The schema will be created based on `schema.sql` - Sample data will be inserted from `data.sql` To verify the database setup: 1. Start your Spring Boot application 2. Open H2 Console at `http://localhost:8080/h2-console` 3. Use the following JDBC URL: `jdbc:h2:file:./banking_db` 4. Execute a query like `SELECT * FROM accounts` or `SELECT * FROM transactions` to see the sample data This configuration will ensure your database is properly set up with the necessary schema and sample data for your banking application. Further Reading: - [Spring Boot with H2 Database](https://spring.io/guides/gs/relational-data-access/) - [H2 Database Configuration](https://h2database.com/html/features.html#feature_connection_settings) - [Database Initialization in Spring Boot](https://docs.spring.io/spring-boot/docs/current/reference/htmlsingle/#features.sql)