-- CREATE TABLES
CREATE TABLE classes (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
className VARCHAR(16) NOT NULL,
instructor VARCHAR(16) NOT NULL
);
CREATE TABLE students (
id INT NOT NULL AUTO_INCREMENT,
firstName VARCHAR(30) NOT NULL,
lastName VARCHAR(255) NOT NULL,
age INT,
email VARCHAR(255) UNIQUE,
classId INT,
PRIMARY KEY (id),
FOREIGN KEY (classId) REFERENCES classes(id) ON DELETE CASCADE
);
-- INSERT DATA
INSERT INTO classes (className, instructor) VALUES
('React', 'Anna Sfairo'),
('Express', 'Zoe Laventhol');
INSERT INTO `students` (firstName, lastName, email, age, classId) VALUES
('Lillian', 'Az', 'laz@codeop.tech', 32, 2),
('Niamh', 'Doyle', 'ndoyle@codeop.tech', 43, 1),
('Sian', 'Fairley', 'sfairley@codeop.tech', 42, 1),
('Jen', 'Hansonify', 'jhansonify@codeop.tech', 18, 2),
('Lethabo', 'Ndumo', 'lndumo@codeop.tech', 54, 2),
('Rebecca', 'Lupton', 'rlupton@codeop.tech', 27, 2),
('Larissa', 'Hernandez', 'lhernandez@codeop.tech', 31, 2),
('Elis', 'Matlik', 'ematlik@codeop.tech', 30, 1),
('Veronica', 'Viscardi', 'vviscardi@codeop.tech', 32, 2),
('Maria Carolina', 'Rinaldi', 'mcrinaldi@codeop.tech', 29, 2);