CREATE TABLE Student (
  StudentID INT PRIMARY KEY,
  StudentName VARCHAR(50) NOT NULL,
  Email VARCHAR(100) UNIQUE,
  Major VARCHAR(50) DEFAULT 'Computer Engineering'
);

INSERT INTO Student VALUES (101, 'Ahmed', 'ahmed@university.edu', 'Computer Engineering');
INSERT INTO Student VALUES (102, 'Khalid', 'khalid@university.edu', 'Electrical Engineering');
INSERT INTO Student VALUES (103, 'Mohammed', 'mohammed@university.edu', 'Computer Engineering');

SELECT * FROM Student;
SELECT ' ' AS ' ';

INSERT INTO
    Student (StudentID, StudentName, Email) VALUES (104, 'Abdullah', 'abdullah@university.edu');
SELECT * FROM Student;
SELECT ' ' AS ' ';

CREATE TABLE Course (
  CourseID INT PRIMARY KEY,
  CourseName VARCHAR(100) NOT NULL,
  CreditHours INT NOT NULL
);

INSERT INTO Course VALUES (201, 'Database Systems', 3);
INSERT INTO Course VALUES (202, 'Digital Logic Design', 3);
INSERT INTO Course VALUES (203, 'Microprocessors and Microcontrollers', 3);

SELECT * FROM Course;
SELECT ' ' AS ' ';

CREATE TABLE Enrollment (
  EnrollmentID INT PRIMARY KEY,
  StudentID INT NOT NULL,
  CourseID INT NOT NULL,
  FOREIGN KEY (StudentID) REFERENCES Student(StudentID),
  FOREIGN KEY (CourseID) REFERENCES Course(CourseID)
);

INSERT INTO Enrollment VALUES (1, 101, 201);
INSERT INTO Enrollment VALUES (2, 101, 202);
INSERT INTO Enrollment VALUES (3, 102, 201);
INSERT INTO Enrollment VALUES (4, 103, 201);
INSERT INTO Enrollment VALUES (5, 103, 203);

SELECT * FROM Enrollment;
SELECT ' ' AS ' ';

SELECT Student.StudentName, Course.CourseName
FROM Enrollment
JOIN Student ON Enrollment.StudentID = Student.StudentID
JOIN Course ON Enrollment.CourseID = Course.CourseID;
SELECT ' ' AS ' ';

CREATE TABLE Department (
  DepartmentID INT PRIMARY KEY,
  DepartmentName VARCHAR(100) NOT NULL,
  DepartmentCode VARCHAR(10) UNIQUE
);

INSERT INTO Department VALUES (1, 'Computer Engineering', 'CNE');
INSERT INTO Department VALUES (2, 'Electrical Engineering', 'EE');
INSERT INTO Department VALUES (3, 'Civil Engineering', 'CE');

SELECT * FROM Department;
SELECT ' ' AS ' ';

INSERT INTO Student (StudentID, StudentName, Email) VALUES (105, 'Faisal', 'faisal@university.edu');
INSERT INTO Enrollment VALUES (6, 105, 201);
INSERT INTO Enrollment VALUES (7, 105, 203);

SELECT * FROM Enrollment;
SELECT ' ' AS ' ';

SELECT Student.StudentName, Course.CourseName
FROM Enrollment
JOIN Student ON Enrollment.StudentID = Student.StudentID
JOIN Course ON Enrollment.CourseID = Course.CourseID;