&2) Q AND A
Thecfmajorcfpurposecfofcfacfdatabasecfiscftocf-cfanswer--Keepcftrackcfofcfandcforganizecfdata
Whichcfofcfthecffollowingcfproblemscfassociatedcfwithcfstoringcfdatacfincfacflistcfiscfavoidedcfb
ycfstoringcfdatacfincfacfrelationalcfdatabase?cf-cfanswer--
Thecflistcfcancfresultcfincfinconsistentcfdata
Whencfworkingcfwithcfdatacfincfacflist,cfifcfthecfremovalcfofcfonecfrecordcfresultscfincfthecfremov
alcfofcfancfentirecfthemecfofcfinformation,cfwhatcfkindcfofcfmodificationcfproblemcfdoescfthiscfp
resentcf-cfanswer--Delete
Whencfworkingcfwithcfdatacfincfacflist,cfifcfchangingcfinformationcfincfonecfrecord,cfcausescfso
mecfofcfthecfothercfdatacfincfthecflistcftocfbecomecfinconsistent,cfwhatcfkindcfofcfmodificationcf
problemcfdoescfthiscfpresent?cf-cfanswer--Update
Whencfworkingcfwithcfdatacfincfacflist,cfifcfaddingcfdatacfcausescfmissingcfdata,cfwhatcfkindcfof
cfmodificationcfproblemcfdoescfthiscfpresent?cf-cfanswer--Insert
Todaycfalmostcfeverycfcommercialcfdatabasecfiscfbasedcfon:cf-cfanswer--
thecfrelationalcfmodel
Acfrelationalcfdatabasecfstorescfdatacfincfthecfformcfof:cf-cfanswer--tables
SQLcfstandscfforcf-cfanswer--StructuredcfQuerycfLanguage
Whichcfofcfthecffollowingcfiscfnotcfacfbasiccfcomponentcfofcfacfdatabasecfsystem?cf-
cfanswer--ERD
Whichcfofcfthecffollowingcfwouldcfbecfancfexamplecfofcfdatabasecfmetadata?cf-cfanswer--
Namescfofcftablescfincfacfdatabase
Thecfcreationcfofcfacfdatabasecfandcfitscftablescfiscfacffunctioncfofcfwhichcfcomponentcfofcfthec
fdatabasecfsystemcf-cfanswer--DatabasecfManagementcfSystem
WhichcfofcfthecffollowingcfiscfacffunctioncfofcfthecfDBMScf(databasecfmanagementcfsystem)c
fincfacfdatabasecfsystem?cf-cfanswer--Controlscfconcurrency
________________cfsitscfbetweencfthecfendcfusercfandcfthecfDBMScf(DatabasecfManage
mentcfSystem)cf-cfanswer--DatabasecfApplication
MicrosoftcfSQLcfServercfiscfancfexamplecfofcfa:cf-cfanswer--
databasecfmanagementcfsystem.