This project is for schools administration to stop using EXCEL and start using sql for reporting. Unlike Excel, SQL can handle well over one million fields of data with ease. SQL queries are also more flexible and powerful than Excel formulas.
- Data used for students table: students_data
- Data used for teachers table: teachers_data
- Data used for marks table: marks_data
- Data used for fee_section table: fee_section
IN ORDER TO CREATE TABLES USE THIS FILE tables
teacher
- this table contains information regarding teacher including the Subject he/she teaches, his pay and etc.students
- this table contains information regarding students inlcuing name, age, grade and etc.marks
- this table contains the obtained marks by students for exams.fee_section
- this table contains information regarding fee invoices issued to students, including issue_date, paid_date, due_date and invoice_id.
IN ORDER TO CREATE TABLES USE THIS FILE tables
student_exams_results
- this stored procedure will report about the students exams he has appeared in and the marks he has scored. Here is the screenshot:after_due_invoices
- this view shows all the invoices that have not been paid with their fine calculated. Here is the screenshot:failed_students
- this view shows all the students who have failed or got a U grade. Here is the screenshot:
If you have any feedback, please reach out to me at jahanzaibzafar950@gmail.com