Notes
Notes - notes.io |
go
create database OgrenciAnaliz
go
use OgrenciAnaliz
go
create table tblSınıf(kayitNo int primary key identity(1,1), SubeAd varchar(3),Sinif tinyint)
go
create table tblOgrenci(ogrNo int primary key identity(1,1),ogrAdi varchar(50),ogrSoyadi varchar(50), ogrSinifFk int)
go
create table tblDers(dersNo int primary key identity(1,1),dersAdi varchar(25))
go
create table tblDonem(donemNo int primary key identity(1,1),yil varchar(9),donem varchar(8))
go
create table tblSinav(sNo int primary key identity(1,1),dersNoFk int,donemNoFk int)
go
create table tblNotBarem(sBNo int primary key identity(1,1),sNoFk int,soruNo int,puan int,aciklama varchar(50))
go
create table tblYorum(yNo int primary key identity(1,1),yorum varchar(50))
go
create table tblNotlar(kayitNo int primary key identity(1,1),sNoFk int, ogrNo int, soruNo int,puan int)
go
/*alter table tblIs
add constraint fk_Durumlar_isFk foreign key(isDurumFk) references tblDurum(durumNo)
*/
alter table tblNotlar
add constraint fk_Sinifkayit foreign key(sNoFk) references tblSinav(sNo)
go
alter table tblNotlar
add constraint fk_ogr foreign key(ogrNo) references tblOgrenci(ogrNo)
go
alter table tblNotlar
add constraint fk_Soru foreign key(soruNo) references tblNotBarem(sBNo)
go
alter table tblOgrenci
add constraint fk_ogrencisinif foreign key(ogrSinifFk) references tblSınıf(kayitNo)
go
alter table tblSinav
add constraint fk_sinavdonem foreign key(donemNoFk) references tblDonem(donemNo)
go
alter table tblSinav
add constraint fk_SinavDers foreign key(dersNoFk) references tblDers(dersNo)
go
alter table tblNotBarem
add constraint fk_SinavNot foreign key(sNoFk) references tblSinav(sNo)
go
|
|
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
