Normalización de las bases de datos

Больше похоже на это

PROYECTO BASE DE DATOS INSTITUTO

от jhon fredy pacheco

ESTADISTICA DESCRIPTIVA E INFERENCIAL

от Itzel Nopal

RECOLECCION DE DATOS.

от Erem Kaneki

CRONOLOGÍA DEL FÚTBOL

от andres soria rojas

Normalización de las bases de datos

Elaborado por: Romero Tapia Miguel Angel

Grupo: 5501

Referencias:

• Silberschatz, A. (2006). Fundamentos de bases de datos (5a. ed.). Madrid etc, Spain: McGraw-Hill España. Recuperado de https://elibro.net/es/ereader/tese/50087?page=38.
• https://docs.microsoft.com/es-es/office/troubleshoot/access/database-normalization-description

Conflict is present everywhere in the world around us. We experience conflict on a daily basis, and it can be minor or major.

Conflict in a story is a struggle between opposing forces. Characters must act to confront those forces and there is where conflict is born. If there is nothing to overcome, there is no story. Conflict in a story creates and drives the plot forward.

Reglas de normalización

This situation results from a protagonist working against what has been foretold for that person. While this conflict was more prevalent in stories where gods could control fate, such as in ancient Greek dramas, there are still examples of this type of conflict in more contemporary literature.

Cuarto formulario normal

También llamado Formulario normal codd de Boyce (BCNF)

Tercer formulario formal

Puede ser más factible aplicar la tercera forma normal solo a los datos que cambian con frecuencia.

Los valores de un registro que no forman parte de la clave de ese registro no pertenecen a la tabla.

Elimina los campos que no dependen de la clave

Segundo formulario normal

Since in real life we can't say that such examples of man versus supernatural, there are some superstitions that can influence a person's life.

Give examples of these superstitions.

Los registros no deben depender de nada que no sea la clave principal de una tabla

Relaciona estas tablas con una clave externa.

Crea tablas independientes para conjuntos de valores que se aplican a varios registros.

Primer formulario normal

Give examples of man versus fate conflict in a literary work.

Identifica cada conjunto de datos relacionados con una clave principal.

Crea una tabla independiente para cada conjunto de datos relacionados.

Elimina los grupos de repetición en tablas individuales

Definición

A more contemporary type of conflict, this situation results from humans involved in a struggle with man-made machines. This is an external conflict.

Protege los datos para que la base de datos sea más flexible al eliminar la redundancia y la dependencia incoherente.

As this conflict is more science fiction based, in real life we can't find such examples.

However, as technology became a big part of our lives there are some situations that man made machines affects our lives.

Find such examples.

Es el proceso de organización de datos en una base de datos.

Give examples of man versus machine conflict in a literary work.

Propiedades no deseables

This conflict develops from a protagonist’s inner struggles and may depend on a character trying to decide between good and evil or overcoming self-doubt. This conflict has both internal and external aspects, as obstacles outside the protagonist's force them to deal with inner issues.

Imposibilidad de representar determinada información.

Give examples of man versus self conflict in the real world.

Repetición de la información

Give examples of man versus self conflict in a literary work.

Enfoque

In this type of conflict, a character is tormented by natural forces such as storms or animals. This is also an external conflict.

El enfoque más frecuente es usar dependencias funcionales.

Give examples of man versus nature conflict in the real world.

Diseñar esquemas que se hallen en la forma normal adecuada.

Give examples of man versus nature conflict in a literary work.

Objetivo

A situation in which two characters have opposing desires or interests. The typical scenario is a conflict between the protagonist and antagonist. This is an external conflict.

Crear tablas y establecer relaciones entre dichas tablas de acuerdo con reglas diseñadas

Permite recuperar la información con facilidad.

Give examples of man versus man conflict in the real world.

Genera un conjunto de esquemas de relaciones que permita almacenar información sin redundancias innecesarias.

Give examples of man versus man conflict in a literary work.