The Monster University Management System is a comprehensive academic management platform designed to automate various processes and activities within a university environment.

This system was developed as a software engineering project focused on implementing academic processes, security mechanisms, business rules, and database management using Java and Microsoft SQL Server.

The platform supports multiple user roles and provides secure access to academic administration, reporting and auditing.

The application follows a layered architecture that promotes maintainability, scalability, and separation of concerns.

+------------------------------------------------+
|               Presentation Layer               |
|          Forms, Views and User Interface       |
+-------------------------+----------------------+
                          |
                          ▼
+------------------------------------------------+
|              Business Logic Layer              |
|      Validations, Rules and System Services    |
+-------------------------+----------------------+
                          |
                          ▼
+------------------------------------------------+
|                Data Access Layer               |
|         DAO Classes and SQL Operations         |
+-------------------------+----------------------+
                          |
                          ▼
+------------------------------------------------+
|              SQL Server Database               |
+------------------------------------------------+

• View available courses
• Enrollment process
• Check payment status
• Review academic information

• View assigned courses
• Access enrolled student lists
• Review teaching schedules

• Manage academic periods
• Generate academic reports

• Processes waitlists automatically
• Generates audit records
• Executes background validations

• Student management
• Academic programs (Careers)
• Courses (Subjects)
• Course prerequisites
• Academic periods

• Pre-enrollment process
• Course enrollment

• Prerequisite verification
• Enrollment period validation
• Payment status validation

Student Login
      │
      ▼
Course Selection
      │
      ▼
System Validation
      │
      ├── Prerequisites
      ├── Payment Status
      │
      ▼
Enrollment Decision
      │
      ├── Approved → Enrollment Confirmed
      └── Rejected → Validation Message

The system implements a centralized authentication and authorization model.

• Unique user identification
• Secure login process
• Role-based authorization
• User state management

• Automatic password generation
• Password reset functionality
• Forced password change on first login
• Forced password change after reset

• Minimum 8 characters
• Maximum 16 characters
• At least one special character
• Cannot match user identifier
• Prevents reuse of previous passwords

The system generates multiple academic and administrative reports.

• Student lists by course
• Student schedules
• Enrollment history

All critical operations are recorded for accountability and traceability.

• User creation
• Password reset operations
• Successful authentications
• Administrative actions

The system uses a relational database model implemented in Microsoft SQL Server.

• Referential integrity through foreign keys
• Data consistency constraints
• Normalized relational structure
• Efficient query processing

git clone https://github.com/Pa004/monster-university-java-sqlserver
cd monster-university-java-sqlserver

CREATE DATABASE MonsterUniversity;

Execute the SQL scripts provided with the project.

Update the database connection settings according to your SQL Server instance.

Example:

String url = "jdbc:sqlserver://localhost:1433;databaseName=MonsterUniversity";
String user = "sa";
String password = "your_password";

Open the project using NetBeans.

ant clean
ant build

Or use:

NetBeans → Clean and Build Project

NetBeans → Run Project

monster-university-java-sqlserver
│
├── src/                 Source code
├── test/                Unit tests
├── web/                 Web resources
├── libraries/           External libraries
├── nbproject/           NetBeans configuration
├── db/                  SQL scripts
├── build.xml            Apache Ant build script
├── .gitignore           Git exclusions
├── README.md            Project documentation
│
├── build/               Generated files (ignored)
└── dist/                Distribution files (ignored)

✔ User Management

✔ Authentication and Authorization

✔ Academic Program Management

✔ Enrollment Processing

✔ Prerequisite Validation

✔ Academic Reporting

✔ Modular Design

✔ Layered Architecture

✔ Database Persistence

✔ Secure Authentication

✔ Scalability-Oriented Structure

✔ Maintainable Codebase

This repository represents the Java + SQL Server implementation of the Monster University Management System.

Other available implementations include:

• C# + SQL Server
• Java + MongoDB
• C# + MongoDB

All versions share the same business rules and functional requirements while differing in programming language and database technology.

This project was developed for educational and academic purposes, demonstrating the implementation of:

• Database Management Systems
• Software Architecture
• Authentication and Authorization
• Academic Information Systems
• Object-Oriented Programming
• Business Rule Enforcement
• Software Engineering Principles

Monster University Management System
Java + SQL Server Implementation