CREATE TABLE OGRENCIBILGILERI(IDOGRENCI INT PRIMARY KEY, TCKIMLIK INT NOT NULL, OGRENCIADI NVARCHAR(40), DOGUMTARIHI DATE, IDBOLUM INT)
CREATE TABLE OGRENCINOTLARI(ID_ON INT PRIMARY KEY, IDOGRENCI INT, IDDERS INT, VIZE FLOAT, FINAL FLOAT)
CREATE TABLE OGRENCIDERS(ID_OD INT PRIMARY KEY, IDOGRENCI INT, IDDERS INT)
CREATE TABLE DERSLER(IDDERS INT PRIMARY KEY, DERSADI NVARCHAR(40), IDBOLUM INT, IDHOCA INT, KREDISI INT)
CREATE TABLE HOCALAR(IDHOCA INT PRIMARY KEY, HOCAADI NVARCHAR(40), IDBOLUM INT)
CREATE TABLE BOLUMLER(IDBOLUM INT PRIMARY KEY, BOLUMADI NVARCHAR(40))

ALTER TABLE OGRENCINOTLARI ADD FOREIGN KEY (IDOGRENCI) REFERENCES OGRENCIBILGILERI (IDOGRENCI)
ALTER TABLE OGRENCINOTLARI ADD FOREIGN KEY (IDDERS) REFERENCES DERSLER (IDDERS)
ALTER TABLE OGRENCIBILGILERI ADD FOREIGN KEY (IDBOLUM) REFERENCES BOLUMLER (IDBOLUM)
ALTER TABLE DERSLER ADD FOREIGN KEY (IDHOCA) REFERENCES HOCALAR (IDHOCA)
ALTER TABLE OGRENCIDERS ADD FOREIGN KEY (IDOGRENCI) REFERENCES OGRENCIBILGILERI (IDOGRENCI)
ALTER TABLE OGRENCIDERS ADD FOREIGN KEY (IDDERS) REFERENCES DERSLER (IDDERS)
ALTER TABLE HOCALAR ADD FOREIGN KEY (IDBOLUM) REFERENCES BOLUMLER (IDBOLUM)

INSERT INTO BOLUMLER VALUES(1, 'BILGISAYAR PROGRAMCILIGI')
INSERT INTO HOCALAR VALUES(1, 'HATICE GUCLU', 1)
INSERT INTO OGRENCIBILGILERI VALUES(1, '2784', 'SAMI VARTOKGOZ', '2004.01.01', 1)
INSERT INTO DERSLER VALUES(1, 'VERITABANI YONETIMI', 1, 1, 2.84)
INSERT INTO OGRENCIDERS VALUES(1, 1, 1)