Computer Science · May / June 2018 · Paper 2 SL · Question 3
IBCS
As printed in the paper
The question as text
3. Jackson City University has a Music Department that provides music lessons to students in a number of high schools in the city. The Jackson City University Music Department teachers visit the different schools in the city to teach students a range of musical instruments. The following diagram shows an unnormalized table of student data. Student_ ID First_ Name Family_ Name Date_of_ birth Student_Choice School School_ Post_Code School_ phone_no 305 JOE PARKAR 02/09/2000 VIOLIN, PERCUSSION Tampines 512233 065544335, 065544336 306 MARY ALCHIN 01/06/2000 GUITAR, KEYBOARD Arab Street 198876 065543213 307 RAM WONG 23/03/1999 GUITAR Bedok 467501 065433221, 065433222 308 KATE MOHAMA 17/08/1999 PERCUSSION Simei 512233 065444412 309 RYAN TAN 02/09/2000 GUITAR Seng Kang 208563 065667898 310 PHILIP BALMER 10/10/1999 VIOLIN Orchard 309893 065756379 311 MIKE MOSES 10/11/2000 GUITAR Clementi 308978 065745677 … … … … …
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
3(a)[3]
3(b)[3]
3(c)[2]
3(d)[8]
3(e)[3]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.