Relational databases

Easy
123456789101112131415161718192021222324252627282930313233343536373839
Question 14
Easy

Submersible Logistics Database

Submersible

SubIDModelNameMaxDepthMeters
SUB-01Triton-33001000
SUB-02Deepflight120
SUB-03Alvin-V6500
SUB-04Nereus-II11000

Researcher

ResearcherIDFamilyNameSpecialtyIsCertified
RES-92Dr. VanceAbyssal FaunaTrue
RES-41Prof. ChenHydrothermal VentsTrue
RES-18Dr. RossiMarine GeophysicsTrue
RES-07Dr. TanakaMicroplasticsFalse

DiveSession

SessionIDSubIDResearcherIDOxygenConsumptionRate
DIV-901SUB-03RES-920.45
DIV-902SUB-01RES-410.32
DIV-903SUB-02RES-180.28
DIV-904SUB-04RES-070.51
DIV-905SUB-03RES-180.42

State the most suitable data type for the OxygenConsumptionRate field in the DiveSession table.

[1]

Relational databases Questions

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