Neemuch

Ejercicios Resueltos De Normalizacion De Base De - Datos Pdf 211

Planteamiento: Una tabla INSCRIPCIONES almacena datos de alumnos y cursos.

| Carnet_Estudiante | Nombre_Est | Cod_Curso | Nombre_Curso | Cod_Profesor | Nombre_Profesor | Salon | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | E001 | Mario | MAT101 | Algebra | P01 | Dr. House | A-1 | | E001 | Mario | FIS101 | Física | P02 | Dr. Wilson | B-2 | | E002 | Laura | MAT101 | Algebra | P01 | Dr. House | A-1 |

Clave Primaria: Carnet_Estudiante + Cod_Curso.

Esquema original:
R(A, B, C, D, E, F)

Dependencias funcionales:

Clave candidata:

Preguntas:

Table A: Students (Key: Student_ID) | Student_ID | Student_Name | | :--- | :--- | | 1001 | Ana Torres | | 1002 | Luis Rojas | | 1003 | Sofía Vargas |

Table B: Courses (Key: Course_Code) | Course_Code | Course_Name | Professor | Professor_Office | | :--- | :--- | :--- | :--- | | M101 | Math I | Dr. Gomez | Bldg A | | H205 | History | Dr. Perez | Bldg B | | Q110 | Chem | Dr. Liu | Bldg C |

Table C: Enrollments (Key: Student_ID + Course_Code) | Student_ID | Course_Code | Grade | | :--- | :--- | :--- | | 1001 | M101 | 85 | | 1001 | H205 | 90 | | 1002 | M101 | 78 | | 1003 | H205 | 92 | | 1003 | Q110 | 88 | Clave candidata:

Analysis: We are doing much better! But look at Table B (Courses). We still have a hidden issue.

Usamos el algoritmo de descomposición en 3FN preservando dependencias.

Paso 2.1: Crear tabla para A → B, C, D
R1(A, B, C, D) con clave A.

Paso 2.2: Crear tabla para A, E → F
R2(A, E, F) con clave (A,E).

Paso 2.3: ¿Perdemos algo? La dependencia D,E→F está implícita en las reglas originales pero no es necesaria porque ya tenemos A,E→F y A→D, entonces por transitividad D,E→F es redundante.

Resultado 3FN:

Verificación: Sin dependencias parciales ni transitivas. Todo atributo no clave depende directamente de la clave completa.

Here is the raw data:

| Student_ID | Student_Name | Course_Code | Course_Name | Professor | Professor_Office | Grade | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | 1001 | Ana Torres | M101, H205 | Math I, History | Dr. Gomez, Dr. Perez | Bldg A, Bldg B | 85, 90 | | 1002 | Luis Rojas | M101 | Math I | Dr. Gomez | Bldg A | 78 | | 1003 | Sofía Vargas | H205, Q110 | History, Chem | Dr. Perez, Dr. Liu | Bldg B, Bldg C | 92, 88 | Preguntas: Table A: Students (Key: Student_ID) | Student_ID

