SOLUTIONS TO REVIEW QUESTIONS
@z @z @z
AND EXERCISES
@z @z
FOR PART 1 – BACKGROUND (CHAPTERS 1 – 3)
@z @z @z @z @z @z @z @z
VERIFIEDBRAINBOOSTER
,Database @zSystems: @zInstructor’s @zGuide @z-
@zPart @zIII
Solutions @zto @zReview @zQuestions @zand @zExercises
Chapter @z1 @ z Introduction @zto @zDatabases .................................................................................. 3
Chapter @z2 @ z Database @zEnvironment .......................................................................................... 7
Chapter @z3 @ z Database @zArchitectures @zand @zthe @zWeb............................................................. 11
2
VERIFIEDBRAINBOOSTER
,Database @zSystems: @zInstructor’s @zGuide @z-
@zPart @zIII
Chapter @z1 @ z Introduction @zto @zDatabases
Review @zQuestions
1.1 List @zfour @zexamples @zof @zdatabase @zsystems @zother @zthan @zthose @zlisted @zin @zSection @z1.1.
Some @zexamples @zcould @zbe:
A @zsystem @zthat @zmaintains @zcomponent @zpart @zdetails @zfor @za @zcar @zmanufacturer;
An @zadvertising @zcompany @zkeeping @zdetails @zof @zall @zclients @zand @zadverts @zplaced @zwith @zthem;
A @ztraining @zcompany @zkeeping @zcourse @zinformation @zand @zparticipants’ @zdetails;
An @zorganization @zmaintaining @zall @zsales @zorder @zinformation.
1.2 Discuss @zeach @zof @zthe @zfollowing @zterms:
Data For @ z end @ z users, @ z this @ z constitutes @ z all @ z the @ z different @ z values
@z connected @ z with @ z the @zvarious @zobjects/entities @zthat @zare @zof @zconcern
@zto @zthem. @zSee @zalso @zSection @z1.3.4.
Database See @zSection @z1.3.1
Database @zManagement @zSystem See @zSection @z1.3.2
Database @zApplication @zProgram See @zSection @z1.3.3
Data @zIndependence @zThis @zis @zessentially @zthe @zseparation @zof @zunderlying @zfile @zstructures
from @zthe @zprograms @zthat @zoperate @zon @zthem, @zalso @zcalled @zprogram-
@z
data @zindependence. @zSee @zalso @zSections @z1.2.2 @zand @z1.3.1.
Security The @zprotection @zof @zthe @zdatabase @zfrom @zunauthorized @zusers, @zwhich
@zmay @zinvolve @z passwords and
@z @z access restrictions.
@z See
@z @zalso
@zSection @z1.6.
Integrity The @zmaintenance @zof @zthe @zvalidity @zand @zconsistency @zof @zthe
@zdatabase @zby @zuse @zof @zparticular @zconstraints @zthat @zare @zapplied @zto
@zthe @zdata. @zSee @zalso @zSection @z1.6.
Views These @zpresent @zonly a
@z @zsubset of
@z @zthe @z database that
@z @zis of
@z
@z particular @zinterest @zto @za @zuser. @zViews @zcan @zbe @zcustomized, @zfor
@z example, @zfield @znames @zmay @zchange, @zand @zthey @zalso @zprovide @za
@zlevel @zof @zsecurity @zpreventing @zusers @zfrom @zseeing @zcertain @zdata.
@zSee @zalso @zSection @z1.3.3.
1.3 Describe @zthe @zapproach @ztaken @zto @zthe @zhandling @zof @zdata @zin @zthe @zearly @zfile-based
@zsystems. @zDiscuss @zthe @zdisadvantages @zof @zthis @zapproach.
Focus @zwas @zon @zapplications @zfor @zwhich @zprograms @zwould @zbe @zwritten, @zand @zall @zthe @zdata
@zrequired @zwould @zbe @zstored @zin @za @zfile @zor @zfiles @zowned @zby @zthe @zprograms. @zSee @zalso
@z Section @z1.2.
Clearly, @zeach @zprogram @zwas @zresponsible @zfor @zonly @zits @zown @zdata, @zwhich @zcould @zbe
@zrepeated @zin @zother @zprogram’s @zdata @zfiles. @zDifferent @zprograms @zcould @zbe @zwritten @zin
@zdifferent @zlanguages, @zand @zwould @znot @zbe @zable @zto @zaccess @zanother @zprogram’s @zfiles. @zThis
@zwould @zbe @ztrue @zeven @zfor @zthose @zprograms @zwritten @zin @zthe @zsame @zlanguage, @zbecause @za
@zprogram @zneeds @zto @zknow @zthe @zfile @zstructure @zbefore @zit @zcan @zaccess @zit. @zSee @zalso @zSection
3
VERIFIEDBRAINBOOSTER
, Database @zSystems: @zInstructor’s @zGuide @z-
@zPart @zIII
@z1.2.2.
1.4 Describe @zthe @zmain @zcharacteristics @zof @zthe @zdatabase @zapproach @zand @zcontrast @zit @zwith
@zthe @zfile-based @zapproach.
4
VERIFIEDBRAINBOOSTER
@z @z @z
AND EXERCISES
@z @z
FOR PART 1 – BACKGROUND (CHAPTERS 1 – 3)
@z @z @z @z @z @z @z @z
VERIFIEDBRAINBOOSTER
,Database @zSystems: @zInstructor’s @zGuide @z-
@zPart @zIII
Solutions @zto @zReview @zQuestions @zand @zExercises
Chapter @z1 @ z Introduction @zto @zDatabases .................................................................................. 3
Chapter @z2 @ z Database @zEnvironment .......................................................................................... 7
Chapter @z3 @ z Database @zArchitectures @zand @zthe @zWeb............................................................. 11
2
VERIFIEDBRAINBOOSTER
,Database @zSystems: @zInstructor’s @zGuide @z-
@zPart @zIII
Chapter @z1 @ z Introduction @zto @zDatabases
Review @zQuestions
1.1 List @zfour @zexamples @zof @zdatabase @zsystems @zother @zthan @zthose @zlisted @zin @zSection @z1.1.
Some @zexamples @zcould @zbe:
A @zsystem @zthat @zmaintains @zcomponent @zpart @zdetails @zfor @za @zcar @zmanufacturer;
An @zadvertising @zcompany @zkeeping @zdetails @zof @zall @zclients @zand @zadverts @zplaced @zwith @zthem;
A @ztraining @zcompany @zkeeping @zcourse @zinformation @zand @zparticipants’ @zdetails;
An @zorganization @zmaintaining @zall @zsales @zorder @zinformation.
1.2 Discuss @zeach @zof @zthe @zfollowing @zterms:
Data For @ z end @ z users, @ z this @ z constitutes @ z all @ z the @ z different @ z values
@z connected @ z with @ z the @zvarious @zobjects/entities @zthat @zare @zof @zconcern
@zto @zthem. @zSee @zalso @zSection @z1.3.4.
Database See @zSection @z1.3.1
Database @zManagement @zSystem See @zSection @z1.3.2
Database @zApplication @zProgram See @zSection @z1.3.3
Data @zIndependence @zThis @zis @zessentially @zthe @zseparation @zof @zunderlying @zfile @zstructures
from @zthe @zprograms @zthat @zoperate @zon @zthem, @zalso @zcalled @zprogram-
@z
data @zindependence. @zSee @zalso @zSections @z1.2.2 @zand @z1.3.1.
Security The @zprotection @zof @zthe @zdatabase @zfrom @zunauthorized @zusers, @zwhich
@zmay @zinvolve @z passwords and
@z @z access restrictions.
@z See
@z @zalso
@zSection @z1.6.
Integrity The @zmaintenance @zof @zthe @zvalidity @zand @zconsistency @zof @zthe
@zdatabase @zby @zuse @zof @zparticular @zconstraints @zthat @zare @zapplied @zto
@zthe @zdata. @zSee @zalso @zSection @z1.6.
Views These @zpresent @zonly a
@z @zsubset of
@z @zthe @z database that
@z @zis of
@z
@z particular @zinterest @zto @za @zuser. @zViews @zcan @zbe @zcustomized, @zfor
@z example, @zfield @znames @zmay @zchange, @zand @zthey @zalso @zprovide @za
@zlevel @zof @zsecurity @zpreventing @zusers @zfrom @zseeing @zcertain @zdata.
@zSee @zalso @zSection @z1.3.3.
1.3 Describe @zthe @zapproach @ztaken @zto @zthe @zhandling @zof @zdata @zin @zthe @zearly @zfile-based
@zsystems. @zDiscuss @zthe @zdisadvantages @zof @zthis @zapproach.
Focus @zwas @zon @zapplications @zfor @zwhich @zprograms @zwould @zbe @zwritten, @zand @zall @zthe @zdata
@zrequired @zwould @zbe @zstored @zin @za @zfile @zor @zfiles @zowned @zby @zthe @zprograms. @zSee @zalso
@z Section @z1.2.
Clearly, @zeach @zprogram @zwas @zresponsible @zfor @zonly @zits @zown @zdata, @zwhich @zcould @zbe
@zrepeated @zin @zother @zprogram’s @zdata @zfiles. @zDifferent @zprograms @zcould @zbe @zwritten @zin
@zdifferent @zlanguages, @zand @zwould @znot @zbe @zable @zto @zaccess @zanother @zprogram’s @zfiles. @zThis
@zwould @zbe @ztrue @zeven @zfor @zthose @zprograms @zwritten @zin @zthe @zsame @zlanguage, @zbecause @za
@zprogram @zneeds @zto @zknow @zthe @zfile @zstructure @zbefore @zit @zcan @zaccess @zit. @zSee @zalso @zSection
3
VERIFIEDBRAINBOOSTER
, Database @zSystems: @zInstructor’s @zGuide @z-
@zPart @zIII
@z1.2.2.
1.4 Describe @zthe @zmain @zcharacteristics @zof @zthe @zdatabase @zapproach @zand @zcontrast @zit @zwith
@zthe @zfile-based @zapproach.
4
VERIFIEDBRAINBOOSTER
