Unit 3: A3 Databases
Topic 3.1: Relational databases Questions
Practice 20 exam-style questions for IB Computer Science Topic 3.1. Review the question stems below, then unlock the full Question Bank to access markschemes, model answers, and AI grading.
1Identify1 mark
2026
Identify the type of relationship between Students and Subjects when each student takes several subjects and each subject is taken by several students.
Markscheme and model answer locked
Unlock Question2Explain4 marks
2026
Explain why a many-to-many relationship cannot be implemented directly with two tables.
Markscheme and model answer locked
Unlock Question3Outline3 marks
2026
Outline the structure of the link table needed between Students and Subjects.
Markscheme and model answer locked
Unlock Question4Suggest3 marks
2026
Suggest one situation in which a spreadsheet is the better choice.
Markscheme and model answer locked
Unlock Question5Outline2 marks
2026
Outline what is meant by a database management system.
Markscheme and model answer locked
Unlock Question6Explain3 marks
2026
Explain why a database separates the logical structure of the data from how it is physically stored.
Markscheme and model answer locked
Unlock Question8Define1 mark
2026
Define the term relational database.
Markscheme and model answer locked
Unlock Question9Outline2 marks
2026
Outline the difference between a record and a field.
Markscheme and model answer locked
Unlock Question10Outline2 marks
2026
Outline what is meant by a primary key.
Markscheme and model answer locked
Unlock Question11Explain3 marks
2026
Explain why a database designer would add a StudentID field rather than using a student's name as the primary key.
Markscheme and model answer locked
Unlock Question12Outline2 marks
2026
Outline what is meant by a foreign key.
Markscheme and model answer locked
Unlock Question13Explain3 marks
2026
Explain how a foreign key enforces referential integrity.
Markscheme and model answer locked
Unlock Question14Explain3 marks
2026
Explain what would happen without referential integrity when a book is deleted from a library database.
Markscheme and model answer locked
Unlock Question15Outline2 marks
2026
Outline what is meant by a composite key.
Markscheme and model answer locked
Unlock Question16Explain4 marks
2026
Explain two advantages of a relational database over storing the same data in one large spreadsheet.
Markscheme and model answer locked
Unlock Question17Explain4 marks
2026
Explain two functions a database management system performs that an application would otherwise have to implement.
Markscheme and model answer locked
Unlock Question18Suggest4 marks
2026
Suggest why a bank's database must not allow two simultaneous withdrawals to both succeed against insufficient funds.
Markscheme and model answer locked
Unlock Question20Choose1 mark
2026
Choose the field that would make the best primary key for a table of library books.
Markscheme and model answer locked
Unlock QuestionReady to practice Topic 3.1?
Get instant AI feedback on your answers, view detailed markschemes, and track your progress across all IB Computer Science topics.
Start Practising Now