CREATE TABLE Registration ( 
    Registration_ID MEDIUMINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, 
    Student_ID SMALLINT UNSIGNED,
    Course_ID TINYINT UNSIGNED, 
    Status VARCHAR(15)CHECK(Status IN 'Enrolled','Completed', 'Dropped')) NOT NULL, 
    Registration_Date DATE NOT NULL CHECK(Registration_Date >= '2020-01-01'), 
    FOREIGN KEY(Student_ID) REFERENCES Student(ID) ON DELETE CASCADE, 
    FOREIGN KEY(Course_ID) REFERENCES Course(Course_ID) ON DELETE CASCADE
    );

CREATE VIEW Student_name AS 
SELECT student_ID, Student_name 
FROM Registration 
WHERE Student_type 'FT';