proiect baze de date -csie

8/18/2019 proiect baze de date -csie

1/22

Gestiune studentilor din cadrul Facultatii de Cibernetica,

Statistica si Informatica Economica

Tema proiectului meu surprinde situatia studentilor apartinand facultatilor de Cibernetica,Statistica siInformatica Economica.Am stocat date in 7 tabele care sunt conectate prin relatii.Datele stocate in aceasta baza de

date se refera la cele 3 sectiuni ale facultatii, seriile din cadrul acestor sectiuni, rupele din cadrul seriilor si ele!ii

apartinand "ecarei rupe, profesorii si materiile pe care le preda "ecare profesor. Intre tabela Facultate si tabele

Studenti e#ista o relatie de tip $%n. Acelsi tip de relatie e#ista intre tabela Grupe, respecti! Serii si Ana&ati. Acest tip

de restrictie asiura faptul ca un student poate aprtine unei sinure facultati'serii'rupe,dar o facultate'rupa'serie

poate a!ea mai multi ana&ati. Intre tabela (aterii si )rofesori e#ista o tabela de leatura , deci o relatie de tipul n%

n. Aceasta relatie asiura faptul ca o materie poate " predata de mai multi profesori iar un profesor poate preda

mai multe materii.

Aceasta baza de date poate " folosita de catre Departamentul de Administratie al facultatilor pentru a tine

e!identa studentilor. )entru "ecare student sunt speci"cate datele personale. Se poate tine e!identa seriilor ,

rupelor pentru studentii "ecare facultati. De asemenea, e#ista e!identa materiilor si a profesorilor care le predau

pentru "ecare serie.

Aplicatia poate " folosita pentru a adaua studenti noi , actualiza datele personale ale ele!ilor,

seria,facultatea sau rupa din care acestia fac parte .De asemenea, aplicatia indica si profesorii care predau intr%o

anumita serie si materiile pe care acestia le predau.E#ista posibilitatea adauarii de noi materii sau actualizarea

celor !ec*i.


2/22

Comenzile pentru crearea tabelelor prezente in sc*ema conceptuala+

CEATE TA-E (ATEII/

ID0(ATEIE 12(-E/4 )I(A5 6E5,

DE12(IE0(ATEIE AC8A/94 4:

Table MATERII created.

CEATE TA-E );FES;I/

ID0);FES; 12(-E/4 )I(A5 6E5,

12(E0);FES; AC8A/94,

)E12(E0);FES; AC8A/944:

Table PROFESORI created.

CEATE TA-E FAC2TATI/

ID_FACULTATE NUMBER (1) PRIMARY KEY,

DENUMIRE_FACULTATE VARCHAR2(50),


3/22

LOCATIE VARCHAR2(50));

Table FACULTATI created.

CEATE TA-E G2)E/

ID0G2)A 12(-E/4 )I(A5 6E5,

DE12(IE0G2)A C8A/


4/22

2.Exempifcarea tili!arii c"me#!ii dr"p a$pra tabelel"r create%

D;) TA-E ST2DE1TI:

Table STUDENTI dr"pped.

D;) TA-E SEII0);FES;I0(ATEII:

Table SERII_PROFESORI_MATERII dr"pped.

D;) TA-E SEII:%%

Table SERII dr"pped.

D;) TA-E );FES;I:

Table PROFESORI dr"pped.

D;) TA-E (ATEII:

Table MATERII dr"pped.

D;) TA-E G2)E:

Table GRUPE dr"pped.

3.E#empli"carea opertiilor DD asupra tabelelor+

%%(;DIFICAE 12(Ele C;;A1EI ,, TI) I1ATA(A1T> I1 ,,I1ATA(A1T>%%

ATE TA-E ST2DE1TI E1A(E C;2(1 I1ATA(A1T T; TI)0I1ATA(A1T:

Table STUDENTI altered.

%%(;DIFICAEA TI)22I C;;A1EI ID0FAC2TATE DI1 DATA DE TI) 12(-E/$4 I1 12(-E/4%%

ATE TA-E FAC2TATI (;DIF5 ID0FAC2TATE 12(-E/4:

Table FA&U'TATE altered.

ATE TA-E ST2DE1TI (;DIF5 ID0FAC2TATE 12(-E/4:


DESC FAC2TATI:

Name Nll T(pe

)))))))))))))))))) )))))))) ))))))))))))

