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

CREATE TABLE `exams` (
    `exam_id` INT PRIMARY KEY,
    `name` VARCHAR(20) NOT NULL
);

INSERT INTO `students` (`name`) VALUES
    ('Mila'),
    ('Toni'),
    ('Ron');

INSERT INTO `exams` VALUES
    (101, 'Spring MVC'),
    (102, 'Neo4j'),
    (103, 'Oracle 11g');

CREATE TABLE `students_exams` (
    `student_id` INT NOT NULL,
    `exam_id` INT NOT NULL,
    CONSTRAINT `pk_students_exams`
        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_exams` VALUES
    (1, 101),
    (1, 102),
    (2, 101),
    (3, 103),
    (2, 102),
    (2, 103);