Proiect SGBD - Oracle

A.

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)).