/Student-Record-Keeping-System

Student Record Keeping Software Backend Using Microsoft Sql.

Mozilla Public License 2.0MPL-2.0

Student Record Keeping Software

Department of Digital Forensics and Cyber Security, LGU

Under the Guidance of: Imran Khalid & Saud Farooq

Team Members:

  • Armoghan-Ul-Mohmin (Fa-21/BS DFCS/010)
  • Aftab Hussain (Fa-21/BS DFCS/033)

ABSTRACT:

This project is basically creating a database management system for Student Record Keeping Software. Aim of the project is to creating a backend program of the processes taking place using SQL. This model deals with the relationship between Students, Teachers, Departments, and Exams. The other entities play a supportive weak role. So basically this helps the Students , Teacchers and Uniersity to keep records.

Er Diagram:

Tables:

  1. Admin

  2. Student

  3. Fee

  4. Department

  5. Course

  6. Teacher

  7. Exam

Attributes:

Admin Table

 | Admin_Id | Student_Id   | Student_Name    | Student_Password  |
 | -------- | ------------ |--------------   |-------------------|
 |          |              |                 |                   |
 |          |              |                 |                   |
 |          |              |                 |                   |

Student Table

 |Student_Id | Student_Name | Address | Contact_No | Department_ID | Course_ID|
 |-----------|------------|---------|------------|---------------|----------|
 |           |            |         |            |               |          | 
 |           |            |         |            |               |          |
 |           |            |         |            |               |          |

Teacher Table

   | Teacher_ID | Teacher_Name | Student_Id |
   |------------|--------------|------------|
   |            |              |            |
   |            |              |            |
   |            |              |            |

Course Table

   | Course_ID | Course_Name | Teacher_ID | Student_Id |
   |-----------|-------------|------------|------------|
   |           |             |            |            |
   |           |             |            |            |
   |           |             |            |            |

Department Table

   | Department_ID | Department_Name | Course_ID  | Exam_ID   |
   |---------------|-----------------|------------|-----------|
   |               |                 |            |           |         
   |               |                 |            |           |

Exam Table

   | Exam_ID | Exam_Name | Course_ID | Student_Id | Marks |
   |---------|-----------|-----------|------------|-------|
   |         |           |           |            |       |
   |         |           |           |            |       |
   |         |           |           |            |       |

Fee Table

   |Challan_No | Student_Id | Student_Name | Tution_Fee |
   |-----------|------------|--------------|------------|
   |           |            |              |            |
   |           |            |              |            |
   |           |            |              |            |

Code: