Solutions Manual for Database Systems: Design, Implementation, and Management, 12th Edition (Coronel/Morris)

!
0112345689 23525
832125325
553
5253
34
122353
"##$%&'()*)
)
+,-./012-34156.789:.;<0=->5?8@.A-41B0C.D-31E1=851<0C.
7<B1=>@-H-05851<0.
.
. A14=?441<0.I<=?4.
.
. J<K.14.8.F858984-.F-41B0.2-31E1-FC.80F.K,6.14.4?=,.2-31E1=851<0.0-=-44836L.
.
.
.
MNO!PQR!SOTUVWOS!UXNYOR!TP!ZQONTVPX![!TP!\P]QN!]WUNN!SVN]QNNVPX!PX!SUTU^UNO!SONV_X!`ORV\V]UTVPXa!bTRONN!
TcUT!TcO!`ORV\V]UTVPX!dRP]ONN!QNON!TcO!VXVTVUW!ef!gPSOW!UN!U!]PggQXV]UTVPX!TPPWa!
!
!
hcO!SONV_XOR!gUi!^O_VX!TcO!`ORV\V]UTVPX!dRP]ONN!^i!SON]RV^VX_!TcO!PR_UXVjUTVPXkN!PdORUTVPXN!TP!VTN!OXS!
QNORNl!^UNVX_!TcO!SOTUVWOS!SON]RVdTVPX!PX!TcO!VXVTVUW!ef!gPSOWa!mOnTl!OndWUVX!cPY!TcO!PdORUTVPXN!YVWW!^O!
NQddPRTOS!^i!TcO!SUTU^UNO!SONV_Xa!bTRONN!TcUT!TcO!SONV_X!gQNT!NQddPRT!TcO!OXSoQNOR!UddWV]UTVPX!`VOYNl!
PQTdQTNl!UXS!VXdQTNa!pPVXTN!TP!^O!USSRONNOS!VX]WQSO!NQ]c!ZQONTVPXN!UNq!
rs
24251532t

3
u 12
24251532 224t
rs2242112234v22w5223t

3
u 12
2234v2
2w522323223442242223442245342w2t

