- Version
- Download 1306
- File Size 3.09 MB
- Create Date March 12, 2018
- Download
TOR (Transcript of Records) – COG (Certification of Grades)
Database Schema
tblStudentInfo (id, studid, fname, lname, mname, address, gender, contact, courseid, yearlevel, semesterid)
tblCourse (id, coursecode, description)
tblSemester (id, semester, schoolyear)
tblYearLevel (id, yearlevel, description)
tblSubject (id, subjectcode, subjectname, yearlevel, semesterid, units)
tblStudentSubject (id, studid, semesterid, subjectid)
tblFinalGrade (id, studid, studentsubjectid, finalgrade, units, remarks, daterecorded)
tblRegistrarAccount (id, registrarname, username, password)
Functionalities
Admin
- Manage Registrar Accounts
- Backup/Restore Database
Registrar
- Manage Semester
- Manage Year Level
- Manage Course
- Manage Subjects
- Manage Student Info
- Manage Student Subject
- Print TOR
- Print Certification of Grades
Development Tools:
Visual Basic.Net
MySQL
DevExpress
Note: please install the mysql connector
link: https://blogs.oracle.com/mysql/mysql-connectornet-667-has-been-released