AppendixtCtThetUniversitytLab:
ConceptualtDesigntVerification,tLogicaltDesign,tandtImplementation
Solutions manual
database systems design implementation
and management 12th edition by coronel
All Chapters 1-16
1
, AppendixtCtThetUniversitytLab:
ConceptualtDesigntVerification,tLogicaltDesign,tandtImplementation
TABLE OF CONTENT
t t
ParttI:tDATABASEtCONCEPTS.
1.tDatabasetSystems.
2.tDatatModels.t
ParttII:tDESIGNtCONCEPTS.
3.tThetRelationaltDatabasetModel.
4.tEntitytRelationshipt(ER)tModeling.
5.tAdvancedtDatatModeling.
6.tNormalizationtoftDatabasetTables.t
ParttIII:tADVANCEDtDESIGNtANDtIMPLEMENTATION.
7.tIntroductionttotStructuredtQuerytLanguaget(SQL).
8.tAdvancedtSQL.
2
, AppendixtCtThetUniversitytLab:
ConceptualtDesigntVerification,tLogicaltDesign,tandtImplementation
9.tDatabasetDesign.t
ParttIV:tADVANCEDtDATABASEtCONCEPTS.
10.tTransactiontManagementtandtConcurrencytControl.
11.tDatabasetPerformancetTuningtandtQuerytOptimization.
12.tDistributedtDatabasetManagementtSystems.
13.tBusinesstIntelligencetandtDatatWarehouses.
14.tBigtDatatAnalyticstandtNoSQLt
ParttV:tDATABASEStANDtTHEtINTERNET.
15.tDatabasetConnectivitytandtWebtTechnologies.t
ParttVI:tDATABASEtADMINISTRATION.
16.tDatabasetAdministrationtandtSecurity
3
, AppendixtCtThetUniversitytLab:
ConceptualtDesigntVerification,tLogicaltDesign,tandtImplementation
Appendix C t
The University Lab: Conceptual Design, Verification,Lo
t t t t t t
gical Design, and Implementation
t t t
DiscussiontFocus
Howtistatdatabasetdesigntverified,tandtwhytistsuchtverificationtnecessary?
Usetourtdetailedtanswerttotquestiont1ttotfocustclasstdiscussiontontdatabasetdesigntverification.tStresstthat
tthetverificationtprocesstusestthetinitialtERtmodeltastatcommunicationttool.
Thetdesignertmaytbegintthetverificationtprocesstbytdescribingtthetorganization'stoperationsttotitstendtusers,t
basingtthetdetailedtdescriptiontontthetinitialtERtmodel.tNext,texplainthowtthetoperationstwilltbetsupportedtb
ytthetdatabasetdesign.tStresstthattthetdesigntmusttsupporttthetend-
usertapplicationtviews,toutputs,tandtinputs.tPointsttotbetaddressedtincludetsuchtquestionstas:
• Istthetdescriptiontaccurate?tIftnot,twhattaspectstoftthetdescriptiontmusttbetcorrected?
4
ConceptualtDesigntVerification,tLogicaltDesign,tandtImplementation
Solutions manual
database systems design implementation
and management 12th edition by coronel
All Chapters 1-16
1
, AppendixtCtThetUniversitytLab:
ConceptualtDesigntVerification,tLogicaltDesign,tandtImplementation
TABLE OF CONTENT
t t
ParttI:tDATABASEtCONCEPTS.
1.tDatabasetSystems.
2.tDatatModels.t
ParttII:tDESIGNtCONCEPTS.
3.tThetRelationaltDatabasetModel.
4.tEntitytRelationshipt(ER)tModeling.
5.tAdvancedtDatatModeling.
6.tNormalizationtoftDatabasetTables.t
ParttIII:tADVANCEDtDESIGNtANDtIMPLEMENTATION.
7.tIntroductionttotStructuredtQuerytLanguaget(SQL).
8.tAdvancedtSQL.
2
, AppendixtCtThetUniversitytLab:
ConceptualtDesigntVerification,tLogicaltDesign,tandtImplementation
9.tDatabasetDesign.t
ParttIV:tADVANCEDtDATABASEtCONCEPTS.
10.tTransactiontManagementtandtConcurrencytControl.
11.tDatabasetPerformancetTuningtandtQuerytOptimization.
12.tDistributedtDatabasetManagementtSystems.
13.tBusinesstIntelligencetandtDatatWarehouses.
14.tBigtDatatAnalyticstandtNoSQLt
ParttV:tDATABASEStANDtTHEtINTERNET.
15.tDatabasetConnectivitytandtWebtTechnologies.t
ParttVI:tDATABASEtADMINISTRATION.
16.tDatabasetAdministrationtandtSecurity
3
, AppendixtCtThetUniversitytLab:
ConceptualtDesigntVerification,tLogicaltDesign,tandtImplementation
Appendix C t
The University Lab: Conceptual Design, Verification,Lo
t t t t t t
gical Design, and Implementation
t t t
DiscussiontFocus
Howtistatdatabasetdesigntverified,tandtwhytistsuchtverificationtnecessary?
Usetourtdetailedtanswerttotquestiont1ttotfocustclasstdiscussiontontdatabasetdesigntverification.tStresstthat
tthetverificationtprocesstusestthetinitialtERtmodeltastatcommunicationttool.
Thetdesignertmaytbegintthetverificationtprocesstbytdescribingtthetorganization'stoperationsttotitstendtusers,t
basingtthetdetailedtdescriptiontontthetinitialtERtmodel.tNext,texplainthowtthetoperationstwilltbetsupportedtb
ytthetdatabasetdesign.tStresstthattthetdesigntmusttsupporttthetend-
usertapplicationtviews,toutputs,tandtinputs.tPointsttotbetaddressedtincludetsuchtquestionstas:
• Istthetdescriptiontaccurate?tIftnot,twhattaspectstoftthetdescriptiontmusttbetcorrected?
4
