CREATE DATABASE skola;
USE skola;

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

CREATE TABLE clubs (
    id INT PRIMARY KEY AUTO_INCREMENT,
    club_name VARCHAR(50) NOT NULL
);

CREATE TABLE student_club (
    student_id INT,
    club_id INT,
    PRIMARY KEY (student_id, club_id),
    FOREIGN KEY (student_id) REFERENCES students(id),
    FOREIGN KEY (club_id) REFERENCES clubs(id)
);
