Solutions manual for database systems design implementation and management 12th edition by coronel All Chapters 1-16

!
0112345689 23525
832125325
553
5253
34
122353
"##$%&'()*)
)
+,$)-%'.$/0'12)3456)*7%8$#194:);$0'<%=)>$/'?'841'7%=)
37<'84:);$0'<%=)4%&)@A#:$A$%141'7%)
)
) ;'08900'7%)B7890)
)
) C7D)'0)4)&414540$)&$0'<%).$/'?'$&=)4%&)D,2)'0)098,).$/'?'841'7%)%$8$004/2E)
)
))
FGHIJKLIMHNOPQHMIORGSHLINJITKHGNPJRIUINJIVJWKGIWQOGGIMPGWKGGPJRIJRIMONOXOGHIMHGPYRIZHLPVPWONPJR[I\NLHGGIN]ONIN]HI
ZHLPVPWONPJRI^LJWHGGIKGHGIN]HIPRPNPOQI_`IaJMHQIOGIOIWJaaKRPWONPJRINJJQ[I
I
I
b]HIMHGPYRHLIaOcIXHYPRIN]HIZHLPVPWONPJRI^LJWHGGIXcIMHGWLPXPRYIN]HIJLYORPdONPJReGIJ^HLONPJRGINJIPNGIHRMIKGHLGfIXOGPRYI
N]HIMHNOPQHMIMHGWLP^NPJRIJRIN]HIPRPNPOQI_`IaJMHQ[IgHhNfIHh^QOPRI]JSIN]HIJ^HLONPJRGISPQIXHIGK^^JLNHMIXcIN]HIMONOXOGHI
MHGPYR[I\NLHGGIN]ONIN]HIMHGPYRIaKGNIGK^^JLNIN]HIHRMiKGHLIO^^QPWONPJRIZPHSGfIJKN^KNGfIORMIPR^KNG[IjJPRNGINJIXHI
OMMLHGGHMIPRWQKMHIGKW]ITKHGNPJRGIOGkI
lmnGIN]HIMHGWLP^NPJRIOWWKLONHoInVIRJNfIS]ONIOG^HWNGIJVIN]HIMHGWLP^NPJRIaKGNIXHIWJLLHWNHMoI
lmpJHGIN]HIaJMHQIGK^^JLNIN]HIHRMiKGHLILHTKPLHaHRNGoInVIRJNfIS]ONIOG^HWNGIJVIN]HIHRMiKGHLI
LHTKPLHaHRNGI]OZHIRJNIXHHRIOMMLHGGHMIJLI]OZHIXHHRIOMMLHGGHMIPROMHTKONHQcoI
I
qHH^IPRIaPRMIN]ONIHZHRIOIaJMHQIN]ONI^HLVHWNQcIOMMLHGGHGIOQIPRPNPOQcIMHNHLaPRHMIHRMIKGHLILHTKPLHaHRNGIPGIQPrHQcINJI
RHHMIOMsKGNaHRNGIOGIN]JGHIHRMIKGHLGIXHYPRINJIKRMHLGNORMIN]HILOaPVPWONPJRGIJVIN]HIMONOXOGHIMHGPYReGIWO^OXPQPNPHG[InRI
aORcIWOGHGfIN]HIHRMIKGHLGIaOcIQHOLRIS]ONIN]HIJLYORPdONPJReGI^LJWHGGHGIORMI^LJWHMKLHGIOWNKOQcIOLHfIN]KGIQHOMPRYINJI
RHSILHTKPLHaHRNGIORMIN]HI^HLWH^NPJRIJVIRHSIJ^^JLNKRPNPHG[Ib]HIMONOXOGHIMHGPYRHLIaKGNIrHH^IGKW]IQPrHQcI
MHZHQJ^aHRNGIPRIaPRMfIHG^HWPOQcIPVItGu]HISJLrGIOGIOIMONOXOGHIMHGPYRIWJRGKQNORN[ItvRNPWP^ONPJRIJVIGKW]IMHZHQJ^aHRNGI
aKGNIXHIVOWNJLHMIPRNJIN]HIWJRNLOWNIRHYJNPONPJRGIVJLIWJRGKQNPRYIVHHG[uI
I
I
;'08900)1,$)/7:$)7?)1,$)0201$A)A7&9:$0w)



! 

,!
0112345689 23525
"
832125325
553
5253
34
122353
"
#$%&'(%&)*&(+(,%-&-).'/%(&012&$13./+&4%&)5%3%-6$1(78%.&72&1&.1,141(%&.%(792&%2573)2-%2,:&;,3%((&,$%(%&
-).'/%&0$1310,%37(,70(&12.&*%1,'3%(<&
=>?).'/%(&3%63%(%2,&('4(%,(&)*&,$%&.1,141(%&-).%/<&;-1/%3&@67%0%(@&13%&-)3%&%1(7/+&'2.%3(,)).:&
=>?).'/%(&13%&(%/*A0)2,172%.&12.&100)-6/7($&1&(6%07*70&(+(,%-&*'20,7)2B&7*&('0$&1&(+(,%-&*'20,7)2&
-'(,&4%&-).7*7%.C&),$%3&*'20,7)2(&3%-172&'21**%0,%.:&
=>?).'/%(&*7,&72,)&1&-).'/13&.1,141(%&.%(792C&D$70$&7(&-)3%&%1(7/+&-).7*7%.&12.&1.16,%.&,)&2%D&
0730'-(,120%(:&E%01'(%&-).7*701,7)2&%**)3,(&13%&*)0'(%.&)2&1&.1,141(%&('4(%,C&63).'0,757,+&)*&4),$&
.%(792%3(&12.&166/701,7)2&.%5%/)6%3(&7(&/7F%/+&,)&4%&%2$120%.:&
&
?).'/%&72,%3*10%(&-'(,&4%&0/%13&7*&,$%&-).'/%(&13%&%G6%0,%.&,)&D)3F&D%/&D7,$72&,$%&)5%31/&(+(,%-:&




