1. CREATE TABLE SKALAOCEN(
2.     ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
3.     OCENA VARCHAR(3) NOT NULL,
4.     CONSTRAINT SKALAOCEN_PK PRIMARY KEY(ID)
5. );
6.  
7. CREATE TABLE PRZEDMIOT(
8.     ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
9.     NAZWA VARCHAR(40) NOT NULL,
10.     CONSTRAINT PRZEDMIOT_PK PRIMARY KEY(ID)
11. );
12.  
13. CREATE TABLE STUDENT(
14.     ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
15.     NRALBUMU INTEGER NOT NULL,
16.     IMIE VARCHAR(30) NOT NULL,
17.     NAZWISKO VARCHAR(30) NOT NULL,
18.     CONSTRAINT STUDENT_PK PRIMARY KEY(ID)
19. );
20.  
21. CREATE TABLE OCENA(
22.     ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
23.     DZIEN DATE NOT NULL,
24.     STUDENT_ID INTEGER,
25.     PRZEDMIOT_ID INTEGER,
26.     SKALAOCEN_ID INTEGER,
27.     CONSTRAINT OCENA_PK PRIMARY KEY(ID),
28.     CONSTRAINT OCENA_FK1 FOREIGN KEY(STUDENT_ID) REFERENCES STUDENT(ID),
29.     CONSTRAINT OCENA_FK2 FOREIGN KEY(PRZEDMIOT_ID) REFERENCES PRZEDMIOT(ID),
30.     CONSTRAINT OCENA_FK3 FOREIGN KEY(SKALAOCEN_ID) REFERENCES SKALAOCEN(ID)
31. );