Notes
Notes - notes.io |
go
use uniklupDB
go
create table universite
(
universiteNO Int identity,
universiteAdi varchar(50) not null,
universiteAdresi varchar (120) not null,
universiteTel int (11) not null,
universiteFax int (11) not null,
universiteWeb varchar (50) not null,
universiteTuru varchar (20) not null,
constraint PK_universite_universiteNO primary key (universiteNO),
constraint CK_universite_universiteTel check (universiteTel Like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
constraint CK_universite_universiteFax check (universiteFax Like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
Constraint FK_universite_universiteAdi Foreign Key (universiteNO) References universiteogrenci (universiteogrenciNO)
)
go
create table universitefakulte
(
universitefakulteNO int identity,
universitefakulteAdi varchar (50) not null,
universitefakulteAderesi varchar (120) not null,
universitefakulteTel int (11) not null,
universitefakulteFax int (11) not null,
universitefakulteWeb varchar (50) not null,
constraint PK_universitefakulte_universitefakulteNO primary key (universitefakulteNO),
constraint CK_universitefakulte_universitefakulteTel check (universitefakulteTel Like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
constraint CK_universitefakulte_universitefakulteFax check (universitefakulteFax Like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
)
go
create table universiteyuksekokul
(
universiteyuksekokulNO int identity,
universiteyuksekokulAdi varchar (50) not null,
universiteyuksekokulAderesi varchar (120) not null,
universiteyuksekokulTel int (11) not null,
universiteyuksekokulFax int (11) not null,
universiteyuksekokulWeb varchar (50) not null,
constraint PK_universiteyuksekokul_universiteyuksekokulNO primary key (universiteyuksekokulNO),
constraint CK_universiteyuksekokul_universiteyuksekokulTel check (universiteyuksekokulTel Like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
constraint CK_universiteyuksekokul_universiteyuksekokulFax check (universiteyuksekokulFax Like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
)
go
create table universiteenstitu
(
universiteenstituNO int identity,
universiteenstituAdi varchar (50) not null,
universiteenstituAderesi varchar (120) not null,
universiteenstituTel int (11) not null,
universiteenstituFax int (11) not null,
universiteenstituWeb varchar (50) not null,
constraint PK_universiteenstitu_universiteenstituNO primary key (universiteenstituNO),
constraint CK_universiteenstitu_universiteenstituTel check (universiteenstituTel Like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
constraint CK_universiteenstitu_universiteenstituFax check (universiteenstituFax Like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
)
go
create table universitemeslekyo
(
universitemeslekyoNO int identity,
universitemeslekyoAdi varchar (50) not null,
universitemeslekyoAderesi varchar (120) not null,
universitemeslekyoTel int (11) not null,
universitemeslekyoFax int (11) not null,
universitemeslekyoWeb varchar (50) not null,
constraint PK_universitemeslekyo_universitemeslekyoNO primary key (universitemeslekyoNO),
constraint CK_universitemeslekyo_universitemeslekyoTel check (universitemeslekyoTel Like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
constraint CK_universitemeslekyo_universitemeslekyoFax check (universitemeslekyoFax Like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
)
go
create table universitebolum
(
universitebolumNO int identity,
universitebolumAdi varchar (50) not null,
universitebolumTel int (11) not null,
constraint PK_universitebolum_universitebolumNO primary key (universitebolumNO),
constraint CK_universitebolum_universitebolumTel check (universitebolumTel Like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
)
go
create table universiteogrenci
(
universiteogrenciNO int identity
universiteogrenciAdi varchar (50) not null,
universiteogrenciSoyadi varchar (50) not null,
universiteogrenciTc int (11) not null,
universiteogrenciCinsiyet varchar (10) not null,
universiteogrenciDogumyeri varchar (120) not null,
universiteogrenciDogumtarihi date (20) not null,
universiteogrenciAdresi varchar (120) not null,
universiteogrenciTelno int (11) not null,
universiteogrenciEvno int (11) not null,
universiteogrenciEmail varchar (50) not null,
universiteogrencikayittarih date (50) not null,
universiteogrencimezuniyettarih date (50) not null,
universiteogrencicalismadurumu varchar (50) not null
constraint PK_universiteogrenci_universiteogrenciNO primary key (universiteogrenciNO),
constraint CK_universiteogrenci_universiteogrenciTc check (universiteogrenciTc Like '[1-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
constraint CK_universiteogrenci_universiteogrenciTelno check (universiteogrenciTelno Like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
constraint CK_universiteogrenci_universiteogrenciEvno check (universiteogrenciEvno Like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
)
go
create table kulupler
(
kuluplerNO int identity,
kuluplerAdi varchar (50) not null,
kuluplerTuru varchar (120) not null,
kuluplerBaskanı varchar (20) not null,
kuluplerbaskanyardımcı varchar (20) not null,
kuluplersayman varchar (20) not null,
kuluplerdanısmangorevli varchar (20) not null,
constraint PK_kulupler_kuluplerNO primary key (kuluplerNO),
)
go
create table kulupuye
(
kulupuyeNO int identity,
kulupuyeTuru varchar (50) not null,
kulupuyekayittarihi date (50) not null,
constraint PK_kulupuye_kulupuyeNO primary key (kuluplerNO),
)
go
create table ogretimgorevlisi
(
ogretimgorevlisiNO int identity,
ogretimgorevlisiAdi varchar (20) not null,
ogretimgorevlisiSoyadi varchar (20) not null,
ogretimgorevlisiEmail varchar (50) not null,
ogretimgorevlisiunvan varchar (50) not null,
ogretimgorevlisiuniversite varchar (50) not null,
ogretimgorevlisifakulte varchar (50) not null,
ogretimgorevlisibolum varchar (50) not null,
constraint PK_ogretimgorevlisi_ogretimgorevlisiNO primary key (ogretimgorevlisiNO),
)
go
create table kulupfaaliyet
(
kulupfaaliyetNO int identity,
kulupfaaliyetAdi varchar (50) not null,
kulupfaaliyetTarihi date (20) not null,
kulupfaaliyetklubu varchar (50) not null,
kulupfaaliyetturu varchar (50) not null,
constraint PK_kulupfaaliyet_kulupfaaliyetNO primary key (kulupfaaliyetNO),
)
go
select * from universite
|
|
Notes is a web-based application for online 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 14 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
