CREATE TABLE STYPENDIUM(
  ID_STYP NUMBER(4) NOT NULL,
  ID_STUDENT NUMBER(4),
  KWOTA NUMBER(6,2) NOT NULL,
  DATA_PRZYZ DATE,
  DATA_ZAK DATE,
  CONSTRAINT FK_STUDENT FOREIGN KEY (ID_STUDENT)
  REFERENCES STUDENT(ID)
);

INSERT INTO STYPENDIUM VALUES(1, 10, 400, '17/10/09', '18/02/01');
INSERT INTO STYPENDIUM VALUES(2, 20, 350, '17/01/12', '17/10/31');
INSERT INTO STYPENDIUM VALUES(3, 30, 100, '17/01/02', '18/01/01');
INSERT INTO STYPENDIUM VALUES(4, 4, 200, '16/02/01', '17/10/01');
INSERT INTO STYPENDIUM VALUES(5, 8, 200, '17/10/01', '18/01/31');
INSERT INTO STYPENDIUM VALUES(6, 5, 350, '17/10/01', '18/06/30');
INSERT INTO STYPENDIUM VALUES(7, 23, 300, '16/10/01', '17/10/01');
INSERT INTO STYPENDIUM VALUES(8, 21, 100, '18/02/01', '18/06/30');
INSERT INTO STYPENDIUM VALUES(9, 19, 100, '17/02/01', '17/06/30');
INSERT INTO STYPENDIUM VALUES(10, 20, 400, '17/10/01', '18/02/28');