# 03. Many-To-Many Relationship
CREATE DATABASE students;
USE students;

CREATE TABLE exams
(
    exam_id INT UNSIGNED PRIMARY KEY NOT NULL UNIQUE,
    name    VARCHAR(30)              NOT NULL UNIQUE
);

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

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

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


CREATE TABLE students_exams
(
    student_id INT UNSIGNED NOT NULL,
    exam_id    INT UNSIGNED NOT NULL,

    CONSTRAINT pk_studentId_examId
        PRIMARY KEY (student_id, exam_id),
    CONSTRAINT fk_studentsExams_students
        FOREIGN KEY (student_id) REFERENCES students (student_id),
    CONSTRAINT fk_studentsExams_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);