Skip to content

README.md

Latest commit

 

History

History
93 lines (59 loc) · 2.69 KB

README.md

File metadata and controls

93 lines (59 loc) · 2.69 KB

🗃️ Database Workshop – PostgreSQL

Welcome to this hands-on Database Workshop Assignment!
This exercise will help you understand how to connect to a PostgreSQL database and perform the basic CRUD operations (Create, Read, Update, Delete) through a simple Java project.

You'll be working with two tables: Clubs and Players.

📁 Project Structure

.
├── DatabaseManager.java       # Handles PostgreSQL connection and query execution
├── models/
│   ├── player.java       # Player model and related DB operations
│   └── club.java         # Club model and related DB operations
└── main.java             # Entry point to execute all database tasks

🧩 Your Task – Step-by-Step

✅ Step 1: Create Tables

Use the provided model files or your own SQL commands to create two tables:

  • clubs with fields like id, title, manager
  • players with fields like id, fullName, clubId (foreign key)

➕ Step 2: Insert Clubs

Insert the following two clubs into the clubs table:

Name Manager
Real Madrid Ancelotti
Liverpool Slot

👥 Step 3: Insert Players

Add the following four players to the players table all at once (i.e., in a single insert statement):

Name Club
Jude Bellingham Real Madrid
Valverde Real Madrid
Alexander-Arnold Liverpool
Courtois Real Madrid

🔍 Step 4: Select and View Data

Use SELECT statements to print the current data from both clubs and players tables to verify your inserts.

🔁 Step 5: Update Records

  • Update Alexander-Arnold's team from Liverpool to Real Madrid
  • Update Real Madrid's manager from Ancelotti to Alonso

🔍 Step 6: Select Again

View the data again to confirm your updates have taken effect.

❌ Step 7: Delete Data

  • Delete Jude Bellingham from the players table
  • Delete Liverpool from the clubs table (ensure foreign key constraints are handled)

🔍 Step 8: Final Select

Perform one last SELECT on both tables to view the final state of your database.

🛠️ Requirements

  • Java JDK
  • PostgreSQL
  • JDBC Driver

🧠 Tips

  • Wrap database operations in try-except blocks for error handling
  • Always close your DB connection!

🎯 Goal

By the end of this assignment, you should be confident in:

  • Structuring code to interact with a database
  • Performing all core SQL operations from Java
  • Understanding table relationships and foreign keys

💬 Questions?

Feel free to open an issue or ask during the workshop!

Happy Coding! 🚀