ModernYDatabaseYManagement,Y13thYEdition,YJeffYHoffer,YRames
h
Test Bank for Modern Database Management, 13thE
Y Y Y Y Y Y Y
dition, Jeff Hoffer, Ramesh Venkataraman, HeikkiTo
Y Y Y Y Y Y
pi, ISBN-10: 0134877004, ISBN-13:
Y Y Y
9780134877006. All 14 Chapters
Y Y Y
TestYBank PageY1
, ModernYDatabaseYManagement,Y13thYEdition,YJeffYHoffer,YRames
h
Chapter 1 the Database Environment andDevelopm
Y Y Y Y Y Y
ent Process
Y
Chapter OverviewY
TheYpurposeYofYthisYchapterYisYtoYintroduceYstudentsYtoYtheYworldYofYdataYmanagementYasYaYwhole,YandYs
pecificallyYtoYtheYdatabaseYapproachYtoYinformationYsystemsYdevelopment,YtheYimportantYconceptsYandYpr
inciplesYofYtheYdatabaseYapproach,YandYtheYdatabaseYdevelopmentYprocessYwithinYtheYbroaderYcontextYofY
informationYsystemsYdevelopment.YThisYisYanYimportantYchapterYbecauseYitYconveysYaYsenseYofYtheYcentra
lYimportanceYofYdatabasesYandYdataYmanagementYinYtoday’sYinformationYsystemsYenvironmentYandYinYallY
modernYenterprises.YTheYideaYofYanYorganizationalYdatabaseYisYintuitivelyYappealingYtoYmostYstudents.YHo
wever,YmanyYstudentsYwillYhaveYlittleYorYnoYbackgroundYorYexperienceYwithYtheY technicalYimplementatio
nYofYdatabases.YOthersYwillYhaveYhadYsomeYexperienceYwithYdatabaseYmanagementYsystemsYintendedYforY
personalYorYworkgroupYuseY(suchYasYMicrosoftYAccess).YConsequently,YtheyYwillYhaveYaYlimitedYperspect
iveYconcerningYanYorganizationalYapproachYtoYdatabases.
InY thisY chapter,Y weY introduceY theY basicY conceptsY andY definitionsY ofY databasesY andY dataY manageme
nt,YstartingYwithYanYorganizingYframeworkYthatYisYnewYtoYthisYchapter.YWeYcontrastYdataYwithYinformation
,YandYintroduceYtheYnotionYofYmetadataYandYitsYimportance.YWeY alsoYcontrastYtheYdatabaseYapproachYwit
hYolderYfileYprocessingYsystems,YandYintroduceYtheYPineYValleyYFurnitureYCompanyYcaseYtoYillustrateYthe
seYconcepts.YWeYdescribeYtheYrangeYofYdatabaseYapplications,YfromYdatabasesYwithYaYpersonalYorYworkgr
oupYscopeYtoYenterpriseYdatabases,YandYidentifyYkeyYdecisionsYthatYmustYbeYmadeYforYeachYtypeYofYdatab
ase.YWeYdescribeYbothYtheYpotentialYbenefitsYandYtypicalYcostsYofYusingYtheYdatabaseYapproach.YWeYalsoYt
raceYtheYhistoricalYevolutionYofYdatabaseYsystems,YinYorderYtoYprovideYaYcontextYforYunderstandingYtheYda
tabaseYapproachYforYdataYstorageYandYretrieval.YTheYchapterYoutlinesYtheYdifferencesYbetweenYtransaction
alYandYinformationalYapproachesYandYhighlightsYtheYwayYnew,Yanalytics-
focusedYtechnologiesYareYtransformingYdataYmanagement.
TheYchapterYalsoYpresentsYanYexpandedYdescriptionYofYtheYsystemsYdevelopmentYlifeYcycleY(includingYanY
introductionYtoYrapidYapplicationYdevelopmentYmethodsYofYprototypingYandYagileYsoftwareYdevelopment)Y
andY theYroleY ofY databaseY developmentY withinY it.YTheY chapterY providesY anY updatedY descriptionY ofY theY w
ell-
TestYBank PageY2
, ModernYDatabaseYManagement,Y13thYEdition,YJeffYHoffer,YRames
h
knownYthree-
schemaYarchitectureYandYusesYitYtoYsummarizeYtheYvariousYdeliverablesYofYdatabaseYdevelopment.YItYconc
ludesYwithYanYexampleYofYdatabaseYdevelopmentYsituatedYinYtheYcontextYtheYPineYValleyYFurnitureYComp
anyYcase.
Chapter Objectives
Y
SpecificYstudentYlearningYobjectivesYareYincludedYatYtheYbeginningYofYeachYchapter.YFromYanYinstructor’sY
pointYofYview,YtheYobjectivesYofYthisYchapterYareYto:
1. CreateYaYsenseYofYexcitementYconcerningYtheYdataYandYdatabaseYmanagementYfieldYandYth
eYtypesYofYjobYopportunitiesYthatYareYavailable.
2. AcquaintYstudentsYwithYtheYbroadYspectrumYofYdatabaseYapplicationsYandYhowYorganizati
onsYareYusingYdatabaseYapplicationsYforYcompetitiveYadvantage.
3. IntroduceYtheYdataYmanagementYframeworkYthatYorganizesYtheYbookYandYtheYconceptualYs
paceYofYdataYmanagement,YhighlightingYhowYrelationalYtechnologiesYandYnon-
relationalYtechnologiesYcanYbeYseenYasYpartYofYtheYsameYspace.
4. IntroduceYtheYkeyYtermsYandYdefinitionsYthatYdescribeYtheYdatabaseYenvironment.
5. DescribeYdataYmodelsYandYhowYtheyYareYusedYtoYcaptureYtheYnatureYandYrelationshipsYamo
ngYdata.
6. DescribeYtheYmajorYcomponentsYofYtheYdatabaseYenvironmentYandYhowYtheseYcomponents
YinteractYwithYeachYother.
7. ProvideYaYreviewYofYsystemsYdevelopmentYmethodologies,YparticularlyYtheYsystemsYdevel
opmentYlifeYcycle,Yprototyping,YandYagileYsoftwareYdevelopment;YbuildYanYunderstandingY
ofYhowYdatabaseYdevelopmentYisYalignedYwithYtheseYmethodologies.
8. DevelopYanYunderstandingYofYtheYdifferentYrolesYwithinYinYaYdatabaseYdevelopmentYteam.
9. MakeY studentsY awareY ofY theY three-
schemaY architectureY andY itsY benefitsY forY databaseY developmentYandYdesign.
10. IntroduceY theY PineY ValleyY FurnitureY CompanyY case,Y whichY isY usedY throughoutY theY textY
toYillustrateYimportantYconcepts.
11. IntroduceY theY MountainY ViewY CommunityYHospitalY case,Y whichY isY includedY atY theY endY
ofYeachYchapterYasYaYsourceYforYstudentYprojects.
TestYBank PageY3
, ModernYDatabaseYManagement,Y13thYEdition,YJeffYHoffer,YRames
h
Key Terms
Y
AgileYsoftwareYdevelopment Database Metadata
ConceptualYschema DatabaseYapplication PhysicalYschema
Constraint DatabaseYmanagementYsystemY(DB Project
MS)
Data EnterpriseYdataYmodeling Prototyping
DataYindependence EnterpriseYresourceYplanningY(ERP) RelationalYdatabase
DataYmodel Entity Repository
DataYmodelingYandYdesignYtools Information SystemsY developmentY lifeY cycleY (S
DLC)
DataYwarehouse LogicalYschema UserYview
Classroom IdeasY
1. StartYwithYaYdiscussionYofYhowYstudentsYinteractYwithYsystemsYbuiltYonYdatabasesYonYaYdai
lyYbasisY(creditYcardYtransactions,YshoppingYcards,YtelephoneYcalls,YcellYphoneYcontactYlists
,YdownloadableYmusic,Yetc.).YIfYyouYteachYinYaYclassroomYwithYcomputers,YaskYstudentsYto
Y findYexamplesYofYWebYsitesYthatYappearYtoYbeYaccessingYdatabases.
2. ContrastY theY termsY ―data‖Y andY ―information.‖Y UsingY FigureY 1-
1Y asY aY startingY point,Y haveYtheYstudentsYprovideYsomeYgoodYexamplesYofYdataYandYinfor
mationYfromYtheirYownYexperiences.YThisYmayYwellYleadYtoYsomeYdifferencesYofYopinion,Y
andYtheYconclusionYthatYoneYperson’sYdataYmayYbeYanotherYperson’sYinformation.
3. IntroduceYtheYconceptYofYmetadataYusingYTableY1-
1.YAskYtheYstudentsYtoYsuggestYotherYmetadataYthatYmightYbeYappropriateYforYthisYexample
.
4. DiscussYfileYprocessingYsystemsYandYtheirYlimitations,YusingYFigureY1-2YandYTableY1-
2.YEmphasizeYthatYmanyYofYtheseYsystemsYareYstillYinYuseYtoday.
5. IntroduceYdataYmodelsYusingYFigureY1-
3.YDiscussYtheYdifferencesYbetweenYanYenterpriseYdataYmodelYandYaYprojectYdataYmodel,Yu
singYFiguresY1-3Y(a)YandY(b).
TestYBank PageY4
h
Test Bank for Modern Database Management, 13thE
Y Y Y Y Y Y Y
dition, Jeff Hoffer, Ramesh Venkataraman, HeikkiTo
Y Y Y Y Y Y
pi, ISBN-10: 0134877004, ISBN-13:
Y Y Y
9780134877006. All 14 Chapters
Y Y Y
TestYBank PageY1
, ModernYDatabaseYManagement,Y13thYEdition,YJeffYHoffer,YRames
h
Chapter 1 the Database Environment andDevelopm
Y Y Y Y Y Y
ent Process
Y
Chapter OverviewY
TheYpurposeYofYthisYchapterYisYtoYintroduceYstudentsYtoYtheYworldYofYdataYmanagementYasYaYwhole,YandYs
pecificallyYtoYtheYdatabaseYapproachYtoYinformationYsystemsYdevelopment,YtheYimportantYconceptsYandYpr
inciplesYofYtheYdatabaseYapproach,YandYtheYdatabaseYdevelopmentYprocessYwithinYtheYbroaderYcontextYofY
informationYsystemsYdevelopment.YThisYisYanYimportantYchapterYbecauseYitYconveysYaYsenseYofYtheYcentra
lYimportanceYofYdatabasesYandYdataYmanagementYinYtoday’sYinformationYsystemsYenvironmentYandYinYallY
modernYenterprises.YTheYideaYofYanYorganizationalYdatabaseYisYintuitivelyYappealingYtoYmostYstudents.YHo
wever,YmanyYstudentsYwillYhaveYlittleYorYnoYbackgroundYorYexperienceYwithYtheY technicalYimplementatio
nYofYdatabases.YOthersYwillYhaveYhadYsomeYexperienceYwithYdatabaseYmanagementYsystemsYintendedYforY
personalYorYworkgroupYuseY(suchYasYMicrosoftYAccess).YConsequently,YtheyYwillYhaveYaYlimitedYperspect
iveYconcerningYanYorganizationalYapproachYtoYdatabases.
InY thisY chapter,Y weY introduceY theY basicY conceptsY andY definitionsY ofY databasesY andY dataY manageme
nt,YstartingYwithYanYorganizingYframeworkYthatYisYnewYtoYthisYchapter.YWeYcontrastYdataYwithYinformation
,YandYintroduceYtheYnotionYofYmetadataYandYitsYimportance.YWeY alsoYcontrastYtheYdatabaseYapproachYwit
hYolderYfileYprocessingYsystems,YandYintroduceYtheYPineYValleyYFurnitureYCompanyYcaseYtoYillustrateYthe
seYconcepts.YWeYdescribeYtheYrangeYofYdatabaseYapplications,YfromYdatabasesYwithYaYpersonalYorYworkgr
oupYscopeYtoYenterpriseYdatabases,YandYidentifyYkeyYdecisionsYthatYmustYbeYmadeYforYeachYtypeYofYdatab
ase.YWeYdescribeYbothYtheYpotentialYbenefitsYandYtypicalYcostsYofYusingYtheYdatabaseYapproach.YWeYalsoYt
raceYtheYhistoricalYevolutionYofYdatabaseYsystems,YinYorderYtoYprovideYaYcontextYforYunderstandingYtheYda
tabaseYapproachYforYdataYstorageYandYretrieval.YTheYchapterYoutlinesYtheYdifferencesYbetweenYtransaction
alYandYinformationalYapproachesYandYhighlightsYtheYwayYnew,Yanalytics-
focusedYtechnologiesYareYtransformingYdataYmanagement.
TheYchapterYalsoYpresentsYanYexpandedYdescriptionYofYtheYsystemsYdevelopmentYlifeYcycleY(includingYanY
introductionYtoYrapidYapplicationYdevelopmentYmethodsYofYprototypingYandYagileYsoftwareYdevelopment)Y
andY theYroleY ofY databaseY developmentY withinY it.YTheY chapterY providesY anY updatedY descriptionY ofY theY w
ell-
TestYBank PageY2
, ModernYDatabaseYManagement,Y13thYEdition,YJeffYHoffer,YRames
h
knownYthree-
schemaYarchitectureYandYusesYitYtoYsummarizeYtheYvariousYdeliverablesYofYdatabaseYdevelopment.YItYconc
ludesYwithYanYexampleYofYdatabaseYdevelopmentYsituatedYinYtheYcontextYtheYPineYValleyYFurnitureYComp
anyYcase.
Chapter Objectives
Y
SpecificYstudentYlearningYobjectivesYareYincludedYatYtheYbeginningYofYeachYchapter.YFromYanYinstructor’sY
pointYofYview,YtheYobjectivesYofYthisYchapterYareYto:
1. CreateYaYsenseYofYexcitementYconcerningYtheYdataYandYdatabaseYmanagementYfieldYandYth
eYtypesYofYjobYopportunitiesYthatYareYavailable.
2. AcquaintYstudentsYwithYtheYbroadYspectrumYofYdatabaseYapplicationsYandYhowYorganizati
onsYareYusingYdatabaseYapplicationsYforYcompetitiveYadvantage.
3. IntroduceYtheYdataYmanagementYframeworkYthatYorganizesYtheYbookYandYtheYconceptualYs
paceYofYdataYmanagement,YhighlightingYhowYrelationalYtechnologiesYandYnon-
relationalYtechnologiesYcanYbeYseenYasYpartYofYtheYsameYspace.
4. IntroduceYtheYkeyYtermsYandYdefinitionsYthatYdescribeYtheYdatabaseYenvironment.
5. DescribeYdataYmodelsYandYhowYtheyYareYusedYtoYcaptureYtheYnatureYandYrelationshipsYamo
ngYdata.
6. DescribeYtheYmajorYcomponentsYofYtheYdatabaseYenvironmentYandYhowYtheseYcomponents
YinteractYwithYeachYother.
7. ProvideYaYreviewYofYsystemsYdevelopmentYmethodologies,YparticularlyYtheYsystemsYdevel
opmentYlifeYcycle,Yprototyping,YandYagileYsoftwareYdevelopment;YbuildYanYunderstandingY
ofYhowYdatabaseYdevelopmentYisYalignedYwithYtheseYmethodologies.
8. DevelopYanYunderstandingYofYtheYdifferentYrolesYwithinYinYaYdatabaseYdevelopmentYteam.
9. MakeY studentsY awareY ofY theY three-
schemaY architectureY andY itsY benefitsY forY databaseY developmentYandYdesign.
10. IntroduceY theY PineY ValleyY FurnitureY CompanyY case,Y whichY isY usedY throughoutY theY textY
toYillustrateYimportantYconcepts.
11. IntroduceY theY MountainY ViewY CommunityYHospitalY case,Y whichY isY includedY atY theY endY
ofYeachYchapterYasYaYsourceYforYstudentYprojects.
TestYBank PageY3
, ModernYDatabaseYManagement,Y13thYEdition,YJeffYHoffer,YRames
h
Key Terms
Y
AgileYsoftwareYdevelopment Database Metadata
ConceptualYschema DatabaseYapplication PhysicalYschema
Constraint DatabaseYmanagementYsystemY(DB Project
MS)
Data EnterpriseYdataYmodeling Prototyping
DataYindependence EnterpriseYresourceYplanningY(ERP) RelationalYdatabase
DataYmodel Entity Repository
DataYmodelingYandYdesignYtools Information SystemsY developmentY lifeY cycleY (S
DLC)
DataYwarehouse LogicalYschema UserYview
Classroom IdeasY
1. StartYwithYaYdiscussionYofYhowYstudentsYinteractYwithYsystemsYbuiltYonYdatabasesYonYaYdai
lyYbasisY(creditYcardYtransactions,YshoppingYcards,YtelephoneYcalls,YcellYphoneYcontactYlists
,YdownloadableYmusic,Yetc.).YIfYyouYteachYinYaYclassroomYwithYcomputers,YaskYstudentsYto
Y findYexamplesYofYWebYsitesYthatYappearYtoYbeYaccessingYdatabases.
2. ContrastY theY termsY ―data‖Y andY ―information.‖Y UsingY FigureY 1-
1Y asY aY startingY point,Y haveYtheYstudentsYprovideYsomeYgoodYexamplesYofYdataYandYinfor
mationYfromYtheirYownYexperiences.YThisYmayYwellYleadYtoYsomeYdifferencesYofYopinion,Y
andYtheYconclusionYthatYoneYperson’sYdataYmayYbeYanotherYperson’sYinformation.
3. IntroduceYtheYconceptYofYmetadataYusingYTableY1-
1.YAskYtheYstudentsYtoYsuggestYotherYmetadataYthatYmightYbeYappropriateYforYthisYexample
.
4. DiscussYfileYprocessingYsystemsYandYtheirYlimitations,YusingYFigureY1-2YandYTableY1-
2.YEmphasizeYthatYmanyYofYtheseYsystemsYareYstillYinYuseYtoday.
5. IntroduceYdataYmodelsYusingYFigureY1-
3.YDiscussYtheYdifferencesYbetweenYanYenterpriseYdataYmodelYandYaYprojectYdataYmodel,Yu
singYFiguresY1-3Y(a)YandY(b).
TestYBank PageY4
