Note AcademyNote Academy

Computer Science · May / June 2019 · Paper 2 SL · Question 1

Adapt for 2027ERDs, data types, SQL queries, atomicity and redundancy are all on the course; atomicity and transactions are HL only (A3.3.6). Includes Higher Level only content, which Standard Level students do not study.

IBCS

As printed in the paper

The question as text

1. Marble Reading Book Stores (MRBS) is a chain of bookstores based in London. The stores want to keep information about the books they sell, the authors of the books and the publishers they work with. The assumptions made when the database was created were: • a publisher can publish books from one or more authors • an author can write one or more books.

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

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

  • 1(b)[2]

  • 1(c)[1]

  • 1(d)[4]

  • 1(e)[2]

  • 1(f)[2]

  • 1(g)[2]

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