DELETE FROM zesp WHERE nr_zesp=5;

INSERT INTO ZESP
VALUES (12,'BEZPIECZENSTWO', 5, 5);

INSERT INTO PRAC
VALUES (42,'M',1956-04-10, 'LOS', 12);

UPDATE PRAC
SET NR_PRAC = 10
WHERE NR_PRAC=43

UPDATE ZESP
SET NR_ZESP = 13
WHERE NR_ZESP=1

DELETE FROM zesp WHERE nr_zesp=13;

DELETE FROM PRAC WHERE nr_prac=1;

INSERT INTO PRAC
VALUES (1,'M',1956-04-10, 'ANDRZEJEWSKI', 12);

INSERT INTO ZESP
VALUES (1,'ZARZAD', 7, 1);

UPDATE PRAC
SET NR_PRAC =11
WHERE NR_PRAC=23

INSERT INTO PRAC
VALUES (23,'K',1956-04-10, 'KOROL', 11);