COMSATS UNIVERSITY
ISLAMABAD
Abbottabad campus
TOPIC
UNIVERSITY COURSE REGISTRATION SYSTEM
Semester Project Report
Submitted To: Submitted By:
Instructor Rabbia Qazi Salar Ahmad : sp25-bse-153
Department of Software Engineering
Ahmed Ali : sp25-bse-130
Abdul Ahad : sp24-bse-092
Section : A
Assigement : Database System
INTRODUCTION
The University Course Registration System is developed to efficiently manage the
academic and administrative activities of a university. The system provides a
computerized environment where students, teachers, and departments can interact
through a centralized database system. The system allows students to register in courses,
teachers to manage courses, and departments to organize academic records. The database
system helps in storing, managing, and retrieving information efficiently.
The proposed system reduces manual paperwork and improves the accuracy, reliability,
and efficiency of course registration, attendance management, and result processing. It
also ensures better organization and faster access to university records.
PROJECT SCENARIO
A university wants to computerize its course registration process. In the current manual
system, students face problems during course enrollment, teachers maintain records
manually, and departments experience difficulty managing student and course
information.
To solve these issues, the university plans to develop a University Course Registration
System. In this system, students can register for courses online, teachers can manage
course details, and departments can maintain academic records efficiently.
Each student belongs to a department and can enroll in multiple courses during a
semester. Each course is taught by a teacher, and teachers are assigned by departments.
Attendance and result records are also maintained in the system.
The database system will improve data organization, reduce paperwork, and make
information easily accessible.
OBJECTIVES OF THE SYSTEM
To maintain student records.
To manage course registration.
To store teacher information.
To manage departments and courses.
To maintain attendance records.
To store examination results.
To reduce manual paperwork.
To improve efficiency and accuracy.
IDENTIFICATION OF ENTITIES
The following entities are identified for the University Course Registration System
Student
Teacher
Department
Course
Registration
Attendance
Result
Semester
ATTRIBUTES OF EACH ENTITY
1. STUDENT
Attribute Name Description
Student-ID Unique ID of student
Student-Name Name of student
Gender Gender of student
Date-of-Birth Date of birth
Email Student email
Phone-Number Contact number
Address Home address
Department-ID Department of student
2. TEACHER
Attribute Name Description
Teacher-ID Unique ID of teacher
Teacher-Name Name of teacher
Qualification Teacher qualification
Email Teacher email
Phone-Number Contact number
Department-ID Department of teacher
3. DEPARTMENT
Attribute Name Description
Department-ID Unique department ID
Department-Name Name of department
Office-Location Department office
HOD-Name Head of department
4. COURSE
Attribute Name Description
Course-ID (PK) Unique course ID
Course-Name Name of course
Credit-Hours Total credit hours
Teacher-ID (FK) Assigned teacher
Department-ID (FK) Department offering course
5. REGISTRATION
Attribute Name Description
Registration-ID (PK) Unique registration ID
Student-ID (FK) Registered student
Course-ID (FK) Registered course
Semester-ID (FK) Semester information
Registration-Date Date of registration
6. ATTENDANCE
Attribute Name Description
Attendance-ID Unique attendance ID
Student-ID Student record
Course-ID Course record
Attendance-Percentage Attendance percentage
7. RESULT
Attribute Name Description
Result-ID Unique result ID
Student-ID Student information
Course-ID Course information
Total-Marks Total marks
Obtained-Marks Obtained marks
Grade Student grade
8. SEMESTER
Attribute Name Description
Semester-ID Unique semester ID
Semester-Name Semester title
Start-Date Semester start date
End-Date Semester ending date
6. Relationships Between Entities
I. Department and Student
One department can have many students, but one student belongs to only one department.
Relationship: Department (1) ----- (M) Student
II. Department and Teacher
One department can have many teachers, but one teacher belongs to only one department.
Relationship: Department (1) ----- (M) Teacher
III. Department and Course
One department can offer many courses, but one course belongs to only one department.
Relationship: Department (1) ----- (M) Course
IV. Teacher and Course
One teacher can teach many courses, but one course is assigned to one teacher.
Relationship: Teacher (1) ----- (M) Course
V. Student and Course
A student can register in many courses, and one course can have many students. This is a
many-to-many relationship that is resolved using the Registration entity.
Relationship: Student (M) ----- (M) Course
Resolved Through: Registration Entity
VI. Student and Attendance
One student can have many attendance records.
Relationship: Student (1) ----- (M) Attendance
VII. Student and Result
One student can have many result records.
Relationship: Student (1) ----- (M) Result
VIII. Semester and Registration
One semester can contain many registrations.
Relationship: Semester (1) ----- (M) Registration
7. Cardinality and Multiplicity Constraints
Relationship Cardinality
Department to Student One-to-Many
Department to Teacher One-to-Many
Department to Course One-to-Many
Teacher to Course One-to-Many
Student to Course Many-to-Many
Student to Attendance One-to-Many
Student to Result One-to-Many
Semester to Registration One-to-Many
8. ERD Explanation
The ERD of the University Course Registration System represents all entities, their
attributes, and relationships.
Primary keys uniquely identify each record in the database, while foreign keys create
relationships between entities.
The Registration entity is used to resolve the many-to-many relationship between Student
and Course.
Attendance and Result entities help maintain academic performance records.
The Semester entity stores semester-related information for course registrations.
ERD DIAGRAM
9. Functional Requirements
Student Module
Student can register in courses.
Student can view enrolled courses.
Student can check attendance.
Student can view results.
Student information can be updated.
Teacher Module
Teacher can manage courses.
Teacher can upload attendance.
Teacher can upload results.
Teacher can view registered students.
Teacher details can be managed.
Department Module
Department can manage courses.
Department can assign teachers.
Department can maintain student records.
Department can maintain semester information.
Department can generate reports.
10. Non-Functional Requirements
The system should be user-friendly.
The system should provide data security.
The system should be reliable.
The system should maintain data accuracy.
The system should support fast data retrieval.
11. Conclusion
The University Course Registration System provides an efficient solution for managing
university academic activities. The database design helps in organizing student, teacher,
course, and registration information systematically.
The ERD clearly represents the relationships among entities and ensures proper data
management using primary and foreign keys. The system minimizes manual work,
improves accuracy, and increases efficiency in university operations.
Main Relationships:
Department manages Students
Department manages Teachers
Department offers Courses
Teacher teaches Courses
Student registers Courses
Student has Attendance
Student receives Results
Semester contains Registrations
:: THANK YOU ::