DEV Community

Cover image for College Management System
Kausi Tarun
Kausi Tarun

Posted on • Edited on

College Management System

Introduction
A college management system uses a database management system as its core to store,manage,and retrieve vast amounts of information,such as studentand staff details,academic records,admissions,fees,and attendance,etc.it demonstrates key database concepts such as queries and conclusion of the college management system.

1.Primary Keys

StudentID in Students

CourseID in Courses

EnrollID in Enrollments

2.Unique constraints

Email in Students is unique.

3.Foreign keys

StudentID in Enrollments references Students(StudentID)

CourseID in Enrollments references Courses(CourseID)

4.Data types

DOB as DATE

Credits restricted to 2 digits (NUMBER(2))

1.Composite key in Enrollments
CREATE TABLE Enrollments (
StudentID NUMBER REFERENCES Students(StudentID),
CourseID NUMBER REFERENCES Courses(CourseID),
Grade CHAR(2),
PRIMARY KEY (StudentID, CourseID)
);
2.Cascade Delete/Update
StudentID NUMBER REFERENCES Students(StudentID) ON DELETE CASCADE,
CourseID NUMBER REFERENCES Courses(CourseID) ON DELETE CASCADE
3.Check constraints
Credits NUMBER(2) CHECK (Credits > 0),
Grade CHAR(2) CHECK (Grade IN ('A+', 'A', 'B+', 'B', 'C', 'D', 'F'))

Conclusion
1.DBMSs are fundamental for various applications, from simple data storage to complex data analysis and decision-making processes.
2.They serve as the backbone for many technologies, including data science, data modeling, and machine learning.
3.Large organizations like Google and Amazon rely heavily on DBMSs to manage their vast data stores.

Top comments (0)