Design, Implementation Database Systems:, and Management review with correct answers 2026

Design, Implementation Database
Systems:, and Management review
with correct answers 2026




Datavg
Rawvfacts,vsuchvasvavtelephonevnumber,vavbirthvdate,vavcustomervname,vorvavyear-
todatevsalesvvalue.vDatavhasvlittlevmeaningvunlessvitvhasvbeenvprocessed.



Fieldvg
Avcharactervorvgroupvofvcharactersv(alphabeticvorvnumeric)vthatvhasvavspecificvmeaning.vAvfieldvisvu
sedvtovdefinevandvstorevdata.v(Alsovknownvasvanvattributevinvdatabasevmodeling).Avcharactervorvgr
oupvofvcharactersv(alphabeticvorvnumeric)vthatvhasvavspecificvmeaning.vAvfieldvisvusedvtovdefinevan
dvstorevdata.v(Alsovknownvasvanvattributevinvdatabasevmodeling).



Recordvg
Avlogicallyvconnectedvsetvofvonevorvmorevfieldsvthatvdescribesvavperson,vplace,vorvthing.vForvexamp
le,vthevfieldsvthatvconstitutevinformationvforvavspecificvcustomer.

,Filevg
Avcollectionvofvrelatedvrecords.vForvexample,vavfilevcontainingvallvthevrecordsvforvthevcustomersvofv
avspecificvcompany
Whatvisvdatavredundancy,vandvwhichvcharacteristicsvofvthevfilevsystemvcanvleadvtovit?vvcorrectvans
wers-
DatavRedundancyvexistsvwhenvthevsamevdatavisvstoredvunnecessarilyvatvdifferentvplaces.

FilevSystemvCharacteristics:vItvoccursvinvfilevsystemsvbecausevofvthevlackvofvcentralvdatavcontrol.vDif
ferentvdepartmentsv(e.g.,vSalesvandvHR)vcreatevtheirvownvindependentvfilesv("islandsvofvinformati
o
n").vIfvavcustomervisvalsovanvemployee,vtheirvaddressvmightvbevstoredvinvtwovcompletelyvseparatevf
i les.



Whatvisvdatavindependence,vandvwhyvisvitvlackingvinvfilevsystems?vg
DatavIndependencevisvavconditionvinvwhichvdatavaccessvisvunaffectedvbyvchangesvinvthevphysicalvda
tavstoragevcharacteristics.

Whyvitvisvlacking:vFilevsystemsvexhibitvdatavdependence.vThevfilevstructurev(howvthevdatavisvstored)
v

isvhardcodedvintovthevapplicationvprogram.vIfvyouvchangevthevdatavtypevofvavfieldv(e.g.,vIntegervtovF
loat),vy ouvmustvmodifyveveryvprogramvthatvaccessesvthatvfile.



WhatvisvavDBMS,vandvwhatvarevitsvfunctions?vg
AvDatabasevManagementvSystemv(DBMS)visvavcollectionvofvprogramsvthatvmanagesvthevdatabasevs
tructurevandvcontrolsvaccessvtovthevdatavstoredvinvthevdatabase.

KeyvFunctions:

DatavDictionaryvManagement:vStoresvdefinitionsvofvthevdatavelementsvandvtheirvrelationshipsv(me
tadata).

DatavStoragevManagement:vCreatesvandvmanagesvthevcomplexvstructuresvrequiredvforvdatavstora
g e.

DatavTransformationvandvPresentation:vTransformsventeredvdatavtovconformvtovrequiredvdatavstr
u ctures.

SecurityvManagement:vEnforcesvuservsecurityvandvdatavprivacy.

,MultiuservAccessvControl:vAllowsvmultiplevusersvtovaccessvthevdatabasevsimultaneouslyvwithoutvc
ompr omisingvintegrity.

BackupvandvRecoveryvManagement:vEnsuresvdatavrecoveryvaftervavfailure.

DatavIntegrityvManagement:vEnforcesvrulesvtovminimizevdatavredundancyvandvmaximizevconsiste
n cy.

DatabasevAccessvLanguagesvandvAPIs:vProvidesvdatavaccessvviavqueryvlanguagesv(likevSQL).

DatabasevCommunicationvInterfaces:vAllowsvthevDBMSvtovacceptvenduservrequestsvviavmultiplevn
etworkvenvironments.



Whatvisvstructuralvindependence,vandvwhyvisvitvimportant?vg
StructuralvIndependencevexistsvwhenvitvisvpossiblevtovmakevchangesvinvthevfilevstructurevwithoutva
ffectingvthevapplicationvprogram'svabilityvtovaccessvthevdata.

Importance:vItvsignificantlyvreducesvmaintenancevcosts.vWithoutvit,vaddingvavsinglevnewvfieldvtovavr
ecordvwouldvrequirevrewritingvallvcodes/programsvthatvreadvthatvrecord.



Explainvthevdifferencesvamongvdata,vinformation,vandvavdatabase.v-
vcorrectvanswersData:vRawvfacts;vthevbuildingvblocksvofvinformationv(e.g.,v98.6).



Information:vProcessedvdata;vdatavpresentedvinvavmeaningfulvcontextv(e.g.,vPatientvTemperature:v
98.6°F).

Database:vAvshared,vintegratedvcomputervstructurevthatvstoresvbothvthevenduservdatav(rawvfacts)v
andvthevmetadatav(descriptionvofvdatavstructure).



WhatvisvthevrolevofvavDBMS,vandvwhatvarevitsvadvantages?vWhatvarevitsvdisadvantages?vvcorrectvan
swers-
Role:vThevDBMSvservesvasvthevintermediaryvbetweenvthevuserv(orvapplication)vandvthevdatabase.

Advantages:

Improvedvdatavsharing.

Improvedvdatavsecurity.

Bettervdatavintegration.

, Minimizedvdatavinconsistency.

Improvedvdatavaccessv(viavqueryvlanguages).

Improvedvdecision-making.

Disadvantages:

Increasedvcosts:vHighvinitialvinvestmentvinvhardware/software.

Managementvcomplexity:vRequiresvskilledvpersonnelv(DBAs).

maintainingvcurrency:vKeepingvthevsystemvupvtovdatevisvcostly.

Vendorvdependence:vTiedvtovonevspecificvplatformv(e.g.,vOracle,vSQLvServer).

Frequentvupgrade/replacementvcycles.



Listvandvdescribevthevdifferentvtypesvofvdatabases.vgNumbervofvUsers:

Single-uservdatabase:vSupportsvonevuservatvavtime.v(Desktopvdatabase).

Multiuservdatabase:vSupportsvmultiplevusersv(Workgroupv=v<50vusers;vEnterprisev=v>50vusers).

Location:

Centralizedvdatabase:vDatavlocatedvatvavsinglevsite.

Distributedvdatabase:vDatavdistributedvacrossvdifferentvsites.

Cloudvdatabase:vCreatedvandvmaintainedvusingvcloudvdatavservices.

Use:

General-purpose:vContainsvavwidevvarietyvofvdatav(e.g.,vProQuest).

Discipline-specific:vFocusedvonvspecificvareasv(e.g.,vGISvorvmedical).

Operationalv(OLTP):vSupportsvday-to-dayvtransactions.

Analyticalv(OLAP):vStoresvhistoricalvdatavforvbusinessvintelligence.



Whatvarevthevmainvcomponentsvofvavdatabasevsystem?v-
vcorrectvanswersHardware:vThevphysicalvdevicesv(computers,vstorage,vnetworkvdevices).




Software:vOperatingvsystemvsoftware,vDBMSvsoftware,vandvApplicationvprograms/utilities.