Notes

betul_fakulte uyg
********************************************
CREATE TABLE tblFakulteler
(
fakulte_ıd int NOT NULL,
fakulte_ad nvarchar(25) NOT NULL,
CONSTRAINT fakulte PRIMARY KEY(fakulte_ıd)
)
********************************************
CREATE TABLE tblbolumler
(
bolum_no int NOT NULL,
bolum_ad nvarchar(25) NOT NULL,
fakulte_kod int NOT NULL,
CONSTRAINT bolum PRIMARY KEY(bolum_no)
)
********************************************
CREATE TABLE tbldersler
(
ders_no int NOT NULL,
ders_ad nvarchar(25) NOT NULL,
bolum_kod int NOT NULL,
kredi int,
CONSTRAINT ders PRIMARY KEY (ders_no)
)
********************************************
CREATE TABLE tblogrenciler
(
ogrenci_no int NOT NULL,
ogrenci_ad nvarchar(25) NOT NULL,
ogrenci_soyad nvarchar(25) NOT NULL,
cinsiyet nvarchar(5) NOT NULL,
dogum_tarihi date NOT NULL,
bolum_kod int,
CONSTRAINT o_no PRIMARY KEY (ogrenci_no)
)
********************************************
CREATE TABLE tblnotlar
(
ogrenci_no int NOT NULL,
ders_kod int NOT NULL,
ogrenci_soyad nvarchar(25) NOT NULL,
vize int,
final int,
butunleme int,
durum nvarchar(5),
CONSTRAINT o_noo PRIMARY KEY(ogrenci_no),
CONSTRAINT notu CHECK(vize>0 AND vize<=100),
CONSTRAINT notuf CHECK(final>0 AND vize<=100),
CONSTRAINT notub CHECK(butunleme>0 AND vize<=100),
)
********************************************