CREATE TABLE PREDMETI (
    id_predmeta INT PRIMARY KEY AUTO_INCREMENT,
    naziv_predmeta VARCHAR(100) NOT NULL
);
 
CREATE TABLE SEKCIJE (
    id_sekcije INT PRIMARY KEY AUTO_INCREMENT,
    naziv_sekcije VARCHAR(100) NOT NULL
);
 
CREATE TABLE SEKCIJA_PREDMET (
    id_sekcije INT,
    id_predmeta INT,
    PRIMARY KEY (id_sekcije, id_predmeta),
    FOREIGN KEY (id_sekcije) REFERENCES SEKCIJE(id_sekcije) ON DELETE CASCADE,
    FOREIGN KEY (id_predmeta) REFERENCES PREDMETI(id_predmeta) ON DELETE CASCADE
);
 
CREATE TABLE PROJEKTI (
    id_projekta INT PRIMARY KEY AUTO_INCREMENT,
    naziv_projekta VARCHAR(100) NOT NULL,
    id_sekcije INT,
    FOREIGN KEY (id_sekcije) REFERENCES SEKCIJE(id_sekcije) ON DELETE CASCADE
);
 
INSERT INTO PREDMETI (naziv_predmeta) VALUES 
('Srpski jezik'), ('Likovno'), ('Engleski'), ('Računarstvo');
 
INSERT INTO SEKCIJE (naziv_sekcije) VALUES 
('Dramska sekcija'), ('Novinarska sekcija'), ('Robotika'), ('Veb-programiranje');
 
INSERT INTO SEKCIJA_PREDMET (id_sekcije, id_predmeta) VALUES 
(1, 1), (1, 2),
(2, 1), (2, 3), (2, 4),
(3, 4),
(4, 4);
 
INSERT INTO PROJEKTI (naziv_projekta, id_sekcije) VALUES 
('Hamlet', 1),
('Trijumfalna kapija', 1),
('Kandže', 1),
('Vremenska prognoza', 2),
('Sport', 2),
('IoT', 3),
('CV', 4),
('Onlajn prodaja', 4),
('Bezbednost na internetu', 4);
 
UPDATE PROJEKTI 
SET naziv_projekta = 'Weather Forecast' 
WHERE naziv_projekta = 'Vremenska prognoza';
 
DELETE FROM PROJEKTI 
WHERE naziv_projekta = 'Sport';
 

Q1JFQVRFIFRBQkxFIFBSRURNRVRJICgKICAgIGlkX3ByZWRtZXRhIElOVCBQUklNQVJZIEtFWSBBVVRPX0lOQ1JFTUVOVCwKICAgIG5heml2X3ByZWRtZXRhIFZBUkNIQVIoMTAwKSBOT1QgTlVMTAopOwoKQ1JFQVRFIFRBQkxFIFNFS0NJSkUgKAogICAgaWRfc2VrY2lqZSBJTlQgUFJJTUFSWSBLRVkgQVVUT19JTkNSRU1FTlQsCiAgICBuYXppdl9zZWtjaWplIFZBUkNIQVIoMTAwKSBOT1QgTlVMTAopOwoKQ1JFQVRFIFRBQkxFIFNFS0NJSkFfUFJFRE1FVCAoCiAgICBpZF9zZWtjaWplIElOVCwKICAgIGlkX3ByZWRtZXRhIElOVCwKICAgIFBSSU1BUlkgS0VZIChpZF9zZWtjaWplLCBpZF9wcmVkbWV0YSksCiAgICBGT1JFSUdOIEtFWSAoaWRfc2VrY2lqZSkgUkVGRVJFTkNFUyBTRUtDSUpFKGlkX3Nla2NpamUpIE9OIERFTEVURSBDQVNDQURFLAogICAgRk9SRUlHTiBLRVkgKGlkX3ByZWRtZXRhKSBSRUZFUkVOQ0VTIFBSRURNRVRJKGlkX3ByZWRtZXRhKSBPTiBERUxFVEUgQ0FTQ0FERQopOwoKQ1JFQVRFIFRBQkxFIFBST0pFS1RJICgKICAgIGlkX3Byb2pla3RhIElOVCBQUklNQVJZIEtFWSBBVVRPX0lOQ1JFTUVOVCwKICAgIG5heml2X3Byb2pla3RhIFZBUkNIQVIoMTAwKSBOT1QgTlVMTCwKICAgIGlkX3Nla2NpamUgSU5ULAogICAgRk9SRUlHTiBLRVkgKGlkX3Nla2NpamUpIFJFRkVSRU5DRVMgU0VLQ0lKRShpZF9zZWtjaWplKSBPTiBERUxFVEUgQ0FTQ0FERQopOwoKSU5TRVJUIElOVE8gUFJFRE1FVEkgKG5heml2X3ByZWRtZXRhKSBWQUxVRVMgCignU3Jwc2tpIGplemlrJyksICgnTGlrb3ZubycpLCAoJ0VuZ2xlc2tpJyksICgnUmHEjXVuYXJzdHZvJyk7CgpJTlNFUlQgSU5UTyBTRUtDSUpFIChuYXppdl9zZWtjaWplKSBWQUxVRVMgCignRHJhbXNrYSBzZWtjaWphJyksICgnTm92aW5hcnNrYSBzZWtjaWphJyksICgnUm9ib3Rpa2EnKSwgKCdWZWItcHJvZ3JhbWlyYW5qZScpOwoKSU5TRVJUIElOVE8gU0VLQ0lKQV9QUkVETUVUIChpZF9zZWtjaWplLCBpZF9wcmVkbWV0YSkgVkFMVUVTIAooMSwgMSksICgxLCAyKSwKKDIsIDEpLCAoMiwgMyksICgyLCA0KSwKKDMsIDQpLAooNCwgNCk7CgpJTlNFUlQgSU5UTyBQUk9KRUtUSSAobmF6aXZfcHJvamVrdGEsIGlkX3Nla2NpamUpIFZBTFVFUyAKKCdIYW1sZXQnLCAxKSwKKCdUcmlqdW1mYWxuYSBrYXBpamEnLCAxKSwKKCdLYW5kxb5lJywgMSksCignVnJlbWVuc2thIHByb2dub3phJywgMiksCignU3BvcnQnLCAyKSwKKCdJb1QnLCAzKSwKKCdDVicsIDQpLAooJ09ubGFqbiBwcm9kYWphJywgNCksCignQmV6YmVkbm9zdCBuYSBpbnRlcm5ldHUnLCA0KTsKClVQREFURSBQUk9KRUtUSSAKU0VUIG5heml2X3Byb2pla3RhID0gJ1dlYXRoZXIgRm9yZWNhc3QnIApXSEVSRSBuYXppdl9wcm9qZWt0YSA9ICdWcmVtZW5za2EgcHJvZ25vemEnOwoKREVMRVRFIEZST00gUFJPSkVLVEkgCldIRVJFIG5heml2X3Byb2pla3RhID0gJ1Nwb3J0JzsK