Practice IB Computer Science (CS) Topic A. Databases with authentic exam-style questions for both SL and HL students. This question bank focuses on the exact syllabus content for A. Databases and mirrors Paper 1, 2, 3 style where relevant.
Get instant solutions, detailed explanations, and build confidence with questions aligned to IB examiner expectations.
(a) the term tuple.
(b) The table below, COURSE_REGISTRATION, stores information about students and the modules they have joined.
| Student_ID | Course_ID |
|---|
(e) the difference between 2nd Normal Form (2NF) and 3rd Normal Form (3NF).
(e) how predictive modeling could be used by EduBooks to forecast popular book genres for next season.
(e) how a database management system (DBMS) handles security using access control.
| Registration_Date |
|---|
| S788 | CS102 | 2023-08-15 |
| S788 | MA105 | 2023-08-15 |
| S902 | CS102 | 2023-08-16 |
the primary key for this table and your choice.
(d) three reasons for implementing views (virtual tables) in a relational database.
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 | | VIOLIN,
PERCUSSION | Tampines | 512233 | 065544335,
065544336 |
| 306 | MARY | ALCHIN | | GUITAR,
KEYBOARD | Arab
Street | 198876 | 065543213 |
| 307 | RAM | WONG | | GUITAR | Bedok | 467501 | 06543321,
065433222 |
| 308 | KATE | MOHAMA | | PERCUSSION | Simei | 512233 | 065444412 |
| 309 | RYAN | TAN | | GUITAR | Seng
Kang | 208563 | 065667898 |
| 310 | PHILIP | BALMER | | VIOLIN | Orchard | 309893 | 065756379 |
| 311 | MIKE | MOSES | | GUITAR | Clementi | 308978 | 065745677 |
| | | | | | | | |
(a) one benefit of normalizing a database.
(b) three ways that incorrect data could be prevented from being added into the School_phone_no field.
(c) what would be necessary to make the above unnormalized table conform to 1st Normal Form (1NF).
(d) the 3rd Normal Form (3NF) of the unnormalized relation shown above.
EduBooks Ltd. is a global distributor of educational materials and uses a data warehouse to store data on customer preferences, sales trends, and market research. They aim to use this data to improve targeted marketing strategies.
(a) why data warehousing is beneficial for long-term business intelligence.
(b) one reason why EduBooks would choose to use a data warehouse instead of operational databases for analytics.
(c) the importance of data cleaning in EduBooks' ETL process before loading data into the warehouse.
(d) the techniques of cluster analysis and classification as methods for identifying patterns in EduBooks’ data.
(a) two issues that can occur when a database suffers from an update anomaly.
(b) the term referential integrity.
(c) the importance of consistency in a database transaction.
(d) between the conceptual schema and the external schema in the database architecture.
A large online retail company is relocating to a new purpose-built site and is considering incorporating cloud computing into its IT strategy.
(a) two architectural features that are essential components of a viable public cloud computing model.
(b) how this particular company might use a hybrid approach.
