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