CREATE TABLE courses (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
years VARCHAR(50) NOT NULL
);
CREATE TABLE Professors (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
first_name VARCHAR(100) NOT NULL,
last_name VARCHAR(50) NOT NULL,
FOREIGN KEY (course_id) REFERENCES courses(id)
);