Relational databases

Easy
123456789101112131415161718192021222324252627282930313233343536373839
Question 39
Easy

Marine Research Database

TagType

TagCodeSensorDescription
GPS01GPS Location Tracker
ACC02Tri-axial Accelerometer
TMP03Water Temperature Probe
PAT4Pop-up Archival Transmitting

MarineSpecimen

SpecimenIDSpeciesNameEstimatedAgeIsRehab
S301Caretta caretta12True
S302Chelonia mydas15False
S405Dermochelys coriacea8True
S108Eretmochelys imbricata6False

Deployment

DeploymentIDSpecimenIDTagCodeBatteryVoltage
D901S301GPS013.65
D902S302ACC023.20
D903S405TMP032.85
D904S108PAT43.60
D905S301TMP031.45

State the most suitable data type for the BatteryVoltage field in the Deployment table.

[1]

Relational databases Questions

  1. GCSE
  2. /Computer Science
  3. /Relational databases