DROP TABLE IF EXISTS students;
DROP TABLE IF EXISTS music;
DROP TABLE IF EXISTS activities;
DROP TABLE IF EXISTS participation;


CREATE TABLE students (
student_id INTEGER PRIMARY KEY,
name TEXT,
age INTEGER,
class TEXT
);


CREATE TABLE music (
student_id INTEGER,
genre TEXT
);


CREATE TABLE activities (
activity_id INTEGER PRIMARY KEY,
title TEXT
);


CREATE TABLE participation (
student_id INTEGER,
activity_id INTEGER
);


INSERT INTO students VALUES (1, 'Γιάννης', 16, 'Γ3');
INSERT INTO students VALUES (2, 'Μαρία', 17, 'Γ2');
INSERT INTO students VALUES (3, 'Νίκος', 17, 'Γ1');


INSERT INTO music VALUES (1, 'Rap');
INSERT INTO music VALUES (2, 'Pop');
INSERT INTO music VALUES (3, 'Rock');


INSERT INTO activities VALUES (1, 'Σχολικό Podcast');
INSERT INTO activities VALUES (2, 'Ομάδα Μπάσκετ');


INSERT INTO participation VALUES (1, 1);
INSERT INTO participation VALUES (1, 2);
INSERT INTO participation VALUES (2, 1);