ModernHDatabaseHManagement,H13thHEdition,HJeffHHoffer,HRames
h
H
Test Bank for Modern Database Management, 13th
H H H H H H H
Edition, Jeff Hoffer, Ramesh Venkataraman, HeikkiT
H H H H H H
opi, ISBN-10: 0134877004, ISBN-13:
H H H
9780134877006. All 14 Chapters
H H H
TestHBank PageH1
, ModernHDatabaseHManagement,H13thHEdition,HJeffHHoffer,HRames
h
Chapter 1 the Database Environment andDevelopm
H H H H H H
ent Process
H
Chapter OverviewH
TheHpurposeHofHthisHchapterHisHtoHintroduceHstudentsHtoHtheHworldHofHdataHmanagementHasHaHwhole,HandHs
pecificallyHtoHtheHdatabaseHapproachHtoHinformationHsystemsHdevelopment,HtheHimportantHconceptsHandHpr
inciplesHofHtheHdatabaseHapproach,HandHtheHdatabaseHdevelopmentHprocessHwithinHtheHbroaderHcontextHofH
informationHsystemsHdevelopment.HThisHisHanHimportantHchapterHbecauseHitHconveysHaHsenseHofHtheHcentra
lHimportanceHofHdatabasesHandHdataHmanagementHinHtoday’sHinformationHsystemsHenvironmentHandHinHallH
modernHenterprises.HTheHideaHofHanHorganizationalHdatabaseHisHintuitivelyHappealingHtoHmostHstudents.HHo
wever,HmanyHstudentsHwillHhaveHlittleHorHnoHbackgroundHorHexperienceHwithHtheH technicalHimplementatio
nHofHdatabases.HOthersHwillHhaveHhadHsomeHexperienceHwithHdatabaseHmanagementHsystemsHintendedHforH
personalHorHworkgroupHuseH(suchHasHMicrosoftHAccess).HConsequently,HtheyHwillHhaveHaHlimitedHperspect
iveHconcerningHanHorganizationalHapproachHtoHdatabases.
InH thisH chapter,H weH introduceH theH basicH conceptsH andH definitionsH ofH databasesH andH dataH manageme
nt,HstartingHwithHanHorganizingHframeworkHthatHisHnewHtoHthisHchapter.HWeHcontrastHdataHwithHinformation
,HandHintroduceHtheHnotionHofHmetadataHandHitsHimportance.HWeH alsoHcontrastHtheHdatabaseHapproachHwit
hHolderHfileHprocessingHsystems,HandHintroduceHtheHPineHValleyHFurnitureHCompanyHcaseHtoHillustrateHthe
seHconcepts.HWeHdescribeHtheHrangeHofHdatabaseHapplications,HfromHdatabasesHwithHaHpersonalHorHworkgr
oupHscopeHtoHenterpriseHdatabases,HandHidentifyHkeyHdecisionsHthatHmustHbeHmadeHforHeachHtypeHofHdatab
ase.HWeHdescribeHbothHtheHpotentialHbenefitsHandHtypicalHcostsHofHusingHtheHdatabaseHapproach.HWeHalsoHt
raceHtheHhistoricalHevolutionHofHdatabaseHsystems,HinHorderHtoHprovideHaHcontextHforHunderstandingHtheHda
tabaseHapproachHforHdataHstorageHandHretrieval.HTheHchapterHoutlinesHtheHdifferencesHbetweenHtransaction
alHandHinformationalHapproachesHandHhighlightsHtheHwayHnew,Hanalytics-
focusedHtechnologiesHareHtransformingHdataHmanagement.
TheHchapterHalsoHpresentsHanHexpandedHdescriptionHofHtheHsystemsHdevelopmentHlifeHcycleH(includingHanH
introductionHtoHrapidHapplicationHdevelopmentHmethodsHofHprototypingHandHagileHsoftwareHdevelopment)H
andH theHroleH ofH databaseH developmentH withinHit.HTheH chapterH providesH anH updatedHdescriptionHofH theH w
ell-
TestHBank PageH2
, ModernHDatabaseHManagement,H13thHEdition,HJeffHHoffer,HRames
h
knownHthree-
schemaHarchitectureHandHusesHitHtoHsummarizeHtheHvariousHdeliverablesHofHdatabaseHdevelopment.HItHconc
ludesHwithHanHexampleHofHdatabaseHdevelopmentHsituatedHinHtheHcontextHtheHPineHValleyHFurnitureHComp
anyHcase.
Chapter Objectives
H
SpecificHstudentHlearningHobjectivesHareHincludedHatHtheHbeginningHofHeachHchapter.HFromHanHinstructor’s
pointHofHview,HtheHobjectivesHofHthisHchapterHareHto:
H
1. CreateHaHsenseHofHexcitementHconcerningHtheHdataHandHdatabaseHmanagementHfieldHandHth
eHtypesHofHjobHopportunitiesHthatHareHavailable.
2. AcquaintHstudentsHwithHtheHbroadHspectrumHofHdatabaseHapplicationsHandHhowHorganizati
onsHareHusingHdatabaseHapplicationsHforHcompetitiveHadvantage.
3. IntroduceHtheHdataHmanagementHframeworkHthatHorganizesHtheHbookHandHtheHconceptualHs
paceHofHdataHmanagement,HhighlightingHhowHrelationalHtechnologiesHandHnon-
relationalHtechnologiesHcanHbeHseenHasHpartHofHtheHsameHspace.
4. IntroduceHtheHkeyHtermsHandHdefinitionsHthatHdescribeHtheHdatabaseHenvironment.
5. DescribeHdataHmodelsHandHhowHtheyHareHusedHtoHcaptureHtheHnatureHandHrelationshipsHamo
ngHdata.
6. DescribeHtheHmajorHcomponentsHofHtheHdatabaseHenvironmentHandHhowHtheseHcomponents
HinteractHwithHeachHother.
7. ProvideHaHreviewHofHsystemsHdevelopmentHmethodologies,HparticularlyHtheHsystemsHdevel
opmentHlifeHcycle,Hprototyping,HandHagileHsoftwareHdevelopment;HbuildHanHunderstandingH
ofHhowHdatabaseHdevelopmentHisHalignedHwithHtheseHmethodologies.
8. DevelopHanHunderstandingHofHtheHdifferentHrolesHwithinHinHaHdatabaseHdevelopmentHteam.
9. MakeH studentsH awareH ofH theH three-
schemaH architectureH andH itsH benefitsH forH databaseH developmentHandHdesign.
10. IntroduceH theH PineH ValleyH FurnitureH CompanyH case,H whichH isH usedH throughoutH theH textH
toHillustrateHimportantHconcepts.
11. IntroduceH theH MountainH ViewH CommunityHHospitalH case,H whichH isH includedH atH theH endH
ofHeachHchapterHasHaHsourceHforHstudentHprojects.
TestHBank PageH3
, ModernHDatabaseHManagement,H13thHEdition,HJeffHHoffer,HRames
h
Key Terms
H
AgileHsoftwareHdevelopment Database Metadata
ConceptualHschema DatabaseHapplication PhysicalHschema
Constraint DatabaseHmanagementHsystemH(DB Project
MS)
Data EnterpriseHdataHmodeling Prototyping
DataHindependence EnterpriseHresourceHplanningH(ERP) RelationalHdatabase
DataHmodel Entity Repository
DataHmodelingHandHdesignHtools Information SystemsH developmentH lifeH cycleH (S
DLC)
DataHwarehouse LogicalHschema UserHview
Classroom IdeasH
1. StartHwithHaHdiscussionHofHhowHstudentsHinteractHwithHsystemsHbuiltHonHdatabasesHonHaHdai
lyHbasisH(creditHcardHtransactions,HshoppingHcards,HtelephoneHcalls,HcellHphoneHcontactHlists
,HdownloadableHmusic,Hetc.).HIfHyouHteachHinHaHclassroomHwithHcomputers,HaskHstudentsHto
H findHexamplesHofHWebHsitesHthatHappearHtoHbeHaccessingHdatabases.
2. ContrastH theH termsH ―data‖H andH ―information.‖H UsingH FigureH 1-
1H asH aH startingH point,H haveHtheHstudentsHprovideHsomeHgoodHexamplesHofHdataHandHinfor
mationHfromHtheirHownHexperiences.HThisHmayHwellHleadHtoHsomeHdifferencesHofHopinion,H
andHtheHconclusionHthatHoneHperson’sHdataHmayHbeHanotherHperson’sHinformation.
3. IntroduceHtheHconceptHofHmetadataHusingHTableH1-
1.HAskHtheHstudentsHtoHsuggestHotherHmetadataHthatHmightHbeHappropriateHforHthisHexample
.
4. DiscussHfileHprocessingHsystemsHandHtheirHlimitations,HusingHFigureH1-2HandHTableH1-
2.HEmphasizeHthatHmanyHofHtheseHsystemsHareHstillHinHuseHtoday.
5. IntroduceHdataHmodelsHusingHFigureH1-
3.HDiscussHtheHdifferencesHbetweenHanHenterpriseHdataHmodelHandHaHprojectHdataHmodel,Hu
singHFiguresH1-3H(a)HandH(b).
TestHBank PageH4
h
H
Test Bank for Modern Database Management, 13th
H H H H H H H
Edition, Jeff Hoffer, Ramesh Venkataraman, HeikkiT
H H H H H H
opi, ISBN-10: 0134877004, ISBN-13:
H H H
9780134877006. All 14 Chapters
H H H
TestHBank PageH1
, ModernHDatabaseHManagement,H13thHEdition,HJeffHHoffer,HRames
h
Chapter 1 the Database Environment andDevelopm
H H H H H H
ent Process
H
Chapter OverviewH
TheHpurposeHofHthisHchapterHisHtoHintroduceHstudentsHtoHtheHworldHofHdataHmanagementHasHaHwhole,HandHs
pecificallyHtoHtheHdatabaseHapproachHtoHinformationHsystemsHdevelopment,HtheHimportantHconceptsHandHpr
inciplesHofHtheHdatabaseHapproach,HandHtheHdatabaseHdevelopmentHprocessHwithinHtheHbroaderHcontextHofH
informationHsystemsHdevelopment.HThisHisHanHimportantHchapterHbecauseHitHconveysHaHsenseHofHtheHcentra
lHimportanceHofHdatabasesHandHdataHmanagementHinHtoday’sHinformationHsystemsHenvironmentHandHinHallH
modernHenterprises.HTheHideaHofHanHorganizationalHdatabaseHisHintuitivelyHappealingHtoHmostHstudents.HHo
wever,HmanyHstudentsHwillHhaveHlittleHorHnoHbackgroundHorHexperienceHwithHtheH technicalHimplementatio
nHofHdatabases.HOthersHwillHhaveHhadHsomeHexperienceHwithHdatabaseHmanagementHsystemsHintendedHforH
personalHorHworkgroupHuseH(suchHasHMicrosoftHAccess).HConsequently,HtheyHwillHhaveHaHlimitedHperspect
iveHconcerningHanHorganizationalHapproachHtoHdatabases.
InH thisH chapter,H weH introduceH theH basicH conceptsH andH definitionsH ofH databasesH andH dataH manageme
nt,HstartingHwithHanHorganizingHframeworkHthatHisHnewHtoHthisHchapter.HWeHcontrastHdataHwithHinformation
,HandHintroduceHtheHnotionHofHmetadataHandHitsHimportance.HWeH alsoHcontrastHtheHdatabaseHapproachHwit
hHolderHfileHprocessingHsystems,HandHintroduceHtheHPineHValleyHFurnitureHCompanyHcaseHtoHillustrateHthe
seHconcepts.HWeHdescribeHtheHrangeHofHdatabaseHapplications,HfromHdatabasesHwithHaHpersonalHorHworkgr
oupHscopeHtoHenterpriseHdatabases,HandHidentifyHkeyHdecisionsHthatHmustHbeHmadeHforHeachHtypeHofHdatab
ase.HWeHdescribeHbothHtheHpotentialHbenefitsHandHtypicalHcostsHofHusingHtheHdatabaseHapproach.HWeHalsoHt
raceHtheHhistoricalHevolutionHofHdatabaseHsystems,HinHorderHtoHprovideHaHcontextHforHunderstandingHtheHda
tabaseHapproachHforHdataHstorageHandHretrieval.HTheHchapterHoutlinesHtheHdifferencesHbetweenHtransaction
alHandHinformationalHapproachesHandHhighlightsHtheHwayHnew,Hanalytics-
focusedHtechnologiesHareHtransformingHdataHmanagement.
TheHchapterHalsoHpresentsHanHexpandedHdescriptionHofHtheHsystemsHdevelopmentHlifeHcycleH(includingHanH
introductionHtoHrapidHapplicationHdevelopmentHmethodsHofHprototypingHandHagileHsoftwareHdevelopment)H
andH theHroleH ofH databaseH developmentH withinHit.HTheH chapterH providesH anH updatedHdescriptionHofH theH w
ell-
TestHBank PageH2
, ModernHDatabaseHManagement,H13thHEdition,HJeffHHoffer,HRames
h
knownHthree-
schemaHarchitectureHandHusesHitHtoHsummarizeHtheHvariousHdeliverablesHofHdatabaseHdevelopment.HItHconc
ludesHwithHanHexampleHofHdatabaseHdevelopmentHsituatedHinHtheHcontextHtheHPineHValleyHFurnitureHComp
anyHcase.
Chapter Objectives
H
SpecificHstudentHlearningHobjectivesHareHincludedHatHtheHbeginningHofHeachHchapter.HFromHanHinstructor’s
pointHofHview,HtheHobjectivesHofHthisHchapterHareHto:
H
1. CreateHaHsenseHofHexcitementHconcerningHtheHdataHandHdatabaseHmanagementHfieldHandHth
eHtypesHofHjobHopportunitiesHthatHareHavailable.
2. AcquaintHstudentsHwithHtheHbroadHspectrumHofHdatabaseHapplicationsHandHhowHorganizati
onsHareHusingHdatabaseHapplicationsHforHcompetitiveHadvantage.
3. IntroduceHtheHdataHmanagementHframeworkHthatHorganizesHtheHbookHandHtheHconceptualHs
paceHofHdataHmanagement,HhighlightingHhowHrelationalHtechnologiesHandHnon-
relationalHtechnologiesHcanHbeHseenHasHpartHofHtheHsameHspace.
4. IntroduceHtheHkeyHtermsHandHdefinitionsHthatHdescribeHtheHdatabaseHenvironment.
5. DescribeHdataHmodelsHandHhowHtheyHareHusedHtoHcaptureHtheHnatureHandHrelationshipsHamo
ngHdata.
6. DescribeHtheHmajorHcomponentsHofHtheHdatabaseHenvironmentHandHhowHtheseHcomponents
HinteractHwithHeachHother.
7. ProvideHaHreviewHofHsystemsHdevelopmentHmethodologies,HparticularlyHtheHsystemsHdevel
opmentHlifeHcycle,Hprototyping,HandHagileHsoftwareHdevelopment;HbuildHanHunderstandingH
ofHhowHdatabaseHdevelopmentHisHalignedHwithHtheseHmethodologies.
8. DevelopHanHunderstandingHofHtheHdifferentHrolesHwithinHinHaHdatabaseHdevelopmentHteam.
9. MakeH studentsH awareH ofH theH three-
schemaH architectureH andH itsH benefitsH forH databaseH developmentHandHdesign.
10. IntroduceH theH PineH ValleyH FurnitureH CompanyH case,H whichH isH usedH throughoutH theH textH
toHillustrateHimportantHconcepts.
11. IntroduceH theH MountainH ViewH CommunityHHospitalH case,H whichH isH includedH atH theH endH
ofHeachHchapterHasHaHsourceHforHstudentHprojects.
TestHBank PageH3
, ModernHDatabaseHManagement,H13thHEdition,HJeffHHoffer,HRames
h
Key Terms
H
AgileHsoftwareHdevelopment Database Metadata
ConceptualHschema DatabaseHapplication PhysicalHschema
Constraint DatabaseHmanagementHsystemH(DB Project
MS)
Data EnterpriseHdataHmodeling Prototyping
DataHindependence EnterpriseHresourceHplanningH(ERP) RelationalHdatabase
DataHmodel Entity Repository
DataHmodelingHandHdesignHtools Information SystemsH developmentH lifeH cycleH (S
DLC)
DataHwarehouse LogicalHschema UserHview
Classroom IdeasH
1. StartHwithHaHdiscussionHofHhowHstudentsHinteractHwithHsystemsHbuiltHonHdatabasesHonHaHdai
lyHbasisH(creditHcardHtransactions,HshoppingHcards,HtelephoneHcalls,HcellHphoneHcontactHlists
,HdownloadableHmusic,Hetc.).HIfHyouHteachHinHaHclassroomHwithHcomputers,HaskHstudentsHto
H findHexamplesHofHWebHsitesHthatHappearHtoHbeHaccessingHdatabases.
2. ContrastH theH termsH ―data‖H andH ―information.‖H UsingH FigureH 1-
1H asH aH startingH point,H haveHtheHstudentsHprovideHsomeHgoodHexamplesHofHdataHandHinfor
mationHfromHtheirHownHexperiences.HThisHmayHwellHleadHtoHsomeHdifferencesHofHopinion,H
andHtheHconclusionHthatHoneHperson’sHdataHmayHbeHanotherHperson’sHinformation.
3. IntroduceHtheHconceptHofHmetadataHusingHTableH1-
1.HAskHtheHstudentsHtoHsuggestHotherHmetadataHthatHmightHbeHappropriateHforHthisHexample
.
4. DiscussHfileHprocessingHsystemsHandHtheirHlimitations,HusingHFigureH1-2HandHTableH1-
2.HEmphasizeHthatHmanyHofHtheseHsystemsHareHstillHinHuseHtoday.
5. IntroduceHdataHmodelsHusingHFigureH1-
3.HDiscussHtheHdifferencesHbetweenHanHenterpriseHdataHmodelHandHaHprojectHdataHmodel,Hu
singHFiguresH1-3H(a)HandH(b).
TestHBank PageH4
