ALTER TABLE lecturer
DROP COLUMN subject_code;

INSERT INTO lecturer(first_name, last_name, gender, code_number, email, password)
VALUES
('Dr. <NAME>',	'<NAME>', 'Female', '100515101', '<EMAIL>', '123'),
('Dr. <NAME>', 'Zainuddin', 'Male', '100515102', '<EMAIL>', '123');

DROP TABLE lecturer_student_subject;

CREATE TABLE lecturer_student_course (
    id SERIAL PRIMARY KEY,
    lecturer_id INT REFERENCES lecturer(id),
    course_information_id INT REFERENCES course_information(id),
    student_id INT REFERENCES student(id)
);