Description
30 scenario-based multiple-choice questions in which students distinguish between SQL (relational) Databases and NoSQL Databases. Each question presents a realistic software development or data management scenario requiring students to evaluate data structure, scalability needs, and ACID vs. BASE trade-offs. Designed for Computer Science, AP Computer Science Principles, and Database Management courses.
Use as a bell ringer, exit ticket, unit review, sub plan, homework, or test prep activity for the the computer science and data management unit.
No more printing or correcting, in an LMS it corrects itself! No more passing out the papers, or collecting them, or returning them, you are done with all of that!…you are welcome!
This practice is suitable for any LMS that will upload Blackboard 7.1-9.0 files. This is the zip file that you upload and does not need to be unzipped and will not unzip into any documentation or test text. THE ZIP FILE DOES NOT UNZIP INTO A HARD COPY OF A TEST.
Test file, will my “Schoology” items work for you…test an example before you buy.
I have a ton more Computer Science and Technology content in my store, check it out!
You have managed to find the source of the best activities on TPT, go check out my store for other awesome resources, I currently have hundreds of different items!
https://www.teacherspayteachers.com/Store/Brian-Garber
Keywords: SQL, NoSQL, relational database, document database, MongoDB, structured data, computer science, MCQ
Learning Objectives
Students will be able to:
Define SQL databases as relational systems organizing data in structured tables with fixed schemas and Structured Query Language.
Define NoSQL databases as flexible systems using document, key-value, graph, or wide-column data models without fixed schemas.
Compare ACID compliance (SQL) with BASE consistency model (NoSQL) and explain when each is appropriate.
Evaluate which database type best fits a given use case based on data structure, scalability, and consistency requirements.
Success Criteria
Students demonstrate mastery when they can:
Correctly identify whether a described application scenario is better served by SQL (structured, relational, ACID-required) or NoSQL (flexible schema, horizontal scaling, high volume).
Explain the trade-off: SQL prioritizes data integrity and complex relational queries; NoSQL prioritizes flexibility, scalability, and performance for specific access patterns.
Describe horizontal scaling (NoSQL advantage) vs. vertical scaling (traditional SQL approach) and explain why large-scale web applications often choose NoSQL.
Standards Alignment
CSTA K-12 Computer Science Standards
- 3A-DA-09: Translate between different bit representations of real-world phenomena.
- 3A-CS-01: Explain how abstractions hide complexity of hardware and software.
- 3B-DA-05: Use data analysis tools to identify patterns in data.
ISTE Standards for Students
- 1d: Knowledge Constructor — use technology to seek information and create knowledge.
- 5c: Computational Thinker — break problems into components and design solutions.
CCSS — Mathematical Practices
- MP.2: Reason abstractly and quantitatively.
- MP.6: Attend to precision.
AP Computer Science Principles — College Board
- Big Idea 2: Data; Big Idea 3: Algorithms and Programming
Highlights
Description
30 scenario-based multiple-choice questions in which students distinguish between SQL (relational) Databases and NoSQL Databases. Each question presents a realistic software development or data management scenario requiring students to evaluate data structure, scalability needs, and ACID vs. BASE trade-offs. Designed for Computer Science, AP Computer Science Principles, and Database Management courses.
Use as a bell ringer, exit ticket, unit review, sub plan, homework, or test prep activity for the the computer science and data management unit.
No more printing or correcting, in an LMS it corrects itself! No more passing out the papers, or collecting them, or returning them, you are done with all of that!…you are welcome!
This practice is suitable for any LMS that will upload Blackboard 7.1-9.0 files. This is the zip file that you upload and does not need to be unzipped and will not unzip into any documentation or test text. THE ZIP FILE DOES NOT UNZIP INTO A HARD COPY OF A TEST.
Test file, will my “Schoology” items work for you…test an example before you buy.
I have a ton more Computer Science and Technology content in my store, check it out!
You have managed to find the source of the best activities on TPT, go check out my store for other awesome resources, I currently have hundreds of different items!
https://www.teacherspayteachers.com/Store/Brian-Garber
Keywords: SQL, NoSQL, relational database, document database, MongoDB, structured data, computer science, MCQ
Learning Objectives
Students will be able to:
Define SQL databases as relational systems organizing data in structured tables with fixed schemas and Structured Query Language.
Define NoSQL databases as flexible systems using document, key-value, graph, or wide-column data models without fixed schemas.
Compare ACID compliance (SQL) with BASE consistency model (NoSQL) and explain when each is appropriate.
Evaluate which database type best fits a given use case based on data structure, scalability, and consistency requirements.
Success Criteria
Students demonstrate mastery when they can:
Correctly identify whether a described application scenario is better served by SQL (structured, relational, ACID-required) or NoSQL (flexible schema, horizontal scaling, high volume).
Explain the trade-off: SQL prioritizes data integrity and complex relational queries; NoSQL prioritizes flexibility, scalability, and performance for specific access patterns.
Describe horizontal scaling (NoSQL advantage) vs. vertical scaling (traditional SQL approach) and explain why large-scale web applications often choose NoSQL.
Standards Alignment
CSTA K-12 Computer Science Standards
- 3A-DA-09: Translate between different bit representations of real-world phenomena.
- 3A-CS-01: Explain how abstractions hide complexity of hardware and software.
- 3B-DA-05: Use data analysis tools to identify patterns in data.
ISTE Standards for Students
- 1d: Knowledge Constructor — use technology to seek information and create knowledge.
- 5c: Computational Thinker — break problems into components and design solutions.
CCSS — Mathematical Practices
- MP.2: Reason abstractly and quantitatively.
- MP.6: Attend to precision.
AP Computer Science Principles — College Board
- Big Idea 2: Data; Big Idea 3: Algorithms and Programming
