GY6d6JnL

1drop table if exists STUDENTI;
2drop table if exists ORAR;
3drop table if exists CURSURI;
4drop table if exists GRUPE;
5
6create table GRUPE(
7IdGrupa INT AUTO_INCREMENT NOT NULL,
8Grupa VARCHAR(5),
9Facultate VARCHAR(25),
10Specialitate VARCHAR(25),
11PRIMARY KEY (IdGrupa)
12);
13
14create table STUDENTI(
15IdStudent INT AUTO_INCREMENT NOT NULL,
16Nume VARCHAR(25),
17Prenume VARCHAR(25),
18AnNastere SMALLINT,
19CNP VARCHAR(13),
20IdGrupa INT NOT NULL,
21PRIMARY KEY (IdStudent),
22FOREIGN KEY (IdGrupa) REFERENCES GRUPE(IdGrupa)
23);
24
25create table CURSURI(
26IdCurs INT AUTO_INCREMENT NOT NULL,
27NumeCurs VARCHAR(25),
28Profesor VARCHAR(25),
29IdGrupa INT,
30PRIMARY KEY (IdCurs),
31FOREIGN KEY (IdGrupa) REFERENCES GRUPE(IdGrupa)
32);
33
34create table ORAR(
35IdElement INT AUTO_INCREMENT NOT NULL, 
36Ziua VARCHAR(8),
37IntervalOrar VARCHAR(11),
38IdCurs INT NOT NULL,
39PRIMARY KEY(IdElement),
40FOREIGN KEY (IdCurs) REFERENCES CURSURI(IdCurs)
41);
42
43insert into GRUPE (Grupa,Facultate,Specialitate) values
44("111A","Inginerie Electrica","Electrotehnica"),
45("411A","ETTI","Comunicatii"),
46("311CC","Automatica","Calculatoare");
47
48insert into STUDENTI (Nume, Prenume, AnNastere, CNP, IdGrupa) values
49("Ionescu", "Mihai",1990,"1900812892345",1),
50("Popescu", "Liviu",1989,"1890812892323",2),
51("Dornescu", "Titi",1990,"1900812892356",3),
52("Georgescu", "Ionel",1990,"1900709892786",3),
53("Petrescu", "Mihnea",1989,"1890812892341",1);
54
55insert into CURSURI (NumeCurs, Profesor, IdGrupa) values
56("Algebra","A. Nita",2),
57("Metode numerice","M. Rebican",1),
58("Analiza","I. Popescu",3);
59
60insert into ORAR(Ziua, IntervalOrar, IdCurs) values
61("Luni","10.00-12.00",1),
62("Miercuri","12.00-14.00",2),
63("Vineri","08.00-12.00",3);