ID_FA&U'TATE NOT NU'' NUM*ER+2,

DENUMIRE_FA&U'TATE -AR&AR2+/0,

'O&ATIE -AR&AR2+/0,

%%ADA2GAEA C;;A1EI DATA01ASTEE A TA-EA ST2DE1TI?

ATE TA-E ST2DE1TI ADD DATA01ASTEE DATE:


5/22



6/22

5 1065

%%I1SEAEA DATE; I1 TA-EA SEII%%

I1SET I1T; SEII

A2ES /$,@A@4:

1 r" i#$erted

I1SET I1T; SEII

A2ES/,@-@4:

1 r" i#$erted

1 A

2 *

%%I1SEAE DATE )ES;1AE I1 TA-EA ST2DE1TI%%

I1SET I1T; ST2DE1TI

A2ES /$,$,$,$,@IIESC2@,@;=A1A@,@F@,@-@,T;0DATE/@9$'9$'$BB@,@DD'(('5555@44:

I1SET I1T; ST2DE1TI

A2ES /,$,$,$,@(AIA@,@(I2@,@F@,@T@,T;0DATE/@9'$'$BB@,@DD'(('5555@44:

I1SET I1T; ST2DE1TI

A2ES /


7/22

/ 1 1 1 E'ENA ENE F * 13)8UN)7/

9 1 1 1 DRAGOS -OI&U M T 01)

8U')7/

3 5 2 2 MIRE' RADOI M T 02)AUG)7/

: 5 2 2 O&TA-IAN *OGA M T 03)SEP)7/

7 5 2 5 IOANA MO&ANU F * 03)8UN)7/

5 1 1 1 Mi;aela Preda F T 20)8AN)19

%%(;DIFICAEA DATE; I1 TA-EA FAC2TATI I C2 ID3%%

2)DATE FAC2TATI SET DE12(IE0FAC2TATE @Statistica economica@ *ere id0facultate3:

1 r" pdated.

%%STEGEEA 21; I1EGISTATI DI1 TA-EA ST2DE1TI,21DE ID0ST2DE1T$%%

DEETE F;( ST2DE1TI H8EE ID0ST2DE1T$:

1 r" deleted.

%%I1SEAEA DATE; I1 TA-EA );FES;I %%

I1SET I1T; );FES;I

A2ES /$,@)2I2@,@6AI1A@4:

1 r" i#$erted.

I1SET I1T; );FES;I

A2ES /,@(AIA@,@);)ESC2@4:

1 r" i#$erted.

I1SET I1T; );FES;I

A2ES /3,@I;1@,@DECE-A@4:

1 r" i#$erted.

I1SET I1T; );FES;I

A2ES /


8/22

I1SET I1T; (ATEII

A2ES /$,@)robabiliatati@4:

1 r" i#$erted.

I1SET I1T; (ATEII

A2ES/,@-aze de date@4:

1 r" i#$erted.

I1SET I1T; (ATEII

A2ES/3,@Economie@4:

1 r" i#$erted.

I1SET I1T; (ATEII

A2ES/


9/22

1 r" i#$erted.

%%.E=E()E DE I1TE;GAI )E TE(A AEASA%%

%%AFISAEA FAC2TATI; CAE C;1TI1 I1 DE12(IEA ; ,,CI-E1ETICA>%%

SEECT F;( FAC2TATI H8EE DE12(IE0FAC2TATE I6E @Cibernetica@:

1 &iber#etica Ec"#"mica &alea D"r"ba#til"r 1/)13

%%2TIIJAEA 2I 1;T 12 I1T%; C;(A1DA I1 CAE SE CEE AFISAEA ST2DE1TI; CAE A2 C;()ETATA

DATA DE 1ASEE%%

SEECT F;( ST2DE1TI H8EE DATA01ASTEE IS 1;T 12:

2 1 1 1 MARIA MIU F T 02)FE*)7/

6 1 1 1 MARIANADRAGI&I M * 02)8UN)7/

/ 1 1 1 E'ENA ENE F * 13)8UN)7/

9 1 1 1 DRAGOS -OI&U M T 01) 8U')7/

3 5 2 2 MIRE' RADOI M T 02)AUG)7/

: 5 2 2 O&TA-IAN *OGA M T 03)SEP)7/

7 5 2 5 IOANA MO&ANU F * 03)8UN)7/

