Back to Projectsط§ظ„ط¹ظˆط¯ط© ط¥ظ„ظ‰ ط§ظ„ظ…ط´ط§ط±ظٹط¹

MySchool Database

A school database system for academic records, enrollments, and administration workflows.ظ†ط¸ط§ظ… ظ‚ط§ط¹ط¯ط© ط¨ظٹط§ظ†ط§طھ ظ…ط¯ط±ط³ظٹط© ظ„ظ„ط³ط¬ظ„ط§طھ ط§ظ„ط£ظƒط§ط¯ظٹظ…ظٹط© ظˆط§ظ„طھط³ط¬ظٹظ„ ظˆط³ظٹط± ط§ظ„ط¹ظ…ظ„ ط§ظ„ط¥ط¯ط§ط±ظٹ.

Project Overviewظ†ط¸ط±ط© ط¹ط§ظ…ط© ط¹ظ„ظ‰ ط§ظ„ظ…ط´ط±ظˆط¹

MySchool Database models core school entities and their relationships for clearer academic data management.ظٹظ†ظ…ط°ط¬ MySchool Database ظƒظٹط§ظ†ط§طھ ط§ظ„ظ…ط¯ط±ط³ط© ط§ظ„ط£ط³ط§ط³ظٹط© ظˆط¹ظ„ط§ظ‚ط§طھظ‡ط§ ظ„ط¥ط¯ط§ط±ط© ط§ظ„ط¨ظٹط§ظ†ط§طھ ط§ظ„ط£ظƒط§ط¯ظٹظ…ظٹط© ط¨ظˆط¶ظˆط ط£ظƒط¨ط±.

Problem Statementط¨ظٹط§ظ† ط§ظ„ظ…ط´ظƒظ„ط©

Manual school records can create duplicated data, unclear enrollment history, and inconsistent administration workflows.ظ‚ط¯ طھط¤ط¯ظٹ ط§ظ„ط³ط¬ظ„ط§طھ ط§ظ„ظ…ط¯ط±ط³ظٹط© ط§ظ„ظٹط¯ظˆظٹط© ط¥ظ„ظ‰ طھظƒط±ط§ط± ط§ظ„ط¨ظٹط§ظ†ط§طھ ظˆط؛ظ…ظˆط¶ طھط§ط±ظٹط® ط§ظ„طھط³ط¬ظٹظ„ ظˆط¹ط¯ظ… ط§طھط³ط§ظ‚ ط§ظ„ط¥ط¬ط±ط§ط،ط§طھ ط§ظ„ط¥ط¯ط§ط±ظٹط©.

Why It Was Builtظ„ظ…ط§ط°ط§ ط¨ظڈظ†ظٹ ط§ظ„ظ…ط´ط±ظˆط¹

It was built to practice relational modeling and create a structured foundation for school management features.ط¨ظڈظ†ظٹ ظ„ظ„طھط¯ط±ط¨ ط¹ظ„ظ‰ ط§ظ„ظ†ظ…ط°ط¬ط© ط§ظ„ط¹ظ„ط§ط¦ظ‚ظٹط© ظˆط¥ظ†ط´ط§ط، ط£ط³ط§ط³ ظ…ظ†ط¸ظ… ظ„ظ…ط²ط§ظٹط§ ط¥ط¯ط§ط±ط© ط§ظ„ظ…ط¯ط±ط³ط©.

Development Processط¹ظ…ظ„ظٹط© ط§ظ„طھط·ظˆظٹط±

Requirements were mapped into entities, relationships, constraints, normalization decisions, and SQL implementation checks.طظڈظˆظ„طھ ط§ظ„ظ…طھط·ظ„ط¨ط§طھ ط¥ظ„ظ‰ ظƒظٹط§ظ†ط§طھ ظˆط¹ظ„ط§ظ‚ط§طھ ظˆظ‚ظٹظˆط¯ ظˆظ‚ط±ط§ط±ط§طھ طھط·ط¨ظٹط¹ ظˆظپطظˆطµط§طھ طھظ†ظپظٹط° SQL.

Tools and Technologiesط§ظ„ط£ط¯ظˆط§طھ ظˆط§ظ„طھظ‚ظ†ظٹط§طھ

ERD, SQL, relational schema design, normalization, constraints, query planning.