! 

,!
0112345689 23525
"
832125325
553
5253
34
122353
#$%&'(%)*+),'-.'&)/0'%*.+$%)
)
) 123456)70%*)8)9+$9':*08;)7+<';)=')-'(.>.'<?)458*)%*':%)8(').$-+;-'<).$)*5')-'(.>.98*.+$):(+9'%%?)
)
)
@AB"CBDEFEGHIEJK"JF"H"GJKGBLIMHN"OJPBN"EQ"GDMGEHN"IJ"H"QMGGBQQFMN"PHIHRHQB"PBQESKT"@AB"CBDEFEGHIEJK"LDJGBQQ"HNJUQ"
IAB"PBQESKBD"IJ"GABGV"IAB"HGGMDHGW"JF"IAB"PHIHRHQB"PBQESK"RWX"
YZ[B\B]HOEKEKS"PHIH"HKP"PHIH"IDHKQFJDOHIEJKQT"
YZ^KHRNEKS"IAB"PBQESKBD"IJ"BCHNMHIB"IAB"PBQESK"BFFEGEBKGW"DBNHIECB"IJ"IAB"BKP"MQBD_Q"HKP"
QWQIBO_Q"PBQESK"SJHNQT"
"
`BBL"EK"OEKP"IAHIa"IJ"H"NHDSB"B]IBKIa"IAB"RBQI"PBQESK"EQ"IAB"JKB"IAHI"QBDCBQ"IAB"BKP\MQBD"DBbMEDBOBKIQ"RBQIT"cJD"
B]HOLNBa"H"PBQESK"IAHI"UJDVQ"UBN"FJD"H"OHKMFHGIMDEKS"FEDO"OHW"KJI"FEI"IAB"KBBPQ"JF"H"OHDVBIEKS"DBQBHDGA"FEDOa"
HKP"defghdgijkT"
"
"
@AB"CBDEFEGHIEJK"LDJGBQQ"ABNLQ"IAB"PBQESKBD"IJ"HCJEP"EOLNBOBKIHIEJK"LDJRNBOQ"NHIBD"RWX"
"
YZlHNEPHIEKS"IAB"OJPBN_Q"BKIEIEBQT"m[BOBORBD"IAB"OEKEOHN"PHIH"DMNBTn"
YZoJKFEDOEKS"BKIEIW"DBNHIEJKQAELQ"HKP"BNEOEKHIEKS"PMLNEGHIBa"MKKBGBQQHDWa"JD"EOLDJLBDNW"PBFEKBP"
DBNHIEJKQAELQT"
YZ^NEOEKHIEKS"PHIH"DBPMKPHKGEBQT"
YZpOLDJCEKS"IAB"OJPBN_Q"QBOHKIEG"LDBGEQEJK"IJ"RBIIBD"DBLDBQBKI"DBHN\UJDNP"JLBDHIEJKQT"
YZoJKFEDOEKS"IAHI"HN"MQBD"DBbMEDBOBKIQ"mLDJGBQQEKSa"LBDFJDOHKGBa"JD"QBGMDEIWn"HDB"OBIT"
"
lBDEFEGHIEJK"EQ"H"GJKIEKMJMQ"HGIECEIW"EK"HKW"PHIHRHQB"PBQESKT"@AB"PHIHRHQB"PBQESK"LDJGBQQ"EQ"BCJNMIEJKHDW"EK"
KHIMDBX"pI"DBbMEDBQ"IAB"GJKIEKMJMQ"BCHNMHIEJK"JF"IAB"PBCBNJLEKS"OJPBN"RW"B]HOEKEKS"IAB"BFFBGI"JF"HPPEKS"KBU"
BKIEIEBQ"HKP"RW"GJKFEDOEKS"IAHI"HKW"PBQESK"GAHKSBQ"BKAHKGB"IAB"OJPBN_Q"HGGMDHGWT"
"
"
@AB"CBDEFEGHIEJK"LDJGBQQ"DBbMEDBQ"IAB"FJNJUEKS"QIBLQX"
"
"
"
123q<'$*.>6)*5')<8*8=8%'r%)9'$*(8;)'$*.*6s)
)
)
@AB"GBKIDHN"BKIEIW"EQ"IAB"OJQI"EOLJDIHKI"BKIEIW"EK"JMD"PHIHRHQBa"HKP"OJQI"JF"IAB"JIABD"BKIEIEBQ"
PBLBKP"JK"EIT"


! 

, !
0112345689 23525
"
832125325
553
5253
34
122353
"
#$%&'()*+,-./)'.'(,+)(.(/01.23'45(./)'.+*6.03273)()*68.
.
.
9:;"<;=>?@;A"<>B><;="C:;"<DCDED=;"FG<;H">@CG"=FDH;A"=;C="C:DC"A;IH;JC"C:;"<DCD"@;;<="GI"KDAC>JLHDA"
=M=C;F="FG<LH;="=LJ:"D=">@B;@CGAMN"GA<;A=N"KDMAGHN";CJO"
"
"
P$%&'()*+,-./)'.'(,+)(.(/01.3,.*1(.23'45(Q6.7R30(66(68.
.
.
SK;J>I>JDHMN"C:>="=C;K"A;TL>A;="C:;"><;@C>I>JDC>G@"D@<"<;I>@>C>G@"GI"C:;"<DCDED=;"UVWXYWZU[\XY]
C:DC"V^_V^Y^XU]C:;"FG<LH;`="A;DHabGAH<"GK;ADC>G@=O"




!