%%E=E()2 DE I11E K;I1 I1TE TA-EA ST2DE1TI SI TA-EA FAC2TATI%%

%%AFISAEA ST2DE1TI; CAE S21T A CI-E1ETICA EC;1;(ICA%%

SEECT 12(E,)E12(E,DE12(IE0FAC2TATE

F;( FAC2TATI F ,ST2DE1TI S

H8EE S.ID0FAC2TATEF.ID0FAC2TATE

A1D DE12(IE0FAC2TATE@Cibernetica Economica@:

12(E )E12(E DE12(IE0FAC2TATE

%%%%%%%%%% %%%%%%%%%% %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

MARIA MIU &iber#etica Ec"#"mica

MARIANA DRAGI&I &iber#etica Ec"#"mica

E'ENA ENE &iber#etica Ec"#"mica

DRAGOS -OI&U &iber#etica Ec"#"mica

%%E=E()2 DE K;1CTI21E ;2TE K;I1 I1TE FAC2TATI SI ST2DE1TI%%

%%AFISAEA FAC2TATI; SI A ST2DE1TI;,I1C2SI A FAC2TATI; CAE 12 A2 ATASAT

ST2DE1TI %%

SEECT DE12(IE0FAC2TATE,)E12(E


10/22

F;( FAC2TATI F ,ST2DE1TI S

H8EE F.ID0FAC2TATE S.ID0FAC2TATE/L4:

DENUMIRE_FA&U'TATE PRENUME

)))))))))))))))))))))))))))))))))))))))))))))))))) ))))))))))

&iber#etica Ec"#"mica MIU

&iber#etica Ec"#"mica DRAGI&I

&iber#etica Ec"#"mica ENE

&iber#etica Ec"#"mica -OI&U

Stati$tica ec"#"mica RADOI

Stati$tica ec"#"mica *OGA

Stati$tica ec"#"mica MO&ANU

I#4"rmatica Ec"#"mica

%%E=E()IFICAEA 2I G;2) -5,12(AAEA ST2DE1TI; DI1T%; G2)S %%

SEECT DE12(IE0G2)A ,C;21T/ID0G2)A4 AS 12(A

F;( SEII K;I1 ST2DE1TI 2SI1G /ID0SEIE4

K;I1 G2)E 2SI1G /ID0G2)A4

G;2) -5 /DE12(IE0G2)A4

DENU NUMAR

)))) ))))))))))

1062 2

1061 6

1065 1=

))UTI'I>AREA FUN&TII'OR 'A NI-E' DE RAND))

%%2TIIJAEA 2I CASE M

%%AFISAEA ST2DE1TI; D2)A 2(AT;I2 CITEI2+ DACA ST2DE1TII A2 SE=F '( SE A I1C;C2I C2

FE(I1I1'(ASC2I1%%

SEECT 12(E,)E12(E,CASE SE=

H8E1 @F@ T8E1 @Feminin@

ESE @(asculin@

E1D AS SE=

F;( ST2DE1TI=


11/22

NUME PRENUME SE?

)))))))))) )))))))))) ))))))))

MARIA MIU Femi#i#

MARIANA DRAGI&I Ma$cli#

E'ENA ENE Femi#i#

DRAGOS -OI&U Ma$cli#

MIRE' RADOI Ma$cli#

O&TA-IAN *OGA Ma$cli#

IOANA MO&ANU Femi#i#

