Note AcademyNote Academy

Computer Science · May / June 2023 · Paper 2 HL · Question 3

IBCS

As printed in the paper

The question as text

3. Artisan College has the following data about students and the courses they have chosen. STUDENT table StudentID FName SName MajorID Major CourseNum CourseName 2907 Jacob Smith MAT Mathematics MAT0011 MAT0027 EGL0010 Discrete Maths Calculus I Classics I 4019 Jane Paterson PHI Philosophy PHI0010 CS00100 Philosophy Programming 1 5145 Norris Neeld EGL English SOC0102 Ascent of man 6132 Xavier Morrison MUS Music MUS0002 SOC0102 Origin of jazz Ascent of man 8966 Samantha Juarez EGL English EGL0010 EGL0101 Classics I Shakespeare II The table can also be represented in the following form. STUDENT (StudentID, FName, SName, MajorID, Major, CourseNum, CourseName)

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

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

  • 3(b)[8]

  • 3(c)[5]

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