CREATE TABLE Predmet (
    predmet_id INTEGER PRIMARY KEY AUTOINCREMENT,
    naziv TEXT NOT NULL
);
 
CREATE TABLE Sekcija (
    sekcija_id INTEGER PRIMARY KEY AUTOINCREMENT,
    naziv TEXT NOT NULL
);
 
CREATE TABLE Predmet_Sekcija (
    predmet_id INTEGER,
    sekcija_id INTEGER,
    PRIMARY KEY (predmet_id, sekcija_id),
    FOREIGN KEY (predmet_id) REFERENCES Predmet(predmet_id),
    FOREIGN KEY (sekcija_id) REFERENCES Sekcija(sekcija_id)
);
 
CREATE TABLE Projekat (
    projekat_id INTEGER PRIMARY KEY AUTOINCREMENT,
    naziv TEXT NOT NULL,
    sekcija_id INTEGER,
    FOREIGN KEY (sekcija_id) REFERENCES Sekcija(sekcija_id)
);
 
INSERT INTO Predmet (naziv) VALUES
('Srpski jezik'),
('Likovno'),
('Engleski'),
('Racunarstvo');
 
INSERT INTO Sekcija (naziv) VALUES
('Dramska'),
('Novinarska'),
('Robotika'),
('Web-programiranje');
 
INSERT INTO Predmet_Sekcija VALUES
(1,1),
(2,1),
(1,2),
(3,2),
(4,2),
(4,3),
(4,4);
 
INSERT INTO Projekat (naziv, sekcija_id) VALUES
('IoT', 3),
('Hamlet', 1),
('Trijumfalna kapija', 1),
('Kandze', 1),
('Vremenska prognoza', 2),
('Sport', 2),
('CV', 4),
('Onlajn prodaja', 4),
('Bezbednost na internetu', 4);
 
SELECT * FROM Predmet;
SELECT * FROM Sekcija;
SELECT * FROM Predmet_Sekcija;
SELECT * FROM Projekat;

Q1JFQVRFIFRBQkxFIFByZWRtZXQgKAogICAgcHJlZG1ldF9pZCBJTlRFR0VSIFBSSU1BUlkgS0VZIEFVVE9JTkNSRU1FTlQsCiAgICBuYXppdiBURVhUIE5PVCBOVUxMCik7CgpDUkVBVEUgVEFCTEUgU2VrY2lqYSAoCiAgICBzZWtjaWphX2lkIElOVEVHRVIgUFJJTUFSWSBLRVkgQVVUT0lOQ1JFTUVOVCwKICAgIG5heml2IFRFWFQgTk9UIE5VTEwKKTsKCkNSRUFURSBUQUJMRSBQcmVkbWV0X1Nla2NpamEgKAogICAgcHJlZG1ldF9pZCBJTlRFR0VSLAogICAgc2VrY2lqYV9pZCBJTlRFR0VSLAogICAgUFJJTUFSWSBLRVkgKHByZWRtZXRfaWQsIHNla2NpamFfaWQpLAogICAgRk9SRUlHTiBLRVkgKHByZWRtZXRfaWQpIFJFRkVSRU5DRVMgUHJlZG1ldChwcmVkbWV0X2lkKSwKICAgIEZPUkVJR04gS0VZIChzZWtjaWphX2lkKSBSRUZFUkVOQ0VTIFNla2NpamEoc2VrY2lqYV9pZCkKKTsKCkNSRUFURSBUQUJMRSBQcm9qZWthdCAoCiAgICBwcm9qZWthdF9pZCBJTlRFR0VSIFBSSU1BUlkgS0VZIEFVVE9JTkNSRU1FTlQsCiAgICBuYXppdiBURVhUIE5PVCBOVUxMLAogICAgc2VrY2lqYV9pZCBJTlRFR0VSLAogICAgRk9SRUlHTiBLRVkgKHNla2NpamFfaWQpIFJFRkVSRU5DRVMgU2VrY2lqYShzZWtjaWphX2lkKQopOwoKSU5TRVJUIElOVE8gUHJlZG1ldCAobmF6aXYpIFZBTFVFUwooJ1NycHNraSBqZXppaycpLAooJ0xpa292bm8nKSwKKCdFbmdsZXNraScpLAooJ1JhY3VuYXJzdHZvJyk7CgpJTlNFUlQgSU5UTyBTZWtjaWphIChuYXppdikgVkFMVUVTCignRHJhbXNrYScpLAooJ05vdmluYXJza2EnKSwKKCdSb2JvdGlrYScpLAooJ1dlYi1wcm9ncmFtaXJhbmplJyk7CgpJTlNFUlQgSU5UTyBQcmVkbWV0X1Nla2NpamEgVkFMVUVTCigxLDEpLAooMiwxKSwKKDEsMiksCigzLDIpLAooNCwyKSwKKDQsMyksCig0LDQpOwoKSU5TRVJUIElOVE8gUHJvamVrYXQgKG5heml2LCBzZWtjaWphX2lkKSBWQUxVRVMKKCdJb1QnLCAzKSwKKCdIYW1sZXQnLCAxKSwKKCdUcmlqdW1mYWxuYSBrYXBpamEnLCAxKSwKKCdLYW5kemUnLCAxKSwKKCdWcmVtZW5za2EgcHJvZ25vemEnLCAyKSwKKCdTcG9ydCcsIDIpLAooJ0NWJywgNCksCignT25sYWpuIHByb2RhamEnLCA0KSwKKCdCZXpiZWRub3N0IG5hIGludGVybmV0dScsIDQpOwoKU0VMRUNUICogRlJPTSBQcmVkbWV0OwpTRUxFQ1QgKiBGUk9NIFNla2NpamE7ClNFTEVDVCAqIEZST00gUHJlZG1ldF9TZWtjaWphOwpTRUxFQ1QgKiBGUk9NIFByb2pla2F0Ow==