UML Diagrams / Architectureظ…ط®ط·ط·ط§طھ UML / ط§ظ„ط¨ظ†ظٹط©

The architecture centers on Student, Teacher, Course, Enrollment, Department, and Administration entities connected through relational constraints.طھطھظ…طظˆط± ط§ظ„ط¨ظ†ظٹط© طظˆظ„ ظƒظٹط§ظ†ط§طھ Student ظˆTeacher ظˆCourse ظˆEnrollment ظˆDepartment ظˆAdministration ط§ظ„ظ…ط±طھط¨ط·ط© ط¨ظ‚ظٹظˆط¯ ط¹ظ„ط§ط¦ظ‚ظٹط©.

High-Fidelity Interactive Prototypeالنموذج التفاعلي عالي الدقة

Students

428

records synced

Teachers

active accounts

Courses

open this term

Enrollments

1,284

join records

Database Activity

Inserted new student and linked USERS accountCOMMIT

Updated GPA for transcript reviewUPDATE

Teacher-course assignment verifiedJOIN

System Layers

Front-end, Java back-end, JDBC, and MySQL database.

Integrity checks and role permissions active.

ID	Student	Email	GPA	Parent
222410329	Waad Alhwaimel	waad@student.edu	3.91	5001
222511251	Deema Alotaibi	deema@student.edu	3.74	5002
222511239	Aljawharah Almutairi	aljawharah@student.edu	3.68	5003

Student Form

Student ID222511404NameNorah AlsheGPA3.82

ID	Teacher	Email	Phone	Courses
T-101	Maram Alajlan	maram@school.edu	055-014-2210	Database Systems
T-118	Maha Nasser	maha@school.edu	055-442-7801	Web Apps
T-124	Noura Saleh	noura@school.edu	055-991-8044	Data Modeling

Teacher Permissions

Teachers can view assigned courses and student counts without accessing admin-only CRUD actions.

Assigned coursesVIEW

Student rostersREAD

Course ID	Name	Teacher ID	Admin ID	Status
CS340	Introduction to Database Systems	T-101	A-01	Open
CS223	Programming II	T-118	A-01	Open
CS404	Data Structures	T-124	A-02	Review

Parent #	Name	Relationship	Linked Student
5001	Huda Ibrahim	Mother	222410329
5002	Faleh Alotaibi	Father	222511251
5003	Sultan Almutairi	Father	222511239

Parent View

Parent role can view linked student basics, GPA, and enrolled courses only.

Enrollment ID	Student	Course	Term	Grade
E-9001	222410329	CS340	2026-S2	A
E-9002	222511251	CS223	2026-S2	B+
E-9003	222511239	CS404	2026-S2	A-

Enroll Student

Student ID222511404Course IDCS340Term2026-S2

Transcript Summary

Waad Alhwaimel - GPA3.91

Deema Alotaibi - GPA3.74

Aljawharah Almutairi - GPA3.68

Course	Credits	Grade
CS340	3	A
CS223	4	A-
CS404	3	B+

Admin CRUD Queue

Insert Student + linked USERS accountTransaction

Update teacher course assignmentSafe Update

Delete orphan enrollment recordConstraint Check

SQL Query Console

SELECT s.ID, s.Fname, c.Name FROM STUDENT s JOIN ENROLLMENT e ON s.ID = e.Student_ID JOIN COURSE c ON e.Course_ID = c.ID;

Project Resourcesروابط المشروع

Documentationالتوثيق GitHubGitHub

Strong schemas depend on clear requirements, consistent naming, and relationship rules that match real workflows.طھط¹طھظ…ط¯ ط§ظ„ظ…ط®ط·ط·ط§طھ ط§ظ„ظ‚ظˆظٹط© ط¹ظ„ظ‰ ظ…طھط·ظ„ط¨ط§طھ ظˆط§ط¶طط© ظˆطھط³ظ…ظٹط© ظ…طھط³ظ‚ط© ظˆظ‚ظˆط§ط¹ط¯ ط¹ظ„ط§ظ‚ط§طھ طھط·ط§ط¨ظ‚ ط³ظٹط± ط§ظ„ط¹ظ…ظ„ ط§ظ„طظ‚ظٹظ‚ظٹ.