CREATE TABLE Students (
first_name VARCHAR(20),
last_name VARCHAR(20),
birthday DATE,
s_id INT, 
CONSTRAINT pk_Students PRIMARY KEY (s_id)
);

CREATE TABLE Enrolments (
s_id INT, 
course_code VARCHAR(20),
year INT, 
CONSTRAINT fk_Enrolments FOREIGN KEY (s_id)
REFERENCES Students(s_id)
);

INSERT INTO Students(first_name,last_name,birthday, s_id) VALUES ('Bryan', 'Davies', '2022-01-23', '1');

INSERT INTO Enrolments(s_id,course_code,year) VALUES ('1', 'COMP201', '2021');

    SELECT * FROM Students;