Practice IB Computer Science (First Exam 2027) Topic A3.2 Database Design with authentic exam-style questions for both SL and HL students. This question bank focuses on the exact syllabus content for A3.2 Database Design and mirrors Paper 1, 2 style where relevant.
Get instant solutions, detailed explanations, and build confidence with questions aligned to IB examiner expectations.
A field is defined to store a percentage as a whole number between 0 and 100, but is given a data type that also permits negative values. the risk this creates.
An airline holds one table of bookings, BOOKING (BookingRef, FlightNo, DepartureAirport, PassengerID, PassengerName).
why DepartureAirport violates third normal form.
A table is said to be in first normal form. what this requires.
A designer chooses a fixed-length text type of 50 characters for a field storing surnames. two consequences of this choice.
An ERD shows a relationship between STUDENT and LOCKER in which a student may or may not be assigned a locker. what modality expresses in this relationship.
