Welcome to the University Data Management System repository! This project showcases a comprehensive approach to managing university data efficiently and seamlessly. Dive into our journey through innovative database design, SQL implementation, automation, Java integration, and insightful reporting.
-
Relational Database Schema Design: Establish a solid foundation with well-defined tables for students, courses, departments, and grades. Normalization ensures robust data integrity and scalability.
-
SQL Implementation: Translate conceptual schemas into reality with SQL scripts for schema creation, data population, and rigorous testing.
-
PL/SQL Mastery: Harness the power of PL/SQL procedures for updates, GPA calculation, and seamless database integration.
-
Automation Excellence: Boost efficiency with Bash scripts for backups, disk monitoring, and scheduled tasks for daily execution.
-
Java Integration: Develop Java classes and a Database Manager to execute CRUD operations and integrate the Java application with the SQL database.
-
Insightful Reporting: Generate insightful reports in Java, displaying courses, enrolled students, and average GPA per course, fostering seamless integration between application and database.
To get started with our University Data Management System:
- Clone this repository to your local machine.
- Follow the setup instructions in the
installation.mdfile. - Explore the codebase and documentation to understand the project structure and implementation details.
- Run the provided scripts to set up the database and execute sample operations.
This project is licensed under the MIT License.