Computer Science · Oct / Nov 2023 · Paper 2 SL · Question 3
Adapt for 2027ERDs and normalizing to 3NF are A3.2.2 and A3.2.6, but secondary keys and data protection law are not in the current syllabus.
IBCS
As printed in the paper
The question as text
3. A European pet passport allows pets to travel between countries in the European Union. All pets have a microchip inserted that gives them a unique alphanumeric transponder code. The data contained in a pet passport is shown in Figure 1. All of the data is stored in a database. Figure 1: Two pages of a pet passport O F F I C I A L V E T E R I N A R I A N U N I T E D K I N G D O M H Brih Name: Benji Species: Dog Breed: Labrador Date of birth: 01/01/2017 Sex: Male Alphanumeric transponder code: 985 AAA 111 AAA 111 PICTURE OF THE ANIMAL (optional) DESCRIPTION OF ANIMAL Name of the authorized veterinarian: Helen Bright Address: Lowden Bridge House, Lowther Street, Eskdale Postcode: CA37 8DX Country: United Kingdom Telephone number: 01632 960739 Email address: jkr@gov.example.com Date of issue: 26/01/2019 ISSUING OF PASSPORT A pet owner may have more than one pet, and each pet has their own passport. Pet passports are issued by registered veterinary surgeons (vets).
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
3(a)[2]
3(b)[1]
3(c)[8]
3(d)[4]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.

