Intro To Databases Exam 1 Q And A

INTRO TO DATABASES EXAM 1 Q AND
A

Objectcfincfthecfrealcfwordcfwithcfancfindependentcfexistencecfthatcfcancfbecfdifferentiatedcffr
omcfothercfobjects,cfhascfacfphysicalcfexistence,cfandcfacfconceptualcfexistence.cf-
cfanswer--Entity



Whatcfarecfthecfcharacteristicscfofcfacfrelationalcfdatabase?cf-cfanswer---
Valuescfarecfatomic
-Columncfvaluescfarecfofcfthecfsamecfkind
-Eachcfrowcfifcfunique
-thecfsequencecfofcfcolumnscfandcfrowscfarecfinsignificantcf
-Eachcfcolumncfhascfacfuniquecfname

CandidatecfKeycf-cfanswer--
Thecfsetcfofcfallcfkeyscfthatcfarecfeligiblecftocfbecomecfuniquecfkeys

KeyscfthatcfarecfgeneratedcfbycfthecfDBMScf-cfanswer--Surrogatecfkeys

Givencfthecfrelations:

cf STUDENTcf(SID,cfStudentName,cfMajor,cfAdvisorID)

WhichcfofcfthecffollowingcfiscftruecfincfreferencecftocfthecfSTUDENTcftablecf-cfanswer--
SIDcfiscfthecfprimarycfkey

Acfprimarycfkeycfis


Allcfofcfthecfabove


usedcftocfidentifycfuniquecfrows


acfcandidatecfkey


usedcftocfrepresentcfrowscfincfrelationships

IncorrectcfResponse
requiredcftocfbecfuniquecf-cfanswer--Allcfofcfthecfabove

Whencfthecfprimarycfkeycfofcfonecfrelationcfiscfplacedcfintocfacfsecondcfrelation,cfitcfiscfcalledcf
a

, FeildcfKey


ForeigncfKey


PrimarycfKey


CandidatecfKey


CompisitecfKeycf-cfanswer--ForeigncfKey

Identifycfthecfthemescfincfthecfrelationcfbelow

TREATMENT(DoctorID,cfDoctorName,cfDoctorPhone,cfPatientID,cfPatientName,cfPatie
ntPhone,cfInsuranceName,cfInsuranceType,cfInsuranceContactNumber)


DOCTOR,cfPATIENTcf


DOCTOR,cfHOSPITAL


DOCTOR,cfPATIENT,cfHOSPITAL


DOCTOR,cfPATIENT,cfINSURANCEcf-cfanswer--DOCTOR,cfPATIENT,cfINSURANCE

Acfcandidatecfkeycfis/can


usedcftocfrepresentcfrowscfincfrelationships


acfcandidatecftocfbecfthecfprimarycfkey


Allcfofcfthecfabove


Cancfconsistcfofcfcompositecfkeys


requiredcftocfbecfuniquecf-cfanswer--Allcfofcfthecfabove