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

Desafío de Normalización Relacional

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

Desafío de Normalización Relacional

Quiz

Played 0
Create copy

About this activity

Quiz sobre 1FN, 2FN y 3NF

Created by

Yitzel Martínez
Yitzel Martínez
Mexico

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
Desafío de Normalización Relacional
 

Desafío de Normalización RelacionalOnline version

Quiz sobre 1FN, 2FN y 3NF

by Yitzel Martínez
1

¿Qué define la 1FN en una tabla relacional?

2

¿Qué implica la 2FN?

3

En 3FN, ¿qué aspecto es crucial?

4

¿Qué es una dependencia funcional?

5

¿Qué es una clave candidata?

6

¿Qué se busca al normalizar hasta 3FN?

7

¿Qué es una dependencia parcial?

8

¿Qué pasa si una tabla no está en 1FN?

9

¿Qué son las anomalías de actualización?

10

¿Qué es una relación en el modelo relacional?

Explicación

La atomicidad de celdas es el requisito básico de 1FN.

En 2NF todas las dependencias deben depender de la clave completa.

3NF exige que los atributos no clave no dependan de otros atributos no clave.

La dependencia funcional describe determinación entre atributos.

Las claves candidatas compiten para ser clave primaria.

La normalización reduce redundancia y anomalías de actualización.

La dependencia parcial impide pasar a 2NF.

Sin atomicidad, no se puede asegurar consistencia de datos.

La normalización busca evitar anomalías de actualización.

Una relación es una tabla con filas y columnas.

 
Are you sure you want to leave the page?

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