ModerngDatabasegManagement,g13thgEdition,gJeffgHoffer,gRames
h
Test Bank for Modern Database Management, 13th Edit
g g g g g g g
ion, Jeff Hoffer, Ramesh Venkataraman, Heikki Topi, IS
g g g g g g g
BN-10: 0134877004, ISBN-13:
g g
9780134877006. All 14 Chapters
g g g
TestgBank Pageg1
, ModerngDatabasegManagement,g13thgEdition,gJeffgHoffer,gRames
h
Chapter 1 the Database Environment and Development
g g g g g g
gProcess
ChaptergOverview
Thegpurposegofgthisgchaptergisgtogintroducegstudentsgtogthegworldgofgdatagmanagementgasgagwhole,gandgs
pecificallygtogthegdatabasegapproachgtoginformationgsystemsgdevelopment,gthegimportantgconceptsgandgpr
inciplesgofgthegdatabasegapproach,gandgthegdatabasegdevelopmentgprocessgwithingthegbroadergcontextgofgi
nformationgsystemsgdevelopment.gThisgisgangimportantgchaptergbecausegitgconveysgagsensegofgthegcentral
gimportancegofgdatabasesgandgdatagmanagementgingtoday’sginformationgsystemsgenvironmentgandgingallg
moderngenterprises.gThegideagofgangorganizationalgdatabasegisgintuitivelygappealinggtogmostgstudents.gHo
wever,gmanygstudentsgwillghaveglittlegorgnogbackgroundgorgexperiencegwithgthegtechnicalgimplementation
gofgdatabases.gOthersgwillghaveghadgsomegexperiencegwithgdatabasegmanagementgsystemsgintendedgforgp
ersonalgorgworkgroupguseg(suchgasgMicrosoftgAccess).gConsequently,gtheygwillghavegaglimitedgperspectiv
egconcerninggangorganizationalgapproachgtogdatabases.
Ingthisgchapter,gwegintroducegthegbasicgconceptsgandgdefinitionsgofgdatabasesgandgdatagmanagement,gstart
inggwithgangorganizinggframeworkgthatgisgnewgtogthisgchapter.gWegcontrastgdatagwithginformation,gandgin
troducegthegnotiongofgmetadatagandgitsgimportance.gWegalsogcontrastgthegdatabasegapproachgwithgoldergfi
legprocessinggsystems,gandgintroducegthegPinegValleygFurnituregCompanygcasegtogillustrategthesegconcept
s.gWegdescribegthegrangegofgdatabasegapplications,gfromgdatabasesgwithgagpersonalgorgworkgroupgscopegt
ogenterprisegdatabases,gandgidentifygkeygdecisionsgthatgmustgbegmadegforgeachgtypegofgdatabase.gWegdes
cribegbothgthegpotentialgbenefitsgandgtypicalgcostsgofgusinggthegdatabasegapproach.gWegalsogtracegtheghist
oricalgevolutiongofgdatabasegsystems,gingordergtogprovidegagcontextgforgunderstandinggthegdatabasegappro
achgforgdatagstoragegandgretrieval.gThegchaptergoutlinesgthegdifferencesgbetweengtransactionalgandginform
ationalgapproachesgandghighlightsgthegwaygnew,ganalytics-
focusedgtechnologiesgaregtransforminggdatagmanagement.
Thegchaptergalsogpresentsgangexpandedgdescriptiongofgthegsystemsgdevelopmentglifegcycleg(includinggangi
ntroductiongtograpidgapplicationgdevelopmentgmethodsgofgprototypinggandgagilegsoftwaregdevelopment)ga
ndg thegroleg ofg databaseg developmentg withingit.gTheg chapterg providesg ang updatedgdescriptiongofg theg well
-
TestgBank Pageg2
, ModerngDatabasegManagement,g13thgEdition,gJeffgHoffer,gRames
h
knowngthree-
schemagarchitecturegandgusesgitgtogsummarizegthegvariousgdeliverablesgofgdatabasegdevelopment.gItgconcl
udesgwithgangexamplegofgdatabasegdevelopmentgsituatedgingthegcontextgthegPinegValleygFurnituregCompa
nygcase.
ChaptergObjectives
Specificgstudentglearninggobjectivesgaregincludedgatgthegbeginninggofgeachgchapter.gFromganginstructor’s
gpointgofgview,gthegobjectivesgofgthisgchaptergaregto:
1. Creategagsensegofgexcitementgconcerninggthegdatagandgdatabasegmanagementgfieldgandgth
egtypesgofgjobgopportunitiesgthatgaregavailable.
2. Acquaintgstudentsgwithgthegbroadgspectrumgofgdatabasegapplicationsgandghowgorganizatio
nsgaregusinggdatabasegapplicationsgforgcompetitivegadvantage.
3. Introducegthegdatagmanagementgframeworkgthatgorganizesgthegbookgandgthegconceptualgs
pacegofgdatagmanagement,ghighlightingghowgrelationalgtechnologiesgandgnon-
relationalgtechnologiesgcangbegseengasgpartgofgthegsamegspace.
4. Introducegthegkeygtermsgandgdefinitionsgthatgdescribegthegdatabasegenvironment.
5. Describegdatagmodelsgandghowgtheygaregusedgtogcapturegthegnaturegandgrelationshipsgamo
nggdata.
6. Describegthegmajorgcomponentsgofgthegdatabasegenvironmentgandghowgthesegcomponents
g interactgwithgeachgother.
7. Providegagreviewgofgsystemsgdevelopmentgmethodologies,gparticularlygthegsystemsgdevel
opmentglifegcycle,gprototyping,gandgagilegsoftwaregdevelopment;gbuildgangunderstandingg
ofghowgdatabasegdevelopmentgisgalignedgwithgthesegmethodologies.
8. Developgangunderstandinggofgthegdifferentgrolesgwithingingagdatabasegdevelopmentgteam.
9. Makegstudentsgawaregofgthegthree-
schemagarchitecturegandgitsgbenefitsgforgdatabasegdevelopmentgandgdesign.
10. IntroducegthegPinegValleygFurnituregCompanygcase,gwhichgisgusedgthroughoutgthegtextgtog
illustrategimportantgconcepts.
11. IntroducegthegMountaingViewgCommunitygHospitalgcase,gwhichgisgincludedgatgthegendgof
g eachgchaptergasgagsourcegforgstudentgprojects.
TestgBank Pageg3
, ModerngDatabasegManagement,g13thgEdition,gJeffgHoffer,gRames
h
KeygTerms
Agilegsoftwaregdevelopment Database Metadata
Conceptualgschema Databasegapplication Physicalgschema
Constraint Databasegmanagementgsystemg(DB Project
MS)
Data Enterprisegdatagmodeling Prototyping
Datagindependence Enterprisegresourcegplanningg(ERP) Relationalgdatabase
Datagmodel Entity Repository
Datagmodelinggandgdesigngtools Information Systemsg developmentg lifeg cycleg (S
DLC)
Datagwarehouse Logicalgschema Usergview
ClassroomgIdeas
1. Startgwithgagdiscussiongofghowgstudentsginteractgwithgsystemsgbuiltgongdatabasesgongagdail
ygbasisg(creditgcardgtransactions,gshoppinggcards,gtelephonegcalls,gcellgphonegcontactglists,
gdownloadablegmusic,getc.).gIfgyougteachgingagclassroomgwithgcomputers,gaskgstudentsgtog
findgexamplesgofgWebgsitesgthatgappeargtogbegaccessinggdatabases.
2. Contrastgthegtermsg―data‖gandg―information.‖gUsinggFigureg1-
1gasgagstartinggpoint,ghavegthegstudentsgprovidegsomeggoodgexamplesgofgdatagandginforma
tiongfromgtheirgowngexperiences.gThisgmaygwellgleadgtogsomegdifferencesgofgopinion,gand
gthegconclusiongthatgonegperson’sgdatagmaygbeganothergperson’sginformation.
3. IntroducegthegconceptgofgmetadatagusinggTableg1-
1.gAskgthegstudentsgtogsuggestgothergmetadatagthatgmightgbegappropriategforgthisgexample.
4. Discussgfilegprocessinggsystemsgandgtheirglimitations,gusinggFigureg1-2gandgTableg1-
2.gEmphasizegthatgmanygofgthesegsystemsgaregstillgingusegtoday.
5. IntroducegdatagmodelsgusinggFigureg1-
3.gDiscussgthegdifferencesgbetweengangenterprisegdatagmodelgandgagprojectgdatagmodel,gus
inggFiguresg1-3g(a)gandg(b).
6. Discussgeachgofgthegadvantagesgofgthegdatabasegapproachg(Tableg1-
TestgBank Pageg4
h
Test Bank for Modern Database Management, 13th Edit
g g g g g g g
ion, Jeff Hoffer, Ramesh Venkataraman, Heikki Topi, IS
g g g g g g g
BN-10: 0134877004, ISBN-13:
g g
9780134877006. All 14 Chapters
g g g
TestgBank Pageg1
, ModerngDatabasegManagement,g13thgEdition,gJeffgHoffer,gRames
h
Chapter 1 the Database Environment and Development
g g g g g g
gProcess
ChaptergOverview
Thegpurposegofgthisgchaptergisgtogintroducegstudentsgtogthegworldgofgdatagmanagementgasgagwhole,gandgs
pecificallygtogthegdatabasegapproachgtoginformationgsystemsgdevelopment,gthegimportantgconceptsgandgpr
inciplesgofgthegdatabasegapproach,gandgthegdatabasegdevelopmentgprocessgwithingthegbroadergcontextgofgi
nformationgsystemsgdevelopment.gThisgisgangimportantgchaptergbecausegitgconveysgagsensegofgthegcentral
gimportancegofgdatabasesgandgdatagmanagementgingtoday’sginformationgsystemsgenvironmentgandgingallg
moderngenterprises.gThegideagofgangorganizationalgdatabasegisgintuitivelygappealinggtogmostgstudents.gHo
wever,gmanygstudentsgwillghaveglittlegorgnogbackgroundgorgexperiencegwithgthegtechnicalgimplementation
gofgdatabases.gOthersgwillghaveghadgsomegexperiencegwithgdatabasegmanagementgsystemsgintendedgforgp
ersonalgorgworkgroupguseg(suchgasgMicrosoftgAccess).gConsequently,gtheygwillghavegaglimitedgperspectiv
egconcerninggangorganizationalgapproachgtogdatabases.
Ingthisgchapter,gwegintroducegthegbasicgconceptsgandgdefinitionsgofgdatabasesgandgdatagmanagement,gstart
inggwithgangorganizinggframeworkgthatgisgnewgtogthisgchapter.gWegcontrastgdatagwithginformation,gandgin
troducegthegnotiongofgmetadatagandgitsgimportance.gWegalsogcontrastgthegdatabasegapproachgwithgoldergfi
legprocessinggsystems,gandgintroducegthegPinegValleygFurnituregCompanygcasegtogillustrategthesegconcept
s.gWegdescribegthegrangegofgdatabasegapplications,gfromgdatabasesgwithgagpersonalgorgworkgroupgscopegt
ogenterprisegdatabases,gandgidentifygkeygdecisionsgthatgmustgbegmadegforgeachgtypegofgdatabase.gWegdes
cribegbothgthegpotentialgbenefitsgandgtypicalgcostsgofgusinggthegdatabasegapproach.gWegalsogtracegtheghist
oricalgevolutiongofgdatabasegsystems,gingordergtogprovidegagcontextgforgunderstandinggthegdatabasegappro
achgforgdatagstoragegandgretrieval.gThegchaptergoutlinesgthegdifferencesgbetweengtransactionalgandginform
ationalgapproachesgandghighlightsgthegwaygnew,ganalytics-
focusedgtechnologiesgaregtransforminggdatagmanagement.
Thegchaptergalsogpresentsgangexpandedgdescriptiongofgthegsystemsgdevelopmentglifegcycleg(includinggangi
ntroductiongtograpidgapplicationgdevelopmentgmethodsgofgprototypinggandgagilegsoftwaregdevelopment)ga
ndg thegroleg ofg databaseg developmentg withingit.gTheg chapterg providesg ang updatedgdescriptiongofg theg well
-
TestgBank Pageg2
, ModerngDatabasegManagement,g13thgEdition,gJeffgHoffer,gRames
h
knowngthree-
schemagarchitecturegandgusesgitgtogsummarizegthegvariousgdeliverablesgofgdatabasegdevelopment.gItgconcl
udesgwithgangexamplegofgdatabasegdevelopmentgsituatedgingthegcontextgthegPinegValleygFurnituregCompa
nygcase.
ChaptergObjectives
Specificgstudentglearninggobjectivesgaregincludedgatgthegbeginninggofgeachgchapter.gFromganginstructor’s
gpointgofgview,gthegobjectivesgofgthisgchaptergaregto:
1. Creategagsensegofgexcitementgconcerninggthegdatagandgdatabasegmanagementgfieldgandgth
egtypesgofgjobgopportunitiesgthatgaregavailable.
2. Acquaintgstudentsgwithgthegbroadgspectrumgofgdatabasegapplicationsgandghowgorganizatio
nsgaregusinggdatabasegapplicationsgforgcompetitivegadvantage.
3. Introducegthegdatagmanagementgframeworkgthatgorganizesgthegbookgandgthegconceptualgs
pacegofgdatagmanagement,ghighlightingghowgrelationalgtechnologiesgandgnon-
relationalgtechnologiesgcangbegseengasgpartgofgthegsamegspace.
4. Introducegthegkeygtermsgandgdefinitionsgthatgdescribegthegdatabasegenvironment.
5. Describegdatagmodelsgandghowgtheygaregusedgtogcapturegthegnaturegandgrelationshipsgamo
nggdata.
6. Describegthegmajorgcomponentsgofgthegdatabasegenvironmentgandghowgthesegcomponents
g interactgwithgeachgother.
7. Providegagreviewgofgsystemsgdevelopmentgmethodologies,gparticularlygthegsystemsgdevel
opmentglifegcycle,gprototyping,gandgagilegsoftwaregdevelopment;gbuildgangunderstandingg
ofghowgdatabasegdevelopmentgisgalignedgwithgthesegmethodologies.
8. Developgangunderstandinggofgthegdifferentgrolesgwithingingagdatabasegdevelopmentgteam.
9. Makegstudentsgawaregofgthegthree-
schemagarchitecturegandgitsgbenefitsgforgdatabasegdevelopmentgandgdesign.
10. IntroducegthegPinegValleygFurnituregCompanygcase,gwhichgisgusedgthroughoutgthegtextgtog
illustrategimportantgconcepts.
11. IntroducegthegMountaingViewgCommunitygHospitalgcase,gwhichgisgincludedgatgthegendgof
g eachgchaptergasgagsourcegforgstudentgprojects.
TestgBank Pageg3
, ModerngDatabasegManagement,g13thgEdition,gJeffgHoffer,gRames
h
KeygTerms
Agilegsoftwaregdevelopment Database Metadata
Conceptualgschema Databasegapplication Physicalgschema
Constraint Databasegmanagementgsystemg(DB Project
MS)
Data Enterprisegdatagmodeling Prototyping
Datagindependence Enterprisegresourcegplanningg(ERP) Relationalgdatabase
Datagmodel Entity Repository
Datagmodelinggandgdesigngtools Information Systemsg developmentg lifeg cycleg (S
DLC)
Datagwarehouse Logicalgschema Usergview
ClassroomgIdeas
1. Startgwithgagdiscussiongofghowgstudentsginteractgwithgsystemsgbuiltgongdatabasesgongagdail
ygbasisg(creditgcardgtransactions,gshoppinggcards,gtelephonegcalls,gcellgphonegcontactglists,
gdownloadablegmusic,getc.).gIfgyougteachgingagclassroomgwithgcomputers,gaskgstudentsgtog
findgexamplesgofgWebgsitesgthatgappeargtogbegaccessinggdatabases.
2. Contrastgthegtermsg―data‖gandg―information.‖gUsinggFigureg1-
1gasgagstartinggpoint,ghavegthegstudentsgprovidegsomeggoodgexamplesgofgdatagandginforma
tiongfromgtheirgowngexperiences.gThisgmaygwellgleadgtogsomegdifferencesgofgopinion,gand
gthegconclusiongthatgonegperson’sgdatagmaygbeganothergperson’sginformation.
3. IntroducegthegconceptgofgmetadatagusinggTableg1-
1.gAskgthegstudentsgtogsuggestgothergmetadatagthatgmightgbegappropriategforgthisgexample.
4. Discussgfilegprocessinggsystemsgandgtheirglimitations,gusinggFigureg1-2gandgTableg1-
2.gEmphasizegthatgmanygofgthesegsystemsgaregstillgingusegtoday.
5. IntroducegdatagmodelsgusinggFigureg1-
3.gDiscussgthegdifferencesgbetweengangenterprisegdatagmodelgandgagprojectgdatagmodel,gus
inggFiguresg1-3g(a)gandg(b).
6. Discussgeachgofgthegadvantagesgofgthegdatabasegapproachg(Tableg1-
TestgBank Pageg4
