Note AcademyNote Academy

Computer Science (AS & A Level) · Oct / Nov 2022 · Paper 13 · Question 2

9618

As printed in the paper

The question as text

The relational database ASTRONOMY is used to store data about telescopes, the companies that own the telescopes and the photographs taken by the telescopes. The database has these three tables: COMPANY(TelephoneNumber, CompanyID, CompanyName) PHOTOGRAPH(PhotoID, TelescopeID, DateTaken, TimeTaken, Elevation) TELESCOPE(TelescopeID, CompanyID, SerialNumber)

Read automatically from the paper; the printed page above is exact.

Show the answer and mark scheme
  • 2(a)[3]

  • 2(b)[1]

  • 2(c)[4]

  • 2(d)[2]

  • 2(e)[2]

  • 2(f)[2]

Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.