xOOd!VX!gVXS!TcUT!O`OX!U!gPSOW!TcUT!dOR\O]TWi!USSRONNON!UWW!VXVTVUWWi!SOTORgVXOS!OXS!QNOR!ROZQVROgOXTN!
VN!WVyOWi!TP!XOOS!USzQNTgOXTN!UN!TcPNO!OXS!QNORN!^O_VX!TP!QXSORNTUXS!TcO!RUgV\V]UTVPXN!P\!TcO!SUTU^UNO!
SONV_XkN!]UdU^VWVTVONa!{X!gUXi!]UNONl!TcO!OXS!QNORN!gUi!WOURX!YcUT!TcO!PR_UXVjUTVPXkN!dRP]ONNON!UXS!
dRP]OSQRON!U]TQUWWi!UROl!TcQN!WOUSVX_!TP!XOY!ROZQVROgOXTN!UXS!TcO!dOR]OdTVPX!P\!XOY!PddPRTQXVTVONa!hcO!
SUTU^UNO!SONV_XOR!gQNT!yOOd!NQ]c!WVyOWi!SO`OWPdgOXTN!VX!gVXSl!ONdO]VUWWi!V\!|N}cO!YPRyN!UN!U!SUTU^UNO!
SONV_X!]PXNQWTUXTa!|~XTV]VdUTVPX!P\!NQ]c!SO`OWPdgOXTN!gQNT!^O!\U]TPROS!VXTP!TcO!]PXTRU]T!XO_PTVUTVPXN!
\PR!]PXNQWTVX_!\OONa}!
!
!
A14=?44.5,-.3<@-.<E.5,-.4645-H.H<F?@-4.

! 

,!
0112345689 23525
"
832125325
553
5253
34
122353
"
#$%!&'%!()!'*'+%,!,(-&.%'!/01!$02-.*!3%!(4%2%,5$0'67%-!61!0!-0+030'%!-%'681!%1462(1,%1+9!:+2%''!
+$%'%!,(-&.%!/$020/+%26'+6/'!01-!)%0+&2%';!
<=>42212232
24242?2@1522@2225
3424A
<=>4222
B353243415125
52
353C5
2

353245
524
2
3532533

224A
<=>42
5534424253
D 5522545
524344124
32D532AE2245
5532

2
243422

1455
4253234115534221255F2223324A

G(-&.%!61+%2)0/%'!,&'+!3%!/.%02!6)!+$%!,(-&.%'!02%!%H5%/+%-!+(!I(2J!I%..!I6+$61!+$%!(4%20..!'*'+%,9!




! 

,!
0112345689 23525
!
832125325
553
5253
34
122353
"#$%&'$()*(+&,-&%(./&$)-*#$(
(
( 012345(6/$)(7(8*#8&9)/7:(6*;&:(<&(,&'-=-&;>(347)($)&9$(7'&(-#,*:,&;(-#()4&(,&'-=-87)-*#(9'*8&$$>(
(
(
?@A!BACDEDFGHDIJ!IE!G!FIJFAKHLGM!NIOAM!DP!FCLFDGM!HI!G!PLFFAPPELM!OGHGQGPA!OAPDRJS!?@A!BACDEDFGHDIJ!
KCIFAPP!GMMITP!H@A!OAPDRJAC!HI!F@AFU!H@A!GFFLCGFV!IE!H@A!OGHGQGPA!OAPDRJ!QVW!
XYZ2[26535343443
53\
XY]35324253222242532

552325222342^34
2^4253\

_AAK!DJ!NDJO!H@GH`!HI!G!MGCRA!AaHAJH`!H@A!QAPH!OAPDRJ!DP!H@A!IJA!H@GH!PACBAP!H@A!AJObLPAC!
CAcLDCANAJHP!QAPHS!dIC!AaGNKMA`!G!OAPDRJ!H@GH!TICUP!TAMM!EIC!G!NGJLEGFHLCDJR!EDCN!NGV!JIH!EDH!H@A!
JAAOP!IE!G!NGCUAHDJR!CAPAGCF@!EDCN`!GJO!efghiehjklS!
!
!
?@A!BACDEDFGHDIJ!KCIFAPP!@AMKP!H@A!OAPDRJAC!HI!GBIDO!DNKMANAJHGHDIJ!KCIQMANP!MGHAC!QVW!
!
XY5453242^23552\mZ222253542\n
XY83
55323525351342553534152
3322
5112
42
532425351\
XY]5535342434352\
XY
153242^2351255322212232[o41253\
XY83
55322p5223m1253
12
32
25n22\

qACDEDFGHDIJ!DP!G!FIJHDJLILP!GFHDBDHV!DJ!GJV!OGHGQGPA!OAPDRJS!?@A!OGHGQGPA!OAPDRJ!KCIFAPP!DP!
ABIMLHDIJGCV!DJ!JGHLCAW!rH!CAcLDCAP!H@A!FIJHDJLILP!ABGMLGHDIJ!IE!H@A!OABAMIKDJR!NIOAM!QV!AaGNDJDJR!
H@A!AEEAFH!IE!GOODJR!JAT!AJHDHDAP!GJO!QV!FIJEDCNDJR!H@GH!GJV!OAPDRJ!F@GJRAP!AJ@GJFA!H@A!NIOAMsP!
GFFLCGFVS!
!
!
?@A!BACDEDFGHDIJ!KCIFAPP!CAcLDCAP!H@A!EIMMITDJR!PHAKPW!
!
!
!
012t;&#)-=5()4&(;7)7<7$&u$(8&#)'7:(&#)-)51(
(
(
?@A!FAJHCGM!AJHDHV!DP!H@A!NIPH!DNKICHGJH!AJHDHV!DJ!ILC!OGHGQGPA`!GJO!NIPH!IE!H@A!IH@AC!
AJHDHDAP!OAKAJO!IJ!DHS!

! 

, !
0112345689 23525
!
832125325
553
5253
34
122353
!
"#$%&'()*+,-.(&-&'+*('-'./0-12&34'-.(&-*)5-/2162('()5#-
-
-
789!:9;<=>9?!:<@<:9;!A89!:BABCB;9!DE:9F!<>AE!;DBFF9?!;9A;!A8BA!?9GF9HA!A89!:BAB!>99:;!EG!
IB?A<HJFB?!;K;A9D;!DE:JF9;!;JH8!B;!<>@9>AE?KL!E?:9?;L!IBK?EFFL!9AHM!
!
!
N#$%&'()*+,-.(&-&'+*('-'./0-2+-)0'-12&34'O5-6P2/'55'5#-
-
-
QI9H<G<HBFFKL!A8<;!;A9I!?9RJ<?9;!A89!<:9>A<G<HBA<E>!B>:!:9G<><A<E>!EG!A89!:BABCB;9!STUVWUXSYZVW[
A8BA!T\]T\W\VS[A89!DE:JF9^;!?9BF_`E?F:!EI9?BA<E>;M!




!