, - , -, . , . . . , , . , , , .
, . - - 1:N.
, . . . - ( ) . : .
, .
;
;
;
;
;
;
;
;
. .
. .
, , . , .
8. . .
, : ,
|
|
, , .
" - " . - "" . .
, . . .
: .
9. - (ER-). ER-.
ER- () . , .
. , . .
. , .
10. - .
:
. :
, (, . .)
, ..
, . .
() (). . , .
1.
2. . - ( ), .
3. , .
4. . , . .
:
-
11. . .
. . , . .
. . , , , .
. . ( ).
1. . . .
|
|
2. . , .. , . .
3. . PK - . , , .
4. . . , .
5. , . .
6. (FK) , , .
. :
1) . , .
2)
3)
4)
12. 3 .
- . , , .
. -, . , . - NULL ( , =,>=) unknown.
3 :
true and unknown =unknown
false and unknown = false
NOT (unknown)=unknown
. . - 2 3 :
1) , , -
2) 3 . - .
3 . .
13. .
:
1) , . . .
2). .
:
1) , 2) , 3) -
, , .
. - 2 .
1 : - .
1 , --- 1 . 3 , 2 . . . , , , .
2 :
1) . 0
2) ,
3) , , , , .
. , .
2 , . . . .
-------------
. ,
. .
1 .
|
|
14. 4
, , . .
, , , , .
:
1) , ,
2) , . , :
1. , 2. ( - - , , ) 3. ( emp_NUm 102, )
: , ,
15. - , 14 .
.. , . , . , .
1. , . - .
2. . .
3. : . . . , ;
1 .. :
1.
2. . ( . )
3.
16. . 15-14
2 . . , , , , . , , - . : 2NF , .
1. . . , . . .
Prog_Num
Emp_Num
Prog_num, Emp_num
2. . , . 3 : Project, Employer, assign
3. Project (Proj_num, Proj_name)
Employer (Emp_num, Emp_name, job_class, chg_hour)
assign (proj_num, emp_num, assign_hour)
4. .. - , . , . assign proj_num, emp_num, . assign assign_hour
2 , :
1. 1 . -, .
17. 3
2 ., . . job_class .
|
|
Project (Proj_num, Proj_name)
Employer (Emp_num, Emp_name, job_class (FK))
assign (proj_num, emp_num, assign_hour)
Job (job_class, chg_hour)
3 , . 2
. , .
1) , Job_code . job . , . . . Employer Job_code
Job (Job_code, job_class, chg_hour)
2) , Emp_name, . , . .
.
4 , , . .
18.
, - -, . ., , ,
3- >2
. . 2 . , .
, . :
1. -
2.
3.
19.
. , ,
- , . . ( , )
: , 1 , .. > 5 <2.
- . :
.
.
(.. ).
:
, .
, , .
, . , , () .
:
1.
2. ( )
20. 19
.
.
.
(DDL - Data Definition Language). ( ) , ( ) ( ). DDL (ASSERTION).
. , ( , ) , . , .
, . , :
1. () , , .
|
|
2. , .