UniversityStudentAnalysis/proje.sql at main · bersoy12/UniversityStudentAnalysis · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
CREATE TABLE sehirler (
    sehir_id   INT(5) PRIMARY KEY,
    sehir_adi  VARCHAR2(45)
);

CREATE TABLE universiteler (
    uni_id    INT(5) PRIMARY KEY,
    uni_adi   VARCHAR2(60),
    sehir_id  INT(5),
    FOREIGN KEY ( sehir_id )
        REFERENCES sehirler ( sehir_id )
);

CREATE TABLE bolumler (
    program_id   INT(11) PRIMARY KEY,
    program_adi  VARCHAR2(100),
    uni_id       INT(5),
    FOREIGN KEY ( uni_id )
        REFERENCES universiteler ( uni_id )
);

CREATE TABLE kacinci_tercih (
    program_id       INT(11),
    tercih_sirasi    INT(11),
    yerlesen_sayisi  INT(11),
    FOREIGN KEY ( program_id )
        REFERENCES bolumler ( program_id )
);

CREATE TABLE geldikleri_iller (
    program_id       INT(11),
    sehir_id         INT(5),
    yerlesen_sayisi  INT(11),
    FOREIGN KEY ( program_id )
        REFERENCES bolumler ( program_id ),
    FOREIGN KEY ( sehir_id )
        REFERENCES sehirler ( sehir_id )
);

CREATE TABLE universite_tercihleri (
    program_id          INT(11),
    tercih_eden_sayisi  INT(11),
    FOREIGN KEY ( program_id )
        REFERENCES bolumler ( program_id )
);

CREATE TABLE genel_bilgiler (
    program_id                 INT(11),
    fakulte_adi                VARCHAR2(50),
    puan_turu                  VARCHAR2(11),
    burs_turu                  VARCHAR2(50),
    genel_kontenjan            INT(11),
    okul_birincisi_kontenjani  INT(11),
    toplam_yerlesen            INT(11),
    bos_kontenjan              INT(11),
    ilk_yerlesme_orani         DECIMAL(5,2),
  yerlesip_kayit_yaptirmayan INT(11),
  ek_yerlesen INT(11),
  ort_obp DECIMAL(6,3),
  ort_diploma_notu DECIMAL(4, 2),
  FOREIGN KEY ( program_id )
        REFERENCES bolumler ( program_id )
);