New game
Download
SCORM download
To be used in an LMS (Moodle, Blackboard...)
Regular download
To be published on a website or blog.
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.
Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.
Get Academic Plan
If you wish, you can download a demo game here and test its integration:
Share game
Quiz
Quiz

Data Basics & MySQL Quiz

Integrate it into your platform
G. Classroom M. Teams
You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.
Download
You have exceeded the maximum number of games you can integrate into Google Classroom with your current Plan.

To integrate as many games as you want in Google Classroom, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
You have exceeded the maximum number of games you can integrate into Microsoft Teams with your current Plan.

To integrate as many games as you want in Microsoft Teams, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.

Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.

If you wish, you can download a demo game here and test its integration:

Get Academic Plan

Data Basics & MySQL Quiz

Quiz

Played 0
Create copy

About this activity

Fundamental data modeling and SQL concepts

Created by

Hernán Schramm
Hernán Schramm
Argentina

Download the paper version to play

Make your own free game from our game creator
Compete against your friends to see who gets the best score in this game
Make challenge

Top Games

 %
Anonymous
Anonymous
 %
%
%
You have exceeded the maximum number of games you can print with your current Plan.

To print as many games as you want, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Print your game
Data Basics & MySQL Quiz
 

Data Basics & MySQL QuizOnline version

Fundamental data modeling and SQL concepts

by Hernán Schramm
1

What does ER in ER model stand for?

2

In a relational table, what is a PRIMARY KEY?

3

What does 1NF require in a table?

4

What is the purpose of a FOREIGN KEY?

5

Difference between INNER JOIN and LEFT JOIN?

6

What is 3NF about in normalization?

7

Which data type is best for monetary values with decimals?

8

What does AUTO_INCREMENT do in MySQL?

9

Which SQL command fetches data from tables with a join?

10

What is a data model used for in databases?

Feedback

ER models map real-world entities, their attributes, and how they relate.

PK uniquely identifies each record and is not NULL.

1NF eliminates multi-valued fields; each cell is atomic.

FK enforces referential integrity by linking tables.

INNER JOIN requires matches in both tables; LEFT JOIN keeps all left rows.

3NF reduces redundancy by separating dependent attributes.

DECIMAL provides fixed precision suitable for money.

AUTO_INCREMENT generates unique consecutive IDs.

Use SELECT ... FROM ... JOIN ... to retrieve joined data.

A data model outlines structure, entities, and relationships.

 
Are you sure you want to leave the page?

If you leave the page, you will lose your game progress.