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)