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:

• Student Record Keeping System
• Tables
• Primary Keys
• Foreign Keys
• Values
• Views

Normalization: