Home
Department of Digital Forensics and Cyber Security, LGU
Under the Guidance of: Imran Khalid & Saud Farooq
- Armoghan-Ul-Mohmin (Fa-21/BS DFCS/010)
- Aftab Hussain (Fa-21/BS DFCS/033)
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.
.png "Er Diagram(Dark)")
-
Admin
-
Student
-
Fee
-
Department
-
Course
-
Teacher
-
Exam
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 |
|-----------|------------|--------------|------------|
| | | | |
| | | | |
| | | | |