CREATE TABLE students(
    student_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50)
);

CREATE TABLE exams(
    exam_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50)
);

CREATE TABLE students_exams(
    student_id INT NOT NULL,
    exam_id INT NOT NULL,
    CONSTRAINT pk_students_exams_id PRIMARY KEY(student_id,exam_id),
    CONSTRAINT fk_students_exams_students FOREIGN KEY (student_id)
    REFERENCES students(student_id),
    CONSTRAINT fk_students_exams_exams FOREIGN KEY (exam_id)
    REFERENCES exams(exam_id)
);

INSERT INTO students(name) VALUES('Mila'),('Toni'),('Ron');
SELECT * FROM students;

INSERT INTO exams(exam_id,name)
VALUES  (101,'Spring MVC'),
        (102,'Neo4j'),
        (103,'Oracle 11g');
SELECT * FROM exams;

INSERT INTO students_exams(student_id,exam_id)
VALUES  (1,101),
        (1,102),
        (2,101),
        (3,103),
        (2,102),
        (2,103);
SELECT * FROM students_exams;