Database Schema for Student Course Enrollment

This SQL snippet defines a schema for managing student enrollments in courses. It includes three tables: Students, Courses, and Enrollments, with appropriate primary and foreign keys to maintain relationships. This setup is essential for any academic information system.

-- Students Table
CREATE TABLE Students (
    StudentID INT PRIMARY KEY,
    StudentName VARCHAR(100) NOT NULL
);

-- Courses Table
CREATE TABLE Courses (
    CourseID VARCHAR(10) PRIMARY KEY,
    CourseName VARCHAR(100) NOT NULL,
    Instructor VARCHAR(100),
    Department VARCHAR(50),
    CreditHours INT
);

-- Enrollments Table
CREATE TABLE Enrollments (
    StudentID INT,
    CourseID VARCHAR(10),
    PRIMARY KEY (StudentID, CourseID),
    FOREIGN KEY (StudentID) REFERENCES Students(StudentID),
    FOREIGN KEY (CourseID) REFERENCES Courses(CourseID)
);

Editor is loading...