CHAPTER 1 QUESTIONS AND
SOLUTIONS
d Ahoc Aquery A- Acorrect AAnswers A✔✔ A-A A"spur-of-the-moment" Aquestion.
centralized Adatabase A- Acorrect AAnswers A✔✔ A-A Adatabase Alocated Aat Aa Asingle
Asite.
data A- Acorrect AAnswers A✔✔ A-Raw Afacts, Athat Ais, Afacts Athat Ahave Anot Ayet Abeen
Aprocessed Ato Areveal Atheir Ameaning Ato Athe Aend Auser.
data Aanomaly A- Acorrect AAnswers A✔✔ A-A Adata Aabnormality Athat Aexists Awhen
Ainconsistent Achanges Ato Aa Adatabase Ahave Abeen Amade. AFor Aexample, Aan
Aemployee Amoves, Abut Athe Aaddress Achange Ais Acorrected Ain Aonly Aone Afile Aand
Anot Aacross Aall Afiles Ain Athe Adatabase.
data Adependence A- Acorrect AAnswers A✔✔ A-A Adata Acondition Ain Awhich Athe Adata
Arepresentation Aand Amanipulation Aare Adependent Aon Athe Aphysical Adata Astorage
Acharacteristics.
data Adictionary A- Acorrect AAnswers A✔✔ A-A ADBMS Acomponent Athat Astores
Ametadata—data Aabout Adata. AThus, Athe Adata Adictionary Acontains Athe Adata
Adefinition Aas Awell Aas Aits Acharacteristics Aand Arelationships. AA Adata Adictionary Amay
Aalso Ainclude Adata Athat Aare Aexternal Ato Athe ADBMS. AAlso Aknown Aas Aan
Ainformation Aresource Adictionary. ASee Aalso Aactive Adata Adictionary, Ametadata, Aand
Apassive Adata Adictionary.
data Ainconsistency A- Acorrect AAnswers A✔✔ A-A Acondition Ain Awhich Adifferent
Aversions Aof Athe Asame Adata Ayield Adifferent A(inconsistent) Aresults.
data Aindependence A- Acorrect AAnswers A✔✔ A-A Acondition Athat Aexists Awhen Adata
Aaccess Ais Aunaffected Aby Achanges Ain Athe Aphysical Adata Astorage Acharacteristics.
data Aintegrity A- Acorrect AAnswers A✔✔ A-In Aa Arelational Adatabase, Arefers Ato Aa
Acondition Ain Awhich Athe Adata Ain Athe Adatabase Ais Ain Acompliance Awith Aall Aentity
Aand Areferential Aintegrity Aconstraints.
data Amanagement A- Acorrect AAnswers A✔✔ A-A Aprocess Athat Afocuses Aon Adata
Acollection, Astorage, Aand Aretrieval. ACommon Adata Amanagement Afunctions Ainclude
Aaddition, Adeletion, Amodification, Aand Alisting.
SOLUTIONS
d Ahoc Aquery A- Acorrect AAnswers A✔✔ A-A A"spur-of-the-moment" Aquestion.
centralized Adatabase A- Acorrect AAnswers A✔✔ A-A Adatabase Alocated Aat Aa Asingle
Asite.
data A- Acorrect AAnswers A✔✔ A-Raw Afacts, Athat Ais, Afacts Athat Ahave Anot Ayet Abeen
Aprocessed Ato Areveal Atheir Ameaning Ato Athe Aend Auser.
data Aanomaly A- Acorrect AAnswers A✔✔ A-A Adata Aabnormality Athat Aexists Awhen
Ainconsistent Achanges Ato Aa Adatabase Ahave Abeen Amade. AFor Aexample, Aan
Aemployee Amoves, Abut Athe Aaddress Achange Ais Acorrected Ain Aonly Aone Afile Aand
Anot Aacross Aall Afiles Ain Athe Adatabase.
data Adependence A- Acorrect AAnswers A✔✔ A-A Adata Acondition Ain Awhich Athe Adata
Arepresentation Aand Amanipulation Aare Adependent Aon Athe Aphysical Adata Astorage
Acharacteristics.
data Adictionary A- Acorrect AAnswers A✔✔ A-A ADBMS Acomponent Athat Astores
Ametadata—data Aabout Adata. AThus, Athe Adata Adictionary Acontains Athe Adata
Adefinition Aas Awell Aas Aits Acharacteristics Aand Arelationships. AA Adata Adictionary Amay
Aalso Ainclude Adata Athat Aare Aexternal Ato Athe ADBMS. AAlso Aknown Aas Aan
Ainformation Aresource Adictionary. ASee Aalso Aactive Adata Adictionary, Ametadata, Aand
Apassive Adata Adictionary.
data Ainconsistency A- Acorrect AAnswers A✔✔ A-A Acondition Ain Awhich Adifferent
Aversions Aof Athe Asame Adata Ayield Adifferent A(inconsistent) Aresults.
data Aindependence A- Acorrect AAnswers A✔✔ A-A Acondition Athat Aexists Awhen Adata
Aaccess Ais Aunaffected Aby Achanges Ain Athe Aphysical Adata Astorage Acharacteristics.
data Aintegrity A- Acorrect AAnswers A✔✔ A-In Aa Arelational Adatabase, Arefers Ato Aa
Acondition Ain Awhich Athe Adata Ain Athe Adatabase Ais Ain Acompliance Awith Aall Aentity
Aand Areferential Aintegrity Aconstraints.
data Amanagement A- Acorrect AAnswers A✔✔ A-A Aprocess Athat Afocuses Aon Adata
Acollection, Astorage, Aand Aretrieval. ACommon Adata Amanagement Afunctions Ainclude
Aaddition, Adeletion, Amodification, Aand Alisting.