%%2TIIJAEA F21CTIEI DE A1D T;0DATE ?

%%ACT2AIJAEA DATEI DE 1ASTEE A ST2DE1T22I C2 ID%

2)DATE ST2DE1TI SET DATA01ASTEE T;0DATE/@9'FE-'$BB@,@DD'(;1'5555@4 H8EE ID0ST2DE1T:

1 r" pdated.

%%2TIIJAEA F21CTIEI E=TACT%

%AFISAEA 21II SI A A122I I1 CAE S21T 1ASC2TI ST2DE1TII C2 ID,3 SA2


12/22

02)AUG)177/

03)SEP)177/

03)8UN)177/

%%2TIIJAEA F21CTIEI T;0C8A A 1IE2 TA-EE ST2DE1TI %%%

SEECT T;0C8A /DATA01ASTEE,@DA5'(;1T8'5EA@4 F;( ST2DE1TI:

TO_&AR+DATA_NASTERE@DABCMONTCBEAR,

))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

TURSDAB CFE*RUARB CNINETEEN NINETB)FI-E

FRIDAB C8UNE CNINETEEN NINETB)FI-E

SATURDAB C8UNE CNINETEEN NINETB)FI-E

SATURDAB C8U'B CNINETEEN NINETB)FI-E

EDNESDABCAUGUST CNINETEEN NINETB)FI-E

TURSDAB CSEPTEM*ERCNINETEEN NINETB)FI-E

EDNESDABC8UNE CNINETEEN NINETB)FI-E

%%2TIIAEA F21CTII; DE A1D S2-ST,2))E,;HE,E1GT8?

%%SA SE AFISEJE 21GI(EA 12(E2I,CAACTEEE DE )E );JITIA SI 3 DI1 12(E , 12(EE SCIS C2 (AK2SC2E

SI 12(EE SCIS C2 ITEE (ICI%%

SEECT E1GT8/12(E4,S2-ST/12(E,,4,upper/nume4,loer/nume4

F;( ST2DE1TI:

'ENGT+NUME, SU*STR+2@2, UPPER+NUME , 'OER+NUME

))))))))))))))))))))))))))))))))))))))) )) )))))))))) ))))))))))

/ AR MARIA maria

3 AR MARIANA maria#a

/ 'E E'ENA ele#a

9 RA DRAGOS dra"$

/ IR MIRE' mirel

: &T O&TA-IAN "ctaia#

/ OA IOANA i"a#a

3 i; MIAE'A mi;aela

%%2TIIJAEA 2I DEC;DE?

%%AE ACEASI 2TIIJAE CA SI CASE,DIFEA D;A SI1TA=A%%

SEECT DEC;DE/SE=,@F@,@FE(I1I1@,@(@4 AS SE=


13/22

F;( ST2DE1TI:

SE=

%%%%%%%

FEMININ

M

FEMININ

M

M

M

FEMININ

FEMININ

%%2TIIJAEA F21CTII;T 1%%

%%2TIIJAEA 2I 12IF?

%%SA SE AFISEJE ST2DE1TII CAE A2 12(EE EGA C2 )E12(EE?

SEECT ID0ST2DE1T, 12IF/12(E,)E12(E4 F;( ST2DE1TI:

ID_STUDENT NU''IF+NUM

)))))))))) ))))))))))

2 MARIA

6 MARIANA

/ E'ENA

9 DRAGOS

3 MIRE'

: O&TA-IAN

7 IOANA

5 Mi;aela

%%2TIIJAEA 2I 1?

%% SE D;ESTE ACT2AIJAEA TA-EEI ST2DE1TI,)E1T2 ST2DE1TII CAE 12 A2 C;;A1A SE= C;()ETATA SE

A C;()ETA C2 ,,1'A>%%

SEECT 12(E,)E12(E, 1/SE=,@1'A@4 F;( ST2DE1TI:

ID_STUDENT NU''IF+NUM


14/22

)))))))))) ))))))))))

2 MARIA

6 MARIANA

/ E'ENA

9 DRAGOS

3 MIRE'

