# parthkprogrammer/dbms-mini_project architecture

> Architecture diagram of the GitHub repository parthkprogrammer/dbms-mini_project, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-05). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/parthkprogrammer/dbms-mini_project
- Repository: https://github.com/parthkprogrammer/dbms-mini_project

## Overview

This is a JavaFX student-management desktop app for role-aware login and managing courses, enrollments, student records, and grades. The main user flow is through the dashboard: users sign in or register, then use role-sensitive views to browse courses and grades; staff can assign grades. Controllers delegate business work to services and, in some dashboard operations, directly to DAO implementations. Services and DAOs handle persistence through JDBC to MySQL. The README documents the broader MVC/DAO intent; some dashboard and UI wiring is only partially excerpted, so uncertain links are omitted.

Main entry points: [`src/main/java/com/sms/dao/impl`](https://github.com/parthkprogrammer/dbms-mini_project/tree/main/src/main/java/com/sms/dao/impl) (JDBC DAO Implementations), [`src/main/java/com/sms/service/AuthService.java`](https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/service/AuthService.java) (Authentication), [`src/main/java/com/sms/controller/DashboardController.java`](https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/controller/DashboardController.java) (Dashboard Controller), [`src/main/java/com/sms/Main.java`](https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/Main.java) (JavaFX Launcher)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ui["Desktop UI"]
  node_main["JavaFX Launcher<br/>[Main.java]"]
  node_loginview["Login View<br/>[Login.fxml]"]
  node_signupview["Signup View<br/>[Signup.fxml]"]
  node_dashboardview["Dashboard View<br/>[Dashboard.fxml]"]
  node_login["Login Controller"]
  node_signup["Signup Controller"]
  node_dashboard["Dashboard Controller"]
end

subgraph group_business["Application Services"]
  node_auth["Authentication<br/>[AuthService.java]"]
  node_courses["Course &amp; Enrollment<br/>[CourseService.java]"]
  node_grades["Grade Management<br/>[GradeService.java]"]
  node_students["Student Management"]
  node_password["Password Utilities<br/>[PasswordUtil.java]"]
end

subgraph group_persistence["Data Access"]
  node_daoapi["DAO Contracts"]
  node_daoimpl["JDBC DAO Implementations"]
  node_dbconnection["JDBC Connection<br/>[DBConnection.java]"]
end

subgraph group_domain["Domain Data"]
  node_models["Domain Models"]
end

node_user(("User"))
node_mysql[("MySQL Database")]

node_user -->|"opens app"| node_main
node_main -->|"loads"| node_loginview
node_login -->|"switches view"| node_main
node_signup -->|"switches view"| node_main
node_login -->|"authenticates"| node_auth
node_signup -->|"registers"| node_auth
node_auth -->|"persists users"| node_daoimpl
node_auth -->|"hashes passwords"| node_password
node_dashboard -->|"requests courses"| node_courses
node_dashboard -->|"assigns grades"| node_grades
node_dashboard -->|"queries records"| node_daoimpl
node_courses -->|"reads and writes"| node_daoimpl
node_grades -->|"manages grades"| node_daoimpl
node_students -->|"manages students"| node_daoimpl
node_daoimpl -->|"implements"| node_daoapi
node_daoimpl -->|"opens connections"| node_dbconnection
node_dbconnection -->|"connects via JDBC"| node_mysql
node_dashboard -->|"displays records"| node_models
node_auth -->|"uses roles and users"| node_models

click node_main "https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/Main.java"
click node_loginview "https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/resources/fxml/Login.fxml"
click node_signupview "https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/resources/fxml/Signup.fxml"
click node_dashboardview "https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/resources/fxml/Dashboard.fxml"
click node_login "https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/controller/LoginController.java"
click node_signup "https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/controller/SignupController.java"
click node_dashboard "https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/controller/DashboardController.java"
click node_auth "https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/service/AuthService.java"
click node_courses "https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/service/CourseService.java"
click node_grades "https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/service/GradeService.java"
click node_students "https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/service/StudentService.java"
click node_daoapi "https://github.com/parthkprogrammer/dbms-mini_project/tree/main/src/main/java/com/sms/dao"
click node_daoimpl "https://github.com/parthkprogrammer/dbms-mini_project/tree/main/src/main/java/com/sms/dao/impl"
click node_dbconnection "https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/util/DBConnection.java"
click node_models "https://github.com/parthkprogrammer/dbms-mini_project/tree/main/src/main/java/com/sms/model"
click node_password "https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/util/PasswordUtil.java"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_main,node_loginview,node_signupview,node_dashboardview,node_login,node_signup,node_dashboard,node_user toneBlue
class node_auth,node_courses,node_grades,node_students,node_password,node_mysql toneAmber
class node_daoapi,node_daoimpl,node_dbconnection toneMint
class node_models toneRose
```

## Components

### Desktop UI

- [JavaFX Launcher](https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/Main.java): `src/main/java/com/sms/Main.java`
- [Login View](https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/resources/fxml/Login.fxml): `src/main/resources/fxml/Login.fxml`
- [Signup View](https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/resources/fxml/Signup.fxml): `src/main/resources/fxml/Signup.fxml`
- [Dashboard View](https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/resources/fxml/Dashboard.fxml): `src/main/resources/fxml/Dashboard.fxml`
- [Login Controller](https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/controller/LoginController.java): `src/main/java/com/sms/controller/LoginController.java`
- [Signup Controller](https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/controller/SignupController.java): `src/main/java/com/sms/controller/SignupController.java`
- [Dashboard Controller](https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/controller/DashboardController.java): `src/main/java/com/sms/controller/DashboardController.java`

### Application Services

- [Authentication](https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/service/AuthService.java): `src/main/java/com/sms/service/AuthService.java`
- [Course & Enrollment](https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/service/CourseService.java): `src/main/java/com/sms/service/CourseService.java`
- [Grade Management](https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/service/GradeService.java): `src/main/java/com/sms/service/GradeService.java`
- [Student Management](https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/service/StudentService.java): `src/main/java/com/sms/service/StudentService.java`
- [Password Utilities](https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/util/PasswordUtil.java): `src/main/java/com/sms/util/PasswordUtil.java`

### Data Access

- [DAO Contracts](https://github.com/parthkprogrammer/dbms-mini_project/tree/main/src/main/java/com/sms/dao): `src/main/java/com/sms/dao`
- [JDBC DAO Implementations](https://github.com/parthkprogrammer/dbms-mini_project/tree/main/src/main/java/com/sms/dao/impl): `src/main/java/com/sms/dao/impl`
- [JDBC Connection](https://github.com/parthkprogrammer/dbms-mini_project/blob/main/src/main/java/com/sms/util/DBConnection.java): `src/main/java/com/sms/util/DBConnection.java`

### Domain Data

- [Domain Models](https://github.com/parthkprogrammer/dbms-mini_project/tree/main/src/main/java/com/sms/model): `src/main/java/com/sms/model`

### Other components

- **User**
- **MySQL Database**

## Connections

- User → JavaFX Launcher: opens app (evidence: `README.md`)
- JavaFX Launcher → Login View: loads (evidence: `src/main/java/com/sms/Main.java`)
- Login Controller → JavaFX Launcher: switches view (evidence: `src/main/java/com/sms/controller/LoginController.java`)
- Signup Controller → JavaFX Launcher: switches view (evidence: `src/main/java/com/sms/controller/SignupController.java`)
- Login Controller → Authentication: authenticates (evidence: `src/main/java/com/sms/controller/LoginController.java`)
- Signup Controller → Authentication: registers (evidence: `src/main/java/com/sms/controller/SignupController.java`)
- Authentication → JDBC DAO Implementations: persists users (evidence: `src/main/java/com/sms/service/AuthService.java`)
- Authentication → Password Utilities: hashes passwords (evidence: `src/main/java/com/sms/service/AuthService.java`)
- Dashboard Controller → Course & Enrollment: requests courses (evidence: `src/main/java/com/sms/controller/DashboardController.java`)
- Dashboard Controller → Grade Management: assigns grades (evidence: `src/main/java/com/sms/controller/DashboardController.java`)
- Dashboard Controller → JDBC DAO Implementations: queries records (evidence: `src/main/java/com/sms/controller/DashboardController.java`)
- Course & Enrollment → JDBC DAO Implementations: reads and writes (evidence: `src/main/java/com/sms/service/CourseService.java`)
- Grade Management → JDBC DAO Implementations: manages grades (evidence: `src/main/java/com/sms/service/GradeService.java`)
- Student Management → JDBC DAO Implementations: manages students (evidence: `src/main/java/com/sms/service/StudentService.java`)
- JDBC DAO Implementations → DAO Contracts: implements (evidence: `src/main/java/com/sms/dao/impl/CourseDAOImpl.java`)
- JDBC DAO Implementations → JDBC Connection: opens connections (evidence: `src/main/java/com/sms/dao/impl/CourseDAOImpl.java`)
- JDBC Connection → MySQL Database: connects via JDBC (evidence: `src/main/java/com/sms/util/DBConnection.java`)
- Dashboard Controller → Domain Models: displays records (evidence: `src/main/java/com/sms/controller/DashboardController.java`)
- Authentication → Domain Models: uses roles and users (evidence: `src/main/java/com/sms/service/AuthService.java`)
