SGBD - Oracle

Profesori

Student

Disciplina

Examene

Baza de date administreaza activitatea unei facultati. Prin intermediul tabelelor descrise mai jos, este tinuta evidenta profesorilor, studentilor, obiectelor de studio si a examenelor.

Tabela "Profesori" contine informatii despre profesori, nume, prenume, adresa si salariul fiecaruia. Tabela "Student" contine informatii despre student precum numele, prenumele, adresa si faptul daca este la taxa sau nu. Tabela "Disciplina" contine informatii referitoare la obiectele de studiu ale studentilor si numarul de credite aferent fiecaruia. Tabela "Examene" ofera informatii despre salile in care se vor tine examenele si notele fiecarui student.

Crearea tabelelor

DROP TABLE PROFESORI CASCADE CONSTRAINTS;

DROP TABLE STUDENT CASCADE CONSTRAINTS;

DROP TABLE DISCIPLINA CASCADE CONSTRAINTS;

DROP TABLE EXAMENE CASCADE CONSTRAINTS;

CREATE TABLE PROFESORI

(idprofesori number(4) CONSTRAINT pk_profesori primary key,

Nume varchar2(15) not null,

Prenume varchar2(15) not null,

Adresa varchar2(30),

Salariu number(4));

CREATE TABLE STUDENT

(idstudent number(4) CONSTRAINT pk_studenti primary key,

Nume varchar2(15) not null,

Prenume varchar2(15) not null,

Adresa varchar2(30),

Taxa varchar2(2) not null

Nrcredite number(2));

CREATE TABLE DISCIPLINA

(iddisciplina number(4) CONSTRAINT pk_disciplina primary key,

Dendisc varchar(20) not null,

Nrcred number(1) not null;

CREATE TABLE EXAMENE

(idexamen number(4) CONSTRAINT pk_examene primary key,

Iddisciplina number(4) not null,

Idstudent number(4) not null,

Idprofesor number(4) not null,

Data date,

Sala varchar2(5) not null,

Nota number(2),

CONSTRAINT FKprofesori FOREIGN KEY (idprofesori) REFERENCES profesori (idprofesori),

CONSTRAINT FKdisciplina FOREIGN KEY (iddisciplina) REFERENCES disciplina (iddisciplina),

CONSTRAINT FKstudent FOREIGN KEY (idstudent) REFERENCES student (idstudent));

Insert into profesori values ('1000','Tudor','Cristian','Str. Dorobantilor nr. 15','4000');

Insert into profesori values ('1001','Marian','Aurel','Str. Barnova nr. 131','3250');

Insert into profesori values ('1002','Vlad','Andrei','Str. Victoriei nr. 23','4800');

Insert into profesori values ('1003','Golondac','Remes','Str. Crizantemelor nr. 22','2100');

Insert into profesori values ('1004','Eminescu','Mihai','Str. Aminitirilor nr. 220','7400');

Insert into profesori values ('1005','Arghezi','Tudor','Str. C.C.Arion nr. 3','5600');

Insert into student values ('2000','Jean','Maximilian','Str. Dinicu Golescu nr. 35 GALATI','DA','50');

Insert into student values ('2001','Nicolae','Filipescu','Str. Gheorghe Doja nr. 44 BRAILA','NU' ,'55');

Insert into student values ('2002','Filimon','Cristi','Str. Constructorilor nr. 21 BUCURESTI','NU' ,'70');

Insert into student values ('2003','Gheorghe','Ionut','Str. Aviatorilor nr. 33 BUCURESTI','DA' ,'30');

Insert into student values ('2004','Catalin','Cristian','Str. 1 Mai nr. 11 GALATI','NU' ,'50');

Insert into student values ('2005','Constantin',' Gabriela','Str. Vasile Milea nr. 15 BRAILA','DA' ,'60');

Insert into disciplina values ('3000','Bazele tehnologiei informatiei','4');

Insert into disciplina values ('3001','Algoritmi in programare','5');

Insert into disciplina values ('3002','Baze de date','6');

Insert into disciplina values ('3003','Contabilitate','5');

Insert into disciplina values ('3004','Microeconomie','5');

Insert into disciplina values ('3005','Analiza','6');

Proiect SGBD - Oracle