: O&TA-IAN

7 IOANA

5 Mi;aela

%%2TIIJAEA ;)EAT;I; 21I;1,(I12S,I1TESECT%%

))SE'E&TAREA STUDENTI'OR &ARE SUNT 'A *UGET))

SEECT F;( ST2DE1TI H8EE TI)0I1ATA(A1T I1 /@-@,@T@4

(I12S

SEECT F;( ST2DE1TI H8EE TI)0I1ATA(A1T I1 /@T@4:


/ 1 1 1 E'ENA ENE F * 13)8UN)7/

7 5 2 5 IOANA MO&ANU F * 03)8UN)7/

%%2TIIJAE 2I 21I;1%%

%%AFISAEA ST2DE1TI; CAE S21T A FAC2TATEA DE STATISTICA SI A CE; CAE S21T A FAC DECI-E1ETICA%%

SEECT F;( ST2DE1TI S ,FAC2TATI F

H8EE S.ID0FAC2TATE F.ID0FAC2TATE A1D DE12(IE0FAC2TATE@Cibernetica Economica@

21I;1

SEECT F;( ST2DE1TI S ,FAC2TATI F

H8EE S.ID0FAC2TATE F.ID0FAC2TATE A1D DE12(IE0FAC2TATE@Statistica Economica@:


/ 1 1 1 E'ENA ENE F * 13)8UN)7/

7 5 2 5 IOANA MO&ANU F * 03)8UN)7/

%%2TIIJAEA ;)EAT;I; DE C;()AATIE N,O%%

%%AFISAEA ST2DE1TI; 1ASC2TI D2)A 9$'9$'$BB%%

SEECT F;( ST2DE1TI H8EE T;0C8A/DATA01ASTEE,@DD'(('5555@4 O @9$'9$'$BB@


15/22

A1D T;0C8A/DATA01ASTEE,@DD'(('5555@4 O @9$'9$'$BB@:

2 1 1 1 MARIA MIU F T 02)FE*)7/

5 1 1 1 Mi;aela Preda F T 20)8AN)19

%%E=E()IFICAEA S2-CEEI; SI()E SI C;EATE%%

SEECT 12(E,)E12(E,TI)0I1ATA(A1T

F;( ST2DE1TI

H8EE TI)0I1ATA(A1T I1 /SEECT TI)0I1ATA(A1T F;( ST2DE1TI H8EE

2))E/12(E4@(AIA@4:

Mi;aela Preda T

O&TA-IAN *OGA T

MIRE' RADOI T

DRAGOS -OI&U T

MARIA MIU T

%%AFISAEA 12(E,)E12(E ,TI)0I1 )E1T2 ST2DE1TII CAE FAC )ATE DI1 SEIA A%%

SEECT 12(E,)E12(E,TI)0I1ATA(A1T F;( ST2DE1TI S,SEII S

H8EE S.ID0SEIES.ID0SEIE

A1D TI)0I1ATA(A1T I1 /SEECT TI)0I1ATA(A1T F;( ST2DE1TI H8EE DE12(IE0SEIE@A@4:

MARIA MIU T

MARIANA DRAGI&I *

E'ENA ENE *

DRAGOS -OI&U T

(i*aela )reda T

%%CEATE'I1SET'2)DATE'DEETEL SEECT%%

%%SE D;ESTE CEAEA 212I TA-E 12(IT ISTI1G0ST2DE1TI CAE SA C;1TI1A C;;A1EE

DE12(IE0FAC2TATE,DE12(IE0SEIE,DE12(IE0G2)A,ID0ST2DE1T C;1CATE1ATE DI1 )AT2

TA-EE ST2DE1TI,FAC2TATI,G2)E SI SEII%%

CEATE TA-E ISTI1G0ST2DE1TI

AS/ SEECT DE12(IE0FAC2TATE,DE12(IE0SEIE,DE12(IE0G2)A,ID0ST2DE1T,

12(E,)E12(E F;( ST2DE1TI S K;I1 FAC2TATI F

2SI1G /ID0FAC2TATE4K;I1 G2)E 2SI1G /ID0G2)A4K;I1 SEII 2SI1G/ID0SEIE44:

Table 'ISTING_STUDENTI created.


16/22

))SE D;ESTE STEGEEA DI1 TA-E2 CEAT (AI S2S A ST2DE1TI; CAE A)ATI1 FAC2TATII DE

STATISTICA EC;1;(ICA%%

DEETE F;( ISTI1G0ST2DE1TI H8EE ID0ST2DE1T I1 /SEECT ID0ST2DE1T

F;( ST2DE1TI S, FAC2TATI F H8EE S.ID0FAC2TATEF.ID0FAC2TATE

A1D DE12(IE0FAC2TATE@Statistica economica@4 :

5 r"$ deleted.

))SE D;ESTE ACT2AIJAEA C;;A1EI 12(E DI1 TA-E22I DE (AI S2S )E1T2 ST2DE1T2 C2

ID$

2)DATE ISTI1G0ST2DE1TI

SET 12(E /SEECT 12(E F;( ST2DE1TI H8EE ID0ST2DE1T$4

H8EE ID0ST2DE1T$:

0 r"$ pdated.

%%E=E()IFICAEA 2I (EGE )E TA-EA ISTI1G0ST2DE1TI%%

(EGE I1T; ISTI1G0ST2DE1TI

2SI1G ST2DE1TI S

;1/S.ID0ST2DE1T.ID0ST2DE1T4

H8E1 (ATC8ED T8E1 2)DATE SET .12(ES.12(E

H8E1 1;T (ATC8ED T8E1 I1SET/12(E,)E12(E4 A2ES/ S.12(E,S.)E12(E4:

SEECT F;( ISTI1G0ST2DE1TI:

: r"$ mered.

%%TA-EE I2AE,I1ECSI,SECE1TE,SI1;1I(E

%%SE D;ESTE CEAEA 212I IEH CAE SA C;1TI1A 12(EE ,)E12(EE SI ID%2 )E1T2 ST2DE1TII CAE

S21T A -2GET%%

CEATE IEH ST2DE1TI0STATISTICA AS

SEECT 12(E,)E12(E,ID0ST2DE1T F;( ST2DE1TI

H8EE TI)0I1ATA(A1T@-@:

-ie STUDENTI_STATISTI&A created.

))SE D;ESTE ACCESAEA A)IDA A C;;A1E; 12(E,)E12(E DI1 TA-EA ST2DE1TI%%

CEATE I1DE= 12(E0)E12(E0ST2DE1TI ;1 ST2DE1TI/12(E,)E12(E4:

I#dex NUME_PRENUME_STUDENTI created.

))SE D;ESTE CEAEA 21EI SECE1TE C2 12(EE IS0STD )E1T2 TA-EA ISTI1G0ST2DE1TS%%


17/22

CEATE S51;15( IS0STD F; ISTI1G0ST2DE1TS:

%%SE D;ESTE CEAEA 212I SSI1;1I( )E1T2 12(EE TA-EEI ISTI1G0ST2DE1TS%%

S(#"#(m 'IS_STD created.

CEATE SEP2E1CE SEP

STAT HIT8 $

I1CE(E1T -5 $

1;CAC8E

1;C5CE:

See#ce SEH created.

))?M'))

SEECT =(Element/QFAC2TATEQ, =(A/=(Element/QST2DE1TIQ,

F.DE12(IE0FAC2TATERR@ @RR S.12(E4

;DE -5 DE12(IE0FAC2TATE44

AS QDE10FACQ

F;( ST2DE1TI S,FAC2TATI F

H8EE S.ID0FAC2TATE F.ID0FAC2TATE :

DE10FAC

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

NFAC2TATEONST2DE1TIOCibernetica Economica (AIAN'ST2DE1TIONST2DE1TIOCibernetica


18/22


19/22


20/22


21/22


22/22

Date post:	07-Jul-2018
Category:	Documents
Upload:	roxanailiescu
View:	354 times
Download:	0 times

proiect baze de date -csie

Documents