Skip to content

Latest commit

 

History

History
14 lines (9 loc) · 1.32 KB

README.md

File metadata and controls

14 lines (9 loc) · 1.32 KB

Degree-Issuance-System

A system where a student can submit an application to receive his or her degree. The application is passed through a few checks and permissions, granted by the other departments.

Relationship Mapping

student-> fyp -> finance ->onestop -> director

That is the path the form will take inside the database. The student submits the form, which is then passed on to the fyp center. Here it is either accepted or rejected and in the case of acceptance, is passed on to the finance department. There, the student’s pending dues are checked, and according to that, another permission is granted. The onestop center generates a transcript for the student that contains their grades from over the course of the degree. Onestop processes the request and forwards it to the director, who gives it the final seal of approval. The director then updates the status of the request, which can go from “pending” to “accepted” or “rejected”. This information is displayed onto the student’s view of the database as well.

Relational Database Schema

relational schema drawio

ERD Diagram

project erd drawio