Encrypted Document with Potential University Connection, Study notes of Principles of Database Management

Download Encrypted Document with Potential University Connection and more Study notes Principles of Database Management in PDF only on Docsity!

 !#"%$&&(')!+*-,/.102$4356&7,8.9&;:$=<(0>!.?!@A0B!(C $<.D!&4,E0F$HGI<,)&JCK,E0L,)',(@!@NM

 OP,E0, ,8.D! @A0>GQ.D!RC $=< 0 L,'&S!E@TM

 U(: V ,E0WU8!V ,E0F$73E@2X

Y

!Z&7,E0F$HG[<-,)&WCQ,E0L,'-,(@!E@,8.D!]$<R@*^$.D!RC_GZ`a.?!&4,E02$7GI<R@cbdV ,E0WUEb

!V ,E0F$73E@TM

^2

8.D! 0 WU8! '-,(@$73 CQ,t0L, @A0W.‘5830J5.?!@+GZ`V ,E0WU8!V ,E0F$73E@TM

z <t0J5^$r02$“’8!Z&;:(”s,<(: •9"–!Z&w&—b˜C!™a<8!RC)š 3 tGI&&H!(3W0F$HG[< G^`V ,E0JU8!Wb

V ,E02$43T,)&QGI'˜›˜!R3W0œ@%3N,)< ')! k.žG[5*)!(C 0 jG6!0JU8!Z.c0>G `ŸGQ.‘V ,

@W$<8k&H! G[' ›˜!R3W x

, ¡¢8£˜M

 !&&¤b†/<NGT"_< !W¥Z,)V *&S!E@–GZn@¦!W0œ@§f.žGIV V ,E0WU8!V ,E0F$73E@¨,8.?!

0 JU8! @!0©GZ§$=<(0>!(6!.ª@ iB{dlE”0WU8! @!W0©GZ«.Ž,E02$7GI<-,&k<5V ')!Z.ª@

i ¬ lE”h,)<8C 0 JU8! @!W0GZ`©.D!N,)&h<5V ')!Z.ª@ i

Y

lEM

z < 3 (GIV *5t0B!.

@3/$4!</3(! GI</! GZ0>!Z< C!N,)&r@ "%$r0JU @!W0A@ GZ @A0W.o$<8Z@ i ,)&r@LG

3 T,)&&H!(C •9`oGK.‘V ,)&®&4,)<8k5,N!@šKl%GQ.¯0J.?!(!E@TM

°±d²³  ²A´ μ ´ ¶  

 | @!0"%$u0WU <NG !&H!V !<(0œ@ $S@ 3 T,)&&S!RC ,<

 ·Qœ¸ ^

M

z 0

$“@ C!Z<NG0>!RC ¹ GQ.»ºW¼/M

z 0 $“@ ½ ¾

M

 À U/! <56V '!.¨GZ%!&H!V !<t0 GZ_, @!0 Á $S@ C!Z<NG0>!RC ÂSÁdÂÃM

! @F,F: ,)&u@G 0 WU8!

^6ÄÆÅÇ

I

G

Z`«ÁdM

 È

¦!W0œ@ 3 T,)< $< -.o$<83/$&H! ')! C!@¦3.o$')!RC 'J: ÉÊS¡t£vÊË/Ì

0 JU8!-$=.Í!Z&S!ZV !Z<t0œ@NM

À U,E0 $“@N”k"–! "_.Ÿ$u0B!

ºÎKÏÐjÑjÑjÑjÐ9Î8Òt¼

0 jG C!<8G0>! 0 JU/! @¦!W0Ó3tGI<T@W$“@j02$<8 GZ`–!&H!V !<(0œ@ÓÎ Ï ÐjÑjÑjÑjÐ9Î Ò M

 | V GQ.?! !Z<8!.Ž,)& V !(3U,)<^$S@V `oGQ.ÍC!E@3.Ÿ$=')$=<8 , @!0 iFÔÕ

ËÊÖ£v¢ ×-Ø+ÊËpÔ6Ë6Êã٢Jl $S@ 0 jG 3 U-,/.,N30>!.Ÿ$“Ú(! ’)$, , Éw×-ÌÊÛtÜ-Éd݄×-؎Õ

Þ ß ÉàÜ , 3 tG[<8Cp$r02$7GI< ij/.DGI)!.„09:l $u0A@ !Z&S!ZV !<t0A@ U-,(’8! 0 jG

@2,E0F$“@j`Ž:pá

ƒKGQ.I!’/!.„:©@!W0âÁ ,)<8C_`oGQ.9V 5 &7,+ãi9Îlc0JU8!Z.D!P!¥)$S@A0œ@

, @!0t”hC!Z<NG0B!(C 'J:

ºÎ ä Á Âoã+i‘Î6lL¼tÐ

0 JU-,E0 3 (GI<R@W$S@A0A@ G^,)&w&®!&H!V !<t0A@ G^]Á `ŸGQ.}"_U^$43U

ã $“@%0J.958!6M

 þ´±Çÿ

 À U/! '-,(@W$43 3 (GI<83R!*t0A@G^`â@!0œ@ 0 JU/!tGQ.ª: ,8.?!

^¦

)<8C 0 WU8!

Ä9
)à ¾

TI ·

M

 À U/! @j:6V ')GI& ä $“@ 3 tGIV V GI<&u: 5 R@¦!(C 0 jG C!<8G0>! 0 WU8!

  Ä9T[Ö· Ä9k
wà

)<8C GI<8! "_.Ÿ$u0B!@ Î ä  0 jG

C!<8G0>!0JU/! /.žG[^G^@W$r02$7GI< Î ÊS¡ Ü-Ë ¢(É¢ Þ ¢RË£#×Ý iŸ"_U^$43U

V ,F: ')! 0 J.‘5/! GK. `9,)&r@!NlEM

z <t0J5^$r02$“’8!Z&;:(” @!W0A@ ,8.?! ½ ¾

hÄÙÅIÄvQÅ 3 tGI&&S!R3W0F$HGI<T@ GZ` G['Eb

›˜!R3W0A@T”]"_U/!.D! 0 JU8! ½

4Ö·
6à G

Z` !Z&S!ZV !<t0A@ )×6Ë4£

Þ

Ü)£˜£Ù¢(ØÆM

I ·


Ð

¼ õ º

Ð

¼WX

Ð

¼ õ º

Ð

Ð

Ð

Ð

JX

Ð

Ð

¼ õ º

Ð

Ð

Ð

¼JX

±  ±   ²±ý  μ  ³ ef 

 gh!W0A@ ,8.?! ½ ¾

hÄÆÅIÄvQÅ 3 tGI&&H!(3W0F$HG[<R@_G^`–!&H!V !<t0A@TM

 Ä9

\GQ. V GK.D! !<8!Z.,)&&u:

«,8.D!

hÄÙÅIÄvQÅ 3 tGI&—b

&S!R3W0F$HGI<T@_GZ`–!Z&S!ZV !<t0A@TM

I ·


i

Ð

l $ S@ , -,^$=. i , 0 J56&S! GZ` &H!</-0JU

ltM

i

Ð

Ð

ÐÆæQl $“@ , 0 J56*&S! GZ`]&H!</-0JU

M

 ÀP5*&H!@GZ`–Cp$“qs!.D!Z<t0 &H!<8-0WUR@ ,8.D! <8!’8!Z.â!k5-,)& M

I ·


i

Ð

l õ  i

Ð

l

Ð

Ð

¼ õ º

Ð

Ð

i

Ð

Ð

l õ  i

Ð

Ð

l

Ð

¼ õ º

Ð

Ð

i

Ð

l õ  i

Ð

Ð

l

±ý´ ³  ±     + $# 

w ¾

 $S@ ,

KÄv a· Ä  ½

W^

G

Z`% ”a"_.o$r0˜0B!<  &  ”

$r $“@ , @5'R@!0ÓGZ ”n'65t0 <NG0Ó!'I5-,)&0>G  M

I ·


Ð

Ð

Ð

¼WX

Ð

Ð

Ð

Ð

¼WX

)  [kÄ9T[Ö· 

Å 

^ Äv
wà

! 3 N,8.D!`˜56&Í,)')GI5t0 0 WU8! Cp$S@A0F$=<8302$7GI< ')!09"–!R!< 0 JU8! !&H!Jb

V !<t0 .D!Z&7,t02$7GI< ,)<8C 0 JU8! @56'R@!W0 .?!&4,E02$7GI<pM

I ·


ä º

Ð

Ð

¼WX

¼ ä º

Ð

Ð

¼WX

Ð

Ð

¼WX

Ð

Ð

¼WX

¼tМº

¼¼JX

¼ ä ºº

¼tМº

¼¼JX

±Ç  ²j μ ±ý´  ° +

,^$=.î@P,)<8C 0 J56&S!E@/.DGZ’^$4C! 5 T@}"%$r0JU ,%",F:_GZ` 3 tG[<[email protected]˜b

$=</ <8!" @!0œ@%`˜.DGIV $r’/!< GI<8!@NM

w ¾

z

` - ,)<8C  ,/.D! @!0œ@T” 0 JU8!Z< 0 JU8!Z.D! !W¥$“@j0œ@ , @!W

 ù  i>.D!N,NC • | 3 .DG^@>@

šKlE”[3T,&w&H!(C 0 JU8!. Ü(ØÆ£Ù¢WÕ

¡WÊàÜË /)ؑ×0 ß Û/£§G^ ,)</C  ”)0WU-,E0©3tGI<R@$“@A0A@ GZÍ,)&&

GQ.DC!Z.D!RC *-,^$=.î@ i 21 Ð9çBlt”p"_U/!.D! 1 ä  ,)<8C ç»ä  M

 gk:V '^G[& $43T,)&&u:t”

ù 

õ ºTi 21 БçBla 31 ä 

ü

ç»ä  ¼tÑ

 ƒKGQ.!¥,)V *&H!6”ý$“` õ º

Ð

¼ ,)</C  õ º

ÐÆæK¼8”I0JU8!Z<

 ù  õ ºTi

Ð

lFÐLi

ÐÆæKl2ÐLi

Ð

l2Ði

ÐÆæQl¼EÑ

´±  ³±ý  ²A´ μ 

0 WU8!.âGI*!.,t02$7GI<R@Ó`oGK.\3tGI<R@j0J.‘5/3W02$<8 @!0œ@ $=<83Z&w5/C!

4 ¡W¢8£^

ß

ËÊw×6Ë i 65 ýl

4 ¡W¢8£PÊË£v¢R؞¡W¢RÛ8£vÊw×6Ë^ i^67 ýl

ؑ¢(ÉwÜ)£ÙÊ 8 W¢¨Ût× Þ /Éw¢ Þ ¢RË£9Ü£vÊw×6Ë iÙGQ.I¡W¢8£"Ê:9®¢Rؑ¢RËÛ(¢l»iAï}l

4 Ût×^

Þ

/pɢ

Þ

¢(Ëp£9Ü)£ÙÊà×6Ë i<;ol

À U/!: ,8.D! C!™a<8!RC ,(@Ó`ŸGI&&“GT"P@NM

 = p!0> ,)<8C  ')! @E5'R@!0œ@GZ`@LGIV! @!0,?M}! C!™a</!6á

 5  õ ºLÎ ä? ÂÎ ä  @ Î ä ]¼

 7  õ ºLÎ ä? ÂÎ ä 

ü

Î ä ]¼

 ï  õ ºLÎ ä? ÂÎ ä 

ü

Î ä ¼

 ; õ ºLÎ ä? ÂÎ ä ¼

{sG0B! 0 WU-,E0+@!W0%Cp$“qs!.?!<83R! 3 T,< ,)&r@LG ')! C!™a<8!RC ,(@%`oGI&—b

&“GN"P@Tá

ï

õ

Ñ

 ƒKGQ.!¥,)V *&H!6”n&H!W

A

')! 0 WU8! @!W0%GZ`].?!T,)&®<65V ')!.î@T”

 0 JU/! @¦!W0 ºLÎ ä ò ÂIï

Óñ Î

B

C

Q¼/”

 0 WU8! @!W0 ºÎ ä ò Â<C B Î

ñ ~ ¼/M

U-,E0,8.D!  5  ”D 7  ”E ï %”Ç,<8C F;oX

 GH  μ  ²f ²j 

M%gh!W0 5 <^$7GI< ,)<8C $!Z.ª@!R3W02$7GI< ,8.?! 3 tGIV V 5 t0L,t02$“’8!6M

M%gh!W0 5 <^$7GI< ,)<8C $!Z.ª@!R3W02$7GI< ,8.?! ,(@>@LGk3-$,t02$“’8!6M

M O $S@A0J.Ÿ$='5(02$“’^$r09:pá 5 i6 7 IPlÍõ i2 5  l"7 i2 5 Il

M O–GI5'6&S! 3 (GIV *&S!ZV !<t0(áiJ ; l ; õ %M

æ®M

z

C6!V *^G0B!<83:páF 7  õ  5  õ %M

K

M O«!

GQ.?Q,)<ML @ =k,F"P@Ná

i 2 5  l ; õ  ; 7  ; ,)<8C i2 7 ©l ; õ  ; 5  ; M

‹®M|¨'[email protected]*t02$7GI<pá N5i2N7O©ldõ  ,)</C N7«iJN5 lâõ %M

μμ ²> P ±ý 

 gh!W0A@Í3T,<GZ`0>!Z< ')!¨3(GI<(’/!<^$4!<t0W&;: .D!Z*/.D!E@!<t0B!(C 'W:>Q

ÅÇSRÇÄÆI 

M

 À U/! 5 6<^$HG[<  5  GZ` ,<8C  $S@ .D!Z*/.D!E@!<t0B!(C 'J:pá

TUTUTUTUTUTUTUTUT

TUTUTUTUTUTUTUTUT

TUTUTUTUTUTUTUTUT

TUTUTUTUTUTUTUTUT

TUTUTUTUTUTUTUTUT

VUVUVUVUVUVUVUVUV

VUVUVUVUVUVUVUVUV

VUVUVUVUVUVUVUVUV

VUVUVUVUVUVUVUVUV

VUVUVUVUVUVUVUVUV

WUWUWUWUWUWUWUWUWUW

WUWUWUWUWUWUWUWUWUW

WUWUWUWUWUWUWUWUWUW

WUWUWUWUWUWUWUWUWUW

WUWUWUWUWUWUWUWUWUW

WUWUWUWUWUWUWUWUWUW

WUWUWUWUWUWUWUWUWUW

XUXUXUXUXUXUXUXUXUX

XUXUXUXUXUXUXUXUXUX

XUXUXUXUXUXUXUXUXUX

XUXUXUXUXUXUXUXUXUX

XUXUXUXUXUXUXUXUXUX

XUXUXUXUXUXUXUXUXUX

XUXUXUXUXUXUXUXUXUX

U

A

B

 À U/! $<t0B!.ª@¦!(3W0F$HG[<  7  $“@ .D!Z*/.D!E@!<(0>!(C 'J:á

YUYUYUYUY

YUYUYUYUY

YUYUYUYUY

YUYUYUYUY

ZUZUZUZUZ

ZUZUZUZUZ

ZUZUZUZUZ

ZUZUZUZUZ

U

A

B

 À U/! @¦!W0ÓCp$“qs!.D!Z<83(!  ï  $“@ .D!Z*/.D!E@!<(0>!(C 'J:á

[U[U[U[U[U[U[U[U[

[U[U[U[U[U[U[U[U[

[U[U[U[U[U[U[U[U[

[U[U[U[U[U[U[U[U[

[U[U[U[U[U[U[U[U[

[U[U[U[U[U[U[U[U[

\U\U\U\U\U\U\U\U\

\U\U\U\U\U\U\U\U\

\U\U\U\U\U\U\U\U\

\U\U\U\U\U\U\U\U\

\U\U\U\U\U\U\U\U\

\U\U\U\U\U\U\U\U\

U

A

B

´ l ±ý   

Sm+Ä9^ à a

z

` n $“@ , @!W0(”ý0WU8!< 0 JU8!Z.D! !¥)$S@A0œ@ , @¦!W0t” 3 N,)&w&H!(C

0 JU8!

Sm+Äv^

G

Z` ,<8C C!Z<NG0>!RC 'J:0JU/!Ó@j:VÓb

'^GI&poi2«lE”)"_UNG^@¦!Ó!Z&S!ZV !<t0A@P,8.?!!W¥,83W0J&u: ,)&w&(0JU8!

@5'R@!0œ@GZ`%M

I ·
k

z

`  $S@+0WU8! @!W0 º

Ð

Ð

¼/”0JU/!<

o _iJ«l õ º2¹TÐ

tÐfº

¼EМº

¼tÐ

Ð

¼tМº

Ð

¼tÐfº

Ð

¼EÐ

Ð

Ð

O–G "–! U-,t’8!

ä oi2«lt”hGQ.

ä oi2«lE” GK.

ä o_iJ«lBX

a

×p”n'!(3T,5R@!

õ º

¼8”®!0>3QM

z

` q U-,(@ é !Z&S!ZV !<t0A@T”sU8GT" V ,)<(: !Z&S!ZV !<t0A@ ,8.D! 0 JU8!Z.D!

$=< $r0œ@ *^GT"–!Z.ª@!0LX

|¨<R@j"–!Z. á

Ò

M» U(:-X

eœ  ²A´ μ 

 r


ww ¾

R@! GQ.DC!Z.D!RC 0 J56&S!E@]0jG .D!-.D!@¦!<t0 .D!&4,E0F$HGI<tb

@U^$*R@ ,)V GI<8 GI' ›f!(30œ@TM

I ·


x •‘¥ $S@», *-,8.?!<t0âGZ`h:+š x

its è2ì2ìvuxwÐÙÁy<z|{}zFlE”pi

A

u~1ÐÆÁ0y2zi{}zFl

x •9¥^ $S@^ , <65V^ ')!.&H!@>@0JU,)<^ :Nš^ x i

Ð

K€

l t”si

K€

Ð

‡K

l

x •˜gk0J58C!Z<t0]<5V ')!Z.I¥ $“@<-,)V !RC : ,)<8C V ,ƛ GK.ª@$=<Útš x

i

~(€^‡K€Z‡‡6‡K

Ð

ts 1 Rì2ö)Ð6IÁE¨lt”6iÙæ

K

æ

K

æ

‡K€€K

Ð

s 1 Rì2ö)ÐÙã«Ád‚+l

x •9¥ $S@ ,)< !’/!< <65V ')!.Dš MªM„Mi

l

 mÇ@>@¦!<t0F$,)&&u:t”-,Ó.D!Z&7,t02$7GI<_$S@ 0 WU8!§@!0sGZ`®,(@>@$7k<6V !Z<t0œ@ "_U)$73ZU

V ,)†2!@ , */.D!RCp$43T,E0B! 0 W.‘58!QM

I ·


x ƒ

w ãf1Rì„z>é€yaõ ºTi6s è2ì2ìvuxwÐÙÁ0y2zi{}zFl2Ði

A

u~1Ð Á0y2z|{}z2l¼

x

z†wUwˆ‡F‰Š1Ré^ õ ºTi^

Ð

K€

l 2ÐLi

K€

Ð

‡K

l L¼

x

s 1 Fêè2ì

é õ ºTi

(€^‡K€Z‡‡6‡K

Ð

s 1 Rì2ö)ЋIÁE¨lFÐ

iÙæ

K

æ

K

æ

‡€ŒK

Ð

ts 1 Rì2ö)ÐÆã«Ád‚lL¼

x ƒ

wU{}z>é õ ºLé Â)é õ

ô¼