Hogwarts Database Management Project

Overview

This project is a hands-on exercise in creating and managing database entities, building a RESTful web application using Spring Boot, and writing SQL queries. The theme of the project is inspired by the magical world of Hogwarts from the Harry Potter series. The main entities created for this project are Student and Faculty.

Features

• Entity Creation: Developed Student and Faculty entities to represent students and faculty members at Hogwarts.
• RESTful Web Application: Created a Spring Boot application to manage CRUD operations for these entities.
• SQL Queries: Wrote SQL queries to interact with the database, including queries for data retrieval, insertion, and updates.

Technologies Used

• Spring Boot
• Lombok
• PostgreSQL
• Liquibase
• Spring Data JPA

Prerequisites

• Java 17
• Maven or Gradle
• PostgreSQL