Instructions

Instructions

This project involves developing a Java application that interacts with the league information SQL database you used in week $3.$ The application will provide functionalities to manage records for teams, players, and coaches. Your team will use JDBC to establish database connections and perform CRUD $($Create$,$ Read, Update, Delete$)$ operations.

Objectives

Learn to connect Java applications to SQL databases using JDBC$.$

Implement CRUD operations within a Java application.

Enhance teamwork and collaborative coding skills.

Tools and Technologies

Java Development Kit $($JDK$)$

Integrated Development Environment $($IDE$)$ like Eclipse or IntelliJ IDEA

JDBC library for database connection

The sample Assignment Seed Data$1.$sql we used in week $3$

Database Setup

Use the provided SQL seed data to create the initial database schema and populate it with sample data.

Database should include tables for Teams, Players, and Coaches.

Ensure proper relationships and constraints are set between tables.

Functional Requirements

Team Management:

Add a Team: Users can add new team records to the database.

Edit a Team: Users can select an existing team to edit its details.

Delete a Team: Users can remove a team from the database.

Player Management:

Add a Player: Users can add new player records, associating them with teams.

Edit a Player: Users can update player details.

Delete a Player: Users can delete player records from the database.

Coach Management:

Add a Coach: Users can add coaches, specifying the team they coach.

Edit a Coach: Users can edit coach details.

Delete a Coach: Users can remove coach records.

View Records:

Users can view lists of teams, players, and coaches with details.

Project Deliverables

Source code of the Java application.

Documentation covering system design, setup instructions, and user guide.

Presentation slides for the final project demonstration.

Assessment Criteria

Functionality: All features should work as described.

Code Quality: Code should be clean, well$-$commented, and organized.

Collaboration: Effective use of version control and team collaboration tools.

Presentation: Clear and concise explanation of the project during the demonstration.

This project will allow you to apply Java programming skills in a real$-$world application, enhancing your understanding of database management and collaborative software development.