Si buscas el archivo exacto “ejercicios resueltos de normalizacion de base de datos pdf 211”, te recomiendo:
Libros con ejercicios:
Plataformas educativas:
Consejo: Si el número 211 es una referencia a una página, revisa los libros de Silberschatz o Elmasri – Navathe (capítulo 14 o apéndice de ejercicios).
Primera Forma Normal (1FN) – (Ejercicios 31–60)
Segunda Forma Normal (2FN) – (Ejercicios 61–100) Si buscas el archivo exacto “ejercicios resueltos de
Tercera Forma Normal (3FN) – (Ejercicios 101–150)
Forma Normal de Boyce-Codd (FNBC) – (Ejercicios 151–190)
Ejercicios Integradores (191–211)
Crear dos tablas:
Tabla PEDIDO_CLIENTE (clave: ID_Pedido)
| ID_Pedido | Cliente | Teléfono |
|-----------|---------|----------|
| 101 | Ana | 555-1234 |
| 102 | Luis | 555-5678 | Libros con ejercicios:
Tabla DETALLE_PEDIDO (clave: ID_Pedido, Producto)
| ID_Pedido | Producto | Precio |
|-----------|----------|--------|
| 101 | Laptop | 800 |
| 101 | Mouse | 20 |
| 102 | Teclado | 40 |
✅ Resultado: 2FN alcanzada. No hay dependencias transitivas → también 3FN.
| Student_ID | Student_Name | Course_Code | Course_Name | Professor | Professor_Office | Grade | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | 1001 | Ana Torres | M101 | Math I | Dr. Gomez | Bldg A | 85 | | 1001 | Ana Torres | H205 | History | Dr. Perez | Bldg B | 90 | | 1002 | Luis Rojas | M101 | Math I | Dr. Gomez | Bldg A | 78 | | 1003 | Sofía Vargas | H205 | History | Dr. Perez | Bldg B | 92 | | 1003 | Sofía Vargas | Q110 | Chem | Dr. Liu | Bldg C | 88 |
Analysis: This works, but it has a lot of redundancy. Ana's name is repeated. Math I and Dr. Gomez's details are repeated.
Table A: Students (Key: Student_ID) | Student_ID | Student_Name | | :--- | :--- | | 1001 | Ana Torres | | 1002 | Luis Rojas | | 1003 | Sofía Vargas | Plataformas educativas:
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.
If you are searching for "ejercicios resueltos de normalizacion de base de datos pdf 211", you are likely a student trying to make sense of the Normal Forms. Let’s be honest: normalization can feel like a puzzle where the pieces keep changing shape.
In this post, we are going to skip the heavy theory and jump straight into a solved exercise. We will take an unnormalized table and walk it through First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF).