- SQL , (, :. SQL). , , . : .
, , , SQL . ( ) , . .
, (, .),: : 1, _2.
SQL " :::= " ( ) ( ); "[ ]" ; " " , , , ; "{ }" , ; "|" , , , ; "< >" , , .
SQL- , :
1.1 STUDENT()
STUDENT_ID | SURNAME | NAME | STIPEND | KURS | CITY | BIRTHDAY | UNIV_ID |
STUDENT_ID - , ( )
SURNAME .
NAME .
STIPEND - .
KURS - , .
CITY - , .
BIRTHDAY - - .
UNIV_ID - , .
1.2. LECTURER ()
LECTURER_ID | SURNAME | NAME | CITY | UNIV_ID |
LECTURER_ID - .
|
|
SURNAME - .
NAME - .
CITY - , .
UNIV_ID - , .
1.3. SUBJECT ( )
SUBJ_ID | SUBJ_ NAME | HOUR | SEMESTER |
SUBJ_ID .
SUBJ_ NAME
HOUR , .
SEMESTER .
UNIV_ID - .
UNIV_N .
RATING - .
CITY - , .
EXAM_ID .
STUDENT_ID - .
SUBJ_ID - .
MARK .
EXAM_DATE - .
.1.6. SUBJ_L ( )
LECTURER_ID -. .
SUBJ_ID - .
1. ?
2. 2 " ?
3. - ? ?
4. ?.