CREATE DATABASE FINAL

GO

USE FINAL CREATE TABLE BOLUM(KOD INT IDENTITY NOT NULL PRIMARY KEY,

BLM NVARCHAR(40) NOT NULL)

GO

CREATE TABLE MESLEK(KOD INT DENTITY NOT NULL PRIMARY KEY,

MESLEK NVARCHAR(40) NOT NULL)

GO

CREATE TABLE PERSONEL(KOD INT IDENTITY NOT NULL PRIMARY KEY,

ADSOYAD NVARCHAR(40) NOT NULL,

MESLEK INT NOT NULL,

BOLUM INT NOT NULL,

IL NVARCHAR(20) NOT NULL,

ILCE NVARCHAR(20) NOT NULL CONSTRAINT FK_MESLEK FOREIGN KEY (MESLEK)REFERENCES BOLUM(KOD),

CONSTRAINT FK_BOLUM FOREIGN KEY (BOLUM) REFERENCES MESLEK(KOD) )

GO