Problem: This table violates the most basic rule of databases. Columns like Course_Code and Grade contain multiple values. This makes searching impossible. (e.g., How do you find everyone taking History? You can't simply query "H205").

Espero que estos ejercicios resueltos te ayuden en tu comprensión de la normalización de base de datos y a mejorar tus habilidades en el diseño de bases de datos. Si tienes alguna otra pregunta o necesitas más ayuda, no dudes en preguntar.

Rule: The table must be in 2NF, and it must have no transitive dependencies.

A transitive dependency is like a chain: A determines B, and B determines C. In this case:

Therefore, Course_Code determines Professor_Office transitively. The office belongs to the professor, not the course directly. If Dr. Gomez moves to "Bldg D", we would have to update the Course table, which feels wrong. The Professor is a separate entity.

We split Table B again.

Enunciado:

Paso a paso:

Cómo convertir esto a PDF

Si quieres, genero un PDF listo con estos ejercicios y formato académico (portada, índice, soluciones paso a paso). ¿Deseas que lo prepare y te lo entregue como archivo descargable?

The number "211" in this context usually refers to a specific document ID or a page number within a larger collection of database design materials. Key Resources for Solved Exercises

If you are looking for actual solved problems (1FN, 2FN, 3FN), several high-quality PDF guides from universities and educational platforms provide practical examples: University Guides:

Universidad Nacional de Salta (UNSa) : Includes exercises on normalizing student and course tables up to 3FN.

Universidad de Zaragoza : Provides detailed "practical" guides explaining why 2FN is sometimes not enough and how to reach 3FN.

Universidad Carlos III de Madrid : Offers advanced exercises involving Boyce-Codd Normal Form (BCNF). Case Study Collections:

Guía de Ejercicios (grch.com.ar): Features a classic "Orders" table example, breaking down the transformation from unnormalized data to 3FN.

Scribd & SlideShare Collections: Host various "Guía 2" documents containing 5–8 solved exercises covering billing, library loans, and employee expenses. Common Steps in Solved Exercises

Most of these "PDF 211" resources follow a standard pedagogical path: En breve estrenaremos nueva web con tienda on-line a README file

You can use this text for a website description, a README file, a blog post, or a course syllabus.

Planteamiento: Una tabla INSCRIPCIONES almacena datos de alumnos y cursos.

| Carnet_Estudiante | Nombre_Est | Cod_Curso | Nombre_Curso | Cod_Profesor | Nombre_Profesor | Salon | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | E001 | Mario | MAT101 | Algebra | P01 | Dr. House | A-1 | | E001 | Mario | FIS101 | Física | P02 | Dr. Wilson | B-2 | | E002 | Laura | MAT101 | Algebra | P01 | Dr. House | A-1 |

Clave Primaria: Carnet_Estudiante + Cod_Curso.

Esquema original:
R(A, B, C, D, E, F)

Dependencias funcionales:

Clave candidata:

Preguntas:

Table A: Students (Key: Student_ID) | Student_ID | Student_Name | | :--- | :--- | | 1001 | Ana Torres | | 1002 | Luis Rojas | | 1003 | Sofía Vargas |

Table B: Courses (Key: Course_Code) | Course_Code | Course_Name | Professor | Professor_Office | | :--- | :--- | :--- | :--- | | M101 | Math I | Dr. Gomez | Bldg A | | H205 | History | Dr. Perez | Bldg B | | Q110 | Chem | Dr. Liu | Bldg C |

Table C: Enrollments (Key: Student_ID + Course_Code) | Student_ID | Course_Code | Grade | | :--- | :--- | :--- | | 1001 | M101 | 85 | | 1001 | H205 | 90 | | 1002 | M101 | 78 | | 1003 | H205 | 92 | | 1003 | Q110 | 88 |

Analysis: We are doing much better! But look at Table B (Courses). We still have a hidden issue.

Usamos el algoritmo de descomposición en 3FN preservando dependencias.

Paso 2.1: Crear tabla para A → B, C, D
R1(A, B, C, D) con clave A.

Paso 2.2: Crear tabla para A, E → F
R2(A, E, F) con clave (A,E).

Paso 2.3: ¿Perdemos algo? La dependencia D,E→F está implícita en las reglas originales pero no es necesaria porque ya tenemos A,E→F y A→D, entonces por transitividad D,E→F es redundante.

Resultado 3FN:

Verificación: Sin dependencias parciales ni transitivas. Todo atributo no clave depende directamente de la clave completa.

Here is the raw data:

| Student_ID | Student_Name | Course_Code | Course_Name | Professor | Professor_Office | Grade | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | 1001 | Ana Torres | M101, H205 | Math I, History | Dr. Gomez, Dr. Perez | Bldg A, Bldg B | 85, 90 | | 1002 | Luis Rojas | M101 | Math I | Dr. Gomez | Bldg A | 78 | | 1003 | Sofía Vargas | H205, Q110 | History, Chem | Dr. Perez, Dr. Liu | Bldg B, Bldg C | 92, 88 |

Problem: This table violates the most basic rule of databases. Columns like Course_Code and Grade contain multiple values. This makes searching impossible. (e.g., How do you find everyone taking History? You can't simply query "H205").

Espero que estos ejercicios resueltos te ayuden en tu comprensión de la normalización de base de datos y a mejorar tus habilidades en el diseño de bases de datos. Si tienes alguna otra pregunta o necesitas más ayuda, no dudes en preguntar.

Rule: The table must be in 2NF, and it must have no transitive dependencies.

A transitive dependency is like a chain: A determines B, and B determines C. In this case:

Therefore, Course_Code determines Professor_Office transitively. The office belongs to the professor, not the course directly. If Dr. Gomez moves to "Bldg D", we would have to update the Course table, which feels wrong. The Professor is a separate entity.

We split Table B again.

Enunciado:

Paso a paso:

Cómo convertir esto a PDF

Si quieres, genero un PDF listo con estos ejercicios y formato académico (portada, índice, soluciones paso a paso). ¿Deseas que lo prepare y te lo entregue como archivo descargable?

The number "211" in this context usually refers to a specific document ID or a page number within a larger collection of database design materials. Key Resources for Solved Exercises

If you are looking for actual solved problems (1FN, 2FN, 3FN), several high-quality PDF guides from universities and educational platforms provide practical examples: University Guides:

Universidad Nacional de Salta (UNSa) : Includes exercises on normalizing student and course tables up to 3FN.

Universidad de Zaragoza : Provides detailed "practical" guides explaining why 2FN is sometimes not enough and how to reach 3FN.

Universidad Carlos III de Madrid : Offers advanced exercises involving Boyce-Codd Normal Form (BCNF). Case Study Collections:

Guía de Ejercicios (grch.com.ar): Features a classic "Orders" table example, breaking down the transformation from unnormalized data to 3FN.

Scribd & SlideShare Collections: Host various "Guía 2" documents containing 5–8 solved exercises covering billing, library loans, and employee expenses. Common Steps in Solved Exercises

Most of these "PDF 211" resources follow a standard pedagogical path: En breve estrenaremos nueva web con tienda on-line

You can use this text for a website description, a README file, a blog post, or a course syllabus.