Coding in Mathematics. (MAT 122) _3.pdf

This comprehensive guide delves into the fundamental concepts of the Relational Model and Relational Algebra, the cornerstone of modern relational database management systems. The book provides an in-depth exploration of the Relational Model, its components, and the mathematical foundations of Relational Algebra.

11.
:
&5!/*'@ ' 2@ 4@ @ 4!@ /1 35 /34
#
!'!





( !
!

(+ $
$(&+ "#
! )(
: 5 3@ /135
/34@ *@ @ " * @ 64!*@ 5 4@
!*5345!/*@ $/!*@ "8"4!/*
: @ 746'@ 49*5
5!@ /135/3@ 3 *)!*

13. Projection
13

14.
( ")!) # ') ) ") !) ) ")
!) "
( ") &")








( ") "# !) ) &) ") ""
"!) ') ") #!)

) )

) "
) "
( $"#") ") !) ") %) )

17. 17
Selection

29. Union
29

33. Set Difference
33

38. Cartesian Product
(Cross Product)
38

56. *%2*% 9 *% 9
8 9 +'3+'!9 +'9 19 39 +/$3

609 19 9 ,(3+(9 19 )9 9 1"39
8 19 7-/11+'9 19 .45!'39 3+

58.
#
$ $ $ $ $ $ !$ $
$ $ $ !$
# $ $ $ $ $ $ "$ $ $
$ $ $ $ $ $ $ $ $
$ "
# $ $ $ $ $ $ $
$ "$ $ $ $ $
$ $ $

62.




Natural Join

63. ,
*# 0





/


%0&(+0 &0
%0 %0


,
(%&"0
&0 %0 0


0 0
)0 "0 ""0 %0 J$0
, (%&"0 &0 %0 0


0 0
'0 %0 %0 0 .!

Natural Join

78.


%#)#
*#

& *(. $%#+*
#
*. &