Notes

Create Database VeterinerDB
Go
Use VeterinerDB

Create Table Veterinerler
(
VeterinerId Int Identity,
Ad Varchar(50),
Soyad Varchar(50),
GSM Varchar(9),
Constraint PK_Veterinerler_VeterinerId Primary Key(VeterinerId),
Constraint AN_Veterinerler_GSM Unique(GSM),
Constraint CN_Veterinerler_GSM Check(GSM Like '[5][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
)

Create Table Turler
(
TurId Int Identity,
Tur Varchar(50),
Constraint PK_Turler_TurId Primary Key(TurId)
)

Create Table Musteriler
(
MusteriId Int Identity,
Ad Varchar(50),
Soyad Varchar(50),
GSM Varchar(9),
Adres Varchar(200),
Constraint PK_Musteriler_MusteriId Primary Key(MusteriId),
Constraint AN_Musteriler_GSM Unique(GSM),
Constraint CN_Musteriler_GSM Check(GSM Like '[5][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
)

Create Table Hastalar
(
HastaId Int Identity,
TurId Int,
Ad Varchar(50),
Tarih Date Default GETDATE(),
Cinsiyet Bit,
MusteriId Int,
Constraint PK_Hastalar_HastaId Primary Key(HastaId),
Constraint FK_Hastalar_TurId Foreign Key(TurId) References Turler(TurId),
Constraint FK_Hastalar_MusteriId Foreign Key(MusteriId) References Musteriler(MusteriId)
)

Create Table Teshisler
(
TeshisId Int Identity,
Teshis Varchar(50),
VeterinerId Int,
HastaId Int,
Aciklama Varchar(200),
Tarih Date,
Constraint PK_Teshisler_TeshisId Primary Key(TeshisId),
Constraint FK_Teshisler_VeterinerId Foreign Key(VeterinerId) References Veterinerler(VeterinerId),
Constraint FK_Teshisler_HastaId Foreign Key(HastaId) References Hastalar(HastaId)
)

Create Table Tedaviler
(
TedaviId Int Identity,
TedaviAdi Varchar(50),
Tarih Date,
VeterinerId Int,
Ucret Money,
Constraint PK_Tedaviler_TedaviId Primary Key(TedaviId),
Constraint FK_Tedaviler_VeterinerId Foreign Key(VeterinerId) References Veterinerler(VeterinerId)
)

Create Table AsiKarneleri
(
KarneId Int Identity,
Asi Varchar(50),
Tarih Date,
HastaId Int,
Constraint PK_AsiKarneleri_KarneId Primary Key(KarneId),
Constraint FK_AsiKarneleri_HastaId Foreign Key(HastaId) References Hastalar(HastaId)
)

Create Table Cikislar
(
CikisId Int Identity,
TeshisId Int,
TedaviId Int,
HastaId Int,
MusteriId Int,
Tarih Date,
Constraint PK_Cikislar_CikisId Primary Key(CikisId),
Constraint FK_Cikislar_TeshisId Foreign Key(TeshisId) References Teshisler(TeshisId),
Constraint FK_Cikislar_TedaviId Foreign Key(TedaviId) References Tedaviler(TedaviId),
Constraint FK_Cikislar_HastaId Foreign Key(HastaId) References Hastalar(HastaId),
Constraint FK_Cikislar_MusteriId Foreign Key(MusteriId) References Musteriler(MusteriId)
)