IB Computer Science Topic A. Databases Questionbank…

Report an issue

This site uses cookie tracking technologies. Learn more in our Cookie Policy.

IB Computer Science Topic A. Databases Questionbank… | RevisionDojo

Question

SLPaper 2

View answer

(a)

the term tuple.

[1]

(b)

The table below, COURSE_REGISTRATION, stores information about students and the modules they have joined.

(c)

the purpose of a Data Manipulation Language (DML).

[2]

(d)

three reasons for implementing views (virtual tables) in a relational database.

[3]

SLPaper 2

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 | $02 / 09 / 2000$ | VIOLIN,
PERCUSSION | Tampines | 512233 | 065544335,
065544336 | | 306 | MARY | ALCHIN | $01 / 06 / 2000$ | 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 | | | | | | | | | |

HLPaper 2

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)

(a) (i) why data warehousing is beneficial for long-term business intelligence.

[2]

(b)

(a) (ii) one reason why EduBooks would choose to use a data warehouse instead of operational databases for analytics.

[2]

SLPaper 2

(a)

two issues that can occur when a database suffers from an update anomaly.

[2]

(b)

the term referential integrity.

[2]

(c)

the importance of consistency in a database transaction.

SLPaper 2

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.

[4]

(b)

how this particular company might use a hybrid approach.

[6]

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.

S788	CS102	2023-08-15
S788	MA105	2023-08-15
S902	CS102	2023-08-16

IB Computer Science A. Databases Questionbank

IB Computer Science A. Databases Questionbank

IB Computer Science A. Databases Questionbank

IB Computer Science A. Databases Questionbank

IB Computer Science (CS) Topic A. Databases Questionbank