🎓 Student Performance Tracker

An end-to-end SQL + PL/SQL project designed to simulate a real academic grading system. This project automates the evaluation and reporting process for students — including schema design, data entry, procedures, triggers, and analytics.

📘 Project Overview

The system maintains student, subject, marks, and result information. It calculates grades automatically using stored procedures and generates reports through database views.

🧩 Project Workflow

ER Diagram – Defines entities and relationships

Schema Creation – Creates all master and transaction tables

Sample Data Insertion – Populates tables with test data

Procedures – Automates result calculation

Views & Reports – Generates performance summaries and insights

Triggers – Ensures data integrity and logs key updates

📁 Folder Structure

Student-Performance-Tracker/ │ ├── database/ │ ├── 01_ER_Diagram.png │ ├── 02_schema.sql │ ├── 03_data.sql │ ├── 04_procedures.sql │ ├── 05_views_reports.sql │ ├── 06_triggers.sql │ ├── Screenshots/ │ ├── result_table_output.png │ ├── class_summary_output.png │ ├── top_scorers_output.png │ └── README.md

🧠 Key Features

Automatic grade calculation

Data consistency through triggers

Summary and performance reports using SQL views

Modular structure for easy understanding and execution

📸 Screenshots

ER Diagram

📊 Output Samples

Result Table Class Summary Top Scorers

⚙️ Tools and Technologies

Oracle SQL / PL-SQL

SQL Developer / VS Code

Database Views and Triggers

Stored Procedures and Constraints

🎯 Learning Outcome

Through this project, I understood how to:

Design normalized database structures.

Apply PL/SQL for data automation and logic.

Use triggers and views to ensure consistency and reporting.

Integrate multiple database operations into one working system.

⚙️ How to Run

Open SQL Developer or any Oracle-compatible environment.

Run the scripts in this order:

02_schema.sql
03_data.sql
04_procedures.sql
05_views_reports.sql
06_triggers.sql

👩‍💻 Author

J. Anitha LinkedIn Profile