Solutions Manual for Database Systems: Design, Implementation, & Management (12th Edition) by Carlos Coronel | Complete Chapter Solutions



34456789



!"#$%&

$

#
!"#$'()!)


 "

*



 +
,''#&'$', 
&


-



./01234056780469/:0351;20/5719<51=1>2/>86//47/>2//719194656?6/040/7@9A037=7>65719BC530//
5D655D0A037=7>65719E31>0//2/0/5D07975768FGH14086/6>1HH297>657195118B


ID040/7@903H6J?0@795D0A037=7>65719E31>0//?J40/>37?79@5D013@697K65719L/1E0365719/5175/094
2/03/M?6/79@5D04056780440/>37E5719195D07975768FGH1408BN0O5M0OE8679D1:5D01E0365719/:788?0
/2EE13504?J5D04656?6/040/7@9BC530//5D655D040/7@9H2/5/2EE1355D0094P2/036EE87>65719A70:/M
125E25/M69479E25/BQ1795/51?064430//0479>8240/2>D;20/5719/6/R
STUVWXYZYV[\]^W]_`a[[b\aWYcUd`_WefXaWaV^Y[WV_dWXYZYV[\]^W]_`gbVWhY[_\\Y[WYZc
STi_YVWXYg_ZYjVb^^_\WWXYY`ZkbVY\\Ylb]\YgY`WVcUd`_WefXaWaV^Y[WV_dWXYY`ZkbVY\
\Ylb]\YgY`WVXamY`_WhYY`aZZ\YVVYZ_\XamYhYY`aZZ\YVVYZ]`aZYlbaWYjnc
o00E79H7945D650A096H14085D65E03=0>58J64430//0/68879757688J40503H79040942/0330;2730H095/
7/87p08J51900464q2/5H095/6/5D1/00942/03/?0@795129403/56945D036H7=7>65719/1=5D04656?6/0
40/7@9L/>6E6?787570/Br9H69J>6/0/M5D00942/03/H6J80639:D655D013@697K65719L/E31>0//0/694
E31>04230/6>52688J630M5D2/806479@5190:30;2730H095/6945D0E03>0E57191=90:1EE135297570/BID0
4656?6/040/7@903H2/5p00E/2>D87p08J40A081EH095/79H794M0/E0>7688J7=s/tD0:13p/6/64656?6/0
40/7@9>19/285695Bsu957>7E657191=/2>D40A081EH095/H2/5?0=6>5130479515D0>19536>590@15765719/
=13>19/28579@=00/Bt


"

!
&))
' !v

 1

,


4567869886  976856966 586866869 6688
568697656886768



!"#$%&$'&$%$()%"*%$)% +),$!-)-*-%$. !$#/0.-##$&1'2$3$%1-&$. &$$-%2#4
"(!$&%) !5


!"#$%-&$%$#+63()-2($!-(!-33.'#2%,-%'$32+23%4%)$.+"(3)2(72+%"3,-%4%)$.
+"(3)2(."%)*$. !2+2$!8),$&+"(3)2(%&$.-2("(-++$3)$!5


!"#$%+2)2() -. !"#-&!-)-*-%$!$%29(8:,23,2%. &$$-%2#4. !2+2$!-(!-!-')$!)
($: 32&3".%)-(3$%5;$3-"%$. !2+23-)2($++&)%-&$+3"%$! (-!-)-*-%$%"*%$)8
'&!"3)2<2)4 +*),!$%29($&%-(!-''#23-)2(!$<$#'$&%2%#2=$#4)*$$(,-(3$!5
>976668786656976866?669@9A@6@55696886 




 1

,

3456785 7767545
547
7
7 78
7
575874 7
4 7 78
48755
!"#"$%&%'()%*+*&('*+'",)-(./*0".%1'$-'%(.)*(1-''"11&-.0()(2(1"0"1%3+4!"#"$%&%'()%*+
,$*'"11(..*51)!"0"1%3+"$)*'!"'6)!"(''-$('7*&)!"0()(2(1"0"1%3+278
9:;<=<>?@ABABCD?E??BDD?E?EF?BGHIF@?EAIBGJ
9:KB?LMABCEN<D<GACB<FEI<O?MP?E<EN<D<GACB<HHAQA<BQRF<M?EAO<EIEN<<BDPG<FSG?BD
GRGE<@SGD<GACBCI?MGJ
T"",%+/%+0)!()U)*(.($3""V)"+)U)!"2"1)0"1%3+%1)!"*+")!()1"$#"1)!""+0W-1"$
$"X-%$"/"+)12"1)4Y*$"V(/,."U(0"1%3+)!()5*$615"..&*$(/(+-&(')-$%+3&%$//(7+*)&%))!"
+""01*&(/($6")%+3$"1"($'!&%$/U(+0Z[\]^Z]_`a4


!"#"$%&%'()%*+,$*'"11!".,1)!"0"1%3+"$)*(#*%0%/,."/"+)()%*+,$*2."/1.()"$278

9:b?MAD?EABCEN<@ID<MSG<BEAEA<GJc;<@<@L<FEN<@ABA@?MD?E?FPM<Jd
9:eIBHAF@ABC<BEAERF<M?EAIBGNAfG?BD<MA@AB?EABCDPfMAQ?E<gPBB<Q<GG?FRgIFA@fFIf<FMR
D<HAB<DF<M?EAIBGNAfGJ
9:KMA@AB?EABCD?E?F<DPBD?BQA<GJ
9:h@fFIOABCEN<@ID<MSGG<@?BEAQfF<QAGAIBEIL<EE<FF<fF<G<BEF<?M=iIFMDIf<F?EAIBGJ
9:eIBHAF@ABCEN?E?MMPG<FF<jPAF<@<BEGcfFIQ<GGABCgf<FHIF@?BQ<gIFG<QPFAERd?F<@<EJ
k"$%&%'()%*+%1('*+)%+-*-1(')%#%)7%+(+70()(2(1"0"1%3+4!"0()(2(1"0"1%3+,$*'"11%1
"#*.-)%*+($7%++()-$"8l)$"X-%$"1)!"'*+)%+-*-1"#(.-()%*+*&)!"0"#".*,%+3/*0".27"V(/%+%+3
)!""&&"')*&(00%+3+"5"+)%)%"1(+027'*+&%$/%+3)!()(+70"1%3+'!(+3"1"+!(+'")!"/*0".m1
(''-$('74


!"#"$%&%'()%*+,$*'"11$"X-%$"1)!"&*..*5%+31)",18



n
74
7

57o574874
!"'"+)$(."+)%)7%1)!"/*1)%/,*$)(+)"+)%)7%+*-$0()(2(1"U(+0/*1)*&)!"*)!"$
"+)%)%"10","+0*+%)4

 1

, 


346789 977898878979894






!

"#"#$#
%&'
"&
%#''
"
"#"(')""#"#
&(
*#"
)+'#
,
"%
%&+'

+)#

!"&,-&
-*#,&''-").


/46789 977898887801884


2*)
(
)#'',-"


"*3+

"
"
(
)#"
&#(

"
&&("#"#$#
45678694:;78<
"#"5=>5=8=74<"%&+'?
#'@A&'&*#"
&
.




 1