Notes
Notes - notes.io |
Bir veteriner kliniği için geliştirilecek olan otomasyon sistemi için aşağıdaki gereksinimleri karşılayacak olan veritabanını tasarlayınız:
1. Kliniğe ait bilgiler tutulmalıdır.
a. Adı
b. Adresi
c. Web sitesi
d. Telefonu
e. Fax
2. Veteriner bilgileri tutulmalıdır
a. Ad
b. Soyad
c. Gsm
3. Hasta hayvanlarla ilgili bilgiler tutulmalıdır
a. Ad
b. Doğum tarihi
c. Cinsiyet
d. Sahibi (müşteri)
4. Müşterilerle ilgili bilgiler tutulmalıdır
a. Ad
b. Soyad
c. Telefon
d. Adres
5. Hayvanların aşı karnesi tutulmalıdır
a. Aşı türü
b. Tarihi
6. Hayvan teşhis/tanı/muayene bilgileri tutulmalıdır
a. Tanıyı koyan veteriner
b. Tanı konulan hayvan
c. Açıklama
d. Tarih
7. Muhasebe bilgileri takip edilmelidir
a. Tanı
b. Hayvan
c. Müşteri
d. Ücret
e. Tarih
*/
Create database VeterinerDB
Use VeterinerDB
Go
Create table Musteri
(
Musteriıd Int Identity,
Musteriadi varchar(50),
Musterisoyadi varchar(50),
Musteritelefon varchar(11),
Musteriadres varchar(250),
constraint PK_Musteri_MusteriId primary key (MusteriId)
)
Go
Create table Veteriner
(
VeterinerId Int Identity,
VeterinerAdi varchar(50),
VeterinerSoyadi varchar(50),
GSM varchar(11),
HastaHayvanId Int,
Constraint AN_Klinik_GSM Unique (GSM),
Constraint PK_Veteriner_VeterinerId primary key (VeterinerId),
Constraint FK_Veteriner_HastaHayvanId foreign key (HastaHayvanId) references HastaHayvan(HastaHayvanId)
)
Go
Create table Klinik
(
KlinikId Int Identity,
Klinikadi varchar(50),
KlinikAdresi varchar(250),
Websitesi varchar(50),
KlinikTelefonu varchar(11),
KlinikFax varchar(11),
MusteriId Int,
VeterinerId Int,
Constraint PK_Klinik_KlinikId primary key (KlinikId),
Constraint AN_Klinik_KlinikTelefonu Unique (KlinikTelefonu),
Constraint AN_Klinik_KlinikFax Unique (KlinikFax),
Constraint FK_Klinik_MusteriId foreign key (MusteriId) references Musteri (MusteriId),
Constraint FK_Klinik_MusteriId foreign key (VeterinerId) references Veteriner(VeterinerId)
)
Go
Create table HastaHayvan
(
HastaHayvanId Int Identity,
HastaHayvanAdi varchar(50),
DoğumTarihi date,
Cinsiyet varchar(10),
Sahibi varchar(50),
Constraint PK_HastaHayvan_HastaHayvanId primary key (HastaHayvanId)
)
Go
Create table HayvanAsı
(
AsıId Int Identity,
AsıTürü varchar(25),
AsıTarihi Date,
Constraint PK_HayvanAsı_AsıId primary key (AsıId)
)
Go
Create table HayvanTeshis
(
TaniKoyan varchar(50),
TaniHayvan varchar(50),
Aciklama varchar(250),
TeshisTarih date
)
Go
Create table Muhasebe
(
Tani varchar(50),
Hayvanadi varchar(50),
Musteriadi varchar(50),
Ucret money,
Tarih date
)
|
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
