tag:blogger.com,1999:blog-91339483336842726882024-02-19T06:04:58.965-08:00TICS DE CONTABILIDADSILVANNA Y ELENAhttp://www.blogger.com/profile/05017704346143911212noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-9133948333684272688.post-70791688475279476372011-09-07T13:20:00.000-07:002011-09-07T13:20:11.816-07:00Practica N° 3 de Informatica IIIPractica N°3 Informatica III<br />
<br />
Preguntas:<br />
<br />
1. Calcular la venta total realizada por cada uno de los vendedores durante un mes de un año determinado, y almacenar los datos generados en una tabla. A la nueva abla le vamos a poner el nombre de Resumen venta mes de año, y a la consulta le nombraremos como Ventas por empleapo por mes y año.<br />
<br />
2. Consulta que calcule el sueldo bruto, y neto de aqueellos empleados que han vendido productos en el mes tres, del año 2006 teniendo en cuenta que ademas de su salario, reciben la comision que corresponde a cada uno sobre lo vendido por cada uno. Nombrela "Sueldo de vendedores del mes 2006.<br />
<br />
3. Consulta que actualice el campo "comision" de los vendedores a "Tiempo parcial" a un 12%.<br />
<br />
4. Realice una cnsulta de seleccion que permita convertir el salario del vendedor, de euros a dolares. Suponganse que el cambio esta en 1,45 euros por dolar. Transforme la consulta anterior en una de creacion tabla.<br />
<br />
5. Crear una consulta que determine cuantas facturas tiene cada uno de los empleados cuyo importe no este en el rango de 150 y 200.<br />
<br />
Desarrollo:<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxBIoR7GuUdGdkLC1xGC_hDvHhnJQfpCM1dREw6JPS9J-aFuzgJhg133D6McIvgi_y5cvW8Ioh32mOtVgus7MBYtO_6AW2c8KTNi6eRlv5nwt-CLdWTm2-OOEK1wBLNVIthdrx31xdZJw/s1600/1.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="204" nba="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxBIoR7GuUdGdkLC1xGC_hDvHhnJQfpCM1dREw6JPS9J-aFuzgJhg133D6McIvgi_y5cvW8Ioh32mOtVgus7MBYtO_6AW2c8KTNi6eRlv5nwt-CLdWTm2-OOEK1wBLNVIthdrx31xdZJw/s320/1.bmp" width="320" /></a></div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhecDaJfMP2KNv0m2rLHtNTOw64qEegMp_4SJSlG8U7XRsXpRCJjxKW49uRKjTKiprcUDnl_wkOON2rsFv9_XYLbTgxYe0NzdtD_pqyuFkPdyoet8uUtIm4ptUo73pAXrHqaHEO-x9Mj64/s1600/2.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="203" nba="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhecDaJfMP2KNv0m2rLHtNTOw64qEegMp_4SJSlG8U7XRsXpRCJjxKW49uRKjTKiprcUDnl_wkOON2rsFv9_XYLbTgxYe0NzdtD_pqyuFkPdyoet8uUtIm4ptUo73pAXrHqaHEO-x9Mj64/s320/2.bmp" width="320" /></a></div><br />
Links:<br />
<br />
<a href="http://www.mediafire.com/?3lz23x373o39cs9">http://www.mediafire.com/?3lz23x373o39cs9</a><br />
<a href="http://www.mediafire.com/?me48w0wsh5yhipe">http://www.mediafire.com/?me48w0wsh5yhipe</a>SILVANNA Y ELENAhttp://www.blogger.com/profile/05017704346143911212noreply@blogger.com0tag:blogger.com,1999:blog-9133948333684272688.post-30340417295596334972011-08-16T18:47:00.000-07:002011-08-16T18:47:35.673-07:00CONSULTAS DE SELECCION<br />
<div align="center" class="MsoNormal" style="text-align: center;"></div><div align="center" class="MsoNormal" style="text-align: center;"></div><div class="MsoNormal" style="text-align: center;"></div><div class="MsoNormal" style="line-height: 24px;"></div><div class="MsoNormal" style="font-family: Arial, sans-serif; text-align: center;"><span lang="ES-PE" style="font-family: Arial, sans-serif; font-size: 12pt; line-height: 150%;"><b><u><span class="Apple-style-span" style="color: #073763;">CONSULTAS DE SELECCIÓN<o:p></o:p></span></u></b></span></div><div class="MsoNormal" style="font-family: Arial, sans-serif; text-align: left;"><b><u><span class="Apple-style-span" style="color: #073763;"><br />
</span></u></b></div><div class="MsoNormal" style="font-family: Arial, sans-serif; text-align: left;"><span lang="ES-PE" style="font-family: Arial, sans-serif; font-size: 12pt; line-height: 150%;"><b><span class="Apple-style-span" style="color: #073763;"> (Base) <o:p></o:p></span></b></span></div><div class="MsoListParagraphCxSpFirst" style="text-align: left; text-indent: -18pt;"></div><ul style="font-family: Arial, sans-serif;"><li><b><span class="Apple-style-span" style="color: #073763;"><span lang="ES-PE" style="font-family: Symbol; font-size: 12pt; line-height: 150%;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span lang="ES-PE" style="font-family: Arial, sans-serif; font-size: 12pt; line-height: 150%;">Crear una tabla.</span></span></b></li>
<li><b><span class="Apple-style-span" style="color: #073763;"><span lang="ES-PE" style="font-family: Symbol; font-size: 12pt; line-height: 150%;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span lang="ES-PE" style="font-family: Arial, sans-serif; font-size: 12pt; line-height: 150%;">Actualizar datos en una tabla.</span></span></b></li>
<li><b><span class="Apple-style-span" style="color: #073763;"><span lang="ES-PE" style="font-family: Symbol; font-size: 12pt; line-height: 150%;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span lang="ES-PE" style="font-family: Arial, sans-serif; font-size: 12pt; line-height: 150%;">Eliminar datos de una tabla.</span></span></b></li>
<li><b><span class="Apple-style-span" style="color: #073763;"><span lang="ES-PE" style="font-family: Symbol; font-size: 12pt; line-height: 150%;">·<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span lang="ES-PE" style="font-family: Arial, sans-serif; font-size: 12pt; line-height: 150%;">Datos anexados.</span></span></b></li>
</ul><br />
<br />
<v:stroke endarrow="block"><span class="Apple-style-span" style="color: #073763;"> </span></v:stroke><br />
<div class="MsoNormal" style="text-align: justify;"><span class="Apple-style-span" style="color: #073763;"><span class="Apple-style-span" style="font-family: Arial, sans-serif;"><span class="Apple-style-span" style="font-size: 19px; line-height: 28px;">A continuación les mostraremos algunas imágenes de las tablas que vamos a usar para las consultas.</span></span></span></div><div class="MsoNormal" style="text-align: justify;"><span class="Apple-style-span" style="color: #073763;"><span class="Apple-style-span" style="font-family: Arial, sans-serif;"><span class="Apple-style-span" style="font-size: 19px; line-height: 28px;"><br />
</span></span></span></div><div class="MsoNormal" style="text-align: justify;"><span class="Apple-style-span" style="color: #073763;"><span class="Apple-style-span" style="font-family: Arial, sans-serif;"><span class="Apple-style-span" style="font-size: 19px; line-height: 28px;">-ANIMALES</span></span></span></div><div class="separator" style="clear: both; font-family: Arial, sans-serif; text-align: center;"><span class="Apple-style-span" style="color: #073763;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9mOnxlrqcQxC3wjDDbLoXg4umwkzEQNrT-90Gv7FJ_MV8B9zKnsckiAPNFVWsF0uiZlgR46WGp4VWyYReDm7alVa6c8XD7-y6PAD7GDxmGhRG9cgK6iTWInz0pE9s_QniAgrmN47HN5s/s1600/ANIMALES-TABLA.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9mOnxlrqcQxC3wjDDbLoXg4umwkzEQNrT-90Gv7FJ_MV8B9zKnsckiAPNFVWsF0uiZlgR46WGp4VWyYReDm7alVa6c8XD7-y6PAD7GDxmGhRG9cgK6iTWInz0pE9s_QniAgrmN47HN5s/s320/ANIMALES-TABLA.bmp" width="320" /></a></span></div><div class="separator" style="clear: both; font-family: Arial, sans-serif; text-align: center;"><span class="Apple-style-span" style="color: #073763;"><br />
</span></div><div class="separator" style="clear: both; font-family: Arial, sans-serif; text-align: left;"><span class="Apple-style-span" style="color: #073763;"><br />
</span></div><div class="separator" style="clear: both; font-family: Arial, sans-serif; text-align: left;"><span class="Apple-style-span" style="color: #073763;"><b>-CUIDADORES</b></span></div><div class="MsoNormal" style="font-family: Arial, sans-serif; text-decoration: underline;"><span class="Apple-style-span" style="color: #073763;"><span class="Apple-style-span" style="font-size: 19px; line-height: 28px;"><br />
</span></span></div><div class="separator" style="clear: both; text-align: center;"><span class="Apple-style-span" style="color: #073763;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivNBcyBcJuCjkxVP-8e3IvEZcC7BqCa5TTNT-IQiPv-1TSH-9hgX7UtzVGNL5SM0Ec0BVvX59acyybnGZnM-qKSJcICmc3a1aAAhsY0O3oZHIWqftMeA3mMJ6eHnWgDe68dyAPziNe7Zk/s1600/CUIDADORES-TABLA.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivNBcyBcJuCjkxVP-8e3IvEZcC7BqCa5TTNT-IQiPv-1TSH-9hgX7UtzVGNL5SM0Ec0BVvX59acyybnGZnM-qKSJcICmc3a1aAAhsY0O3oZHIWqftMeA3mMJ6eHnWgDe68dyAPziNe7Zk/s320/CUIDADORES-TABLA.bmp" width="320" /></a></span></div><div class="MsoNormal" style="font-family: Arial, sans-serif; text-decoration: underline;"><span class="Apple-style-span" style="color: #073763;"><span class="Apple-style-span" style="font-size: 19px; line-height: 28px;"><br />
</span></span></div><div class="MsoNormal" style="font-family: Arial, sans-serif; text-decoration: underline;"><span class="Apple-style-span" style="color: #073763;"><span class="Apple-style-span" style="font-size: 19px; line-height: 28px;"><br />
</span></span></div><span class="Apple-style-span" style="color: #073763; font-family: Arial, sans-serif;"></span><br />
<div class="MsoNormal" style="line-height: 24px; text-align: justify;"><span class="Apple-style-span" style="color: #073763; font-family: Arial, sans-serif;"><span lang="ES-PE" style="font-family: Arial, sans-serif; font-size: 14pt; line-height: 28px;">Ejercicios para las Consultas:<o:p></o:p></span></span></div><div class="MsoNormal" style="line-height: 24px; text-align: justify;"><span class="Apple-style-span" style="color: #073763; font-family: Arial, sans-serif;"><span lang="ES-PE" style="font-family: Arial, sans-serif; font-size: 14pt; line-height: 28px;"><br />
</span></span></div><div class="MsoListParagraphCxSpFirst" style="line-height: 24px; text-align: justify; text-indent: -18pt;"><span class="Apple-style-span" style="color: #073763; font-family: Arial, sans-serif;"><span lang="ES-PE" style="font-family: Wingdings; font-size: 14pt; line-height: 28px;">§<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span lang="ES-PE" style="font-family: Arial, sans-serif; font-size: 14pt; line-height: 28px;">Consulta 1: Un resumen que indique la cantidad de animales de tierra, alimentación, omnívora y respiración pulmonar.<o:p></o:p></span></span></div><div class="MsoListParagraphCxSpMiddle" style="line-height: 24px; text-align: justify; text-indent: -18pt;"><span class="Apple-style-span" style="color: #073763; font-family: Arial, sans-serif;"><span lang="ES-PE" style="font-family: Wingdings; font-size: 14pt; line-height: 28px;">§<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span lang="ES-PE" style="font-family: Arial, sans-serif; font-size: 14pt; line-height: 28px;">Consulta 2: Resumen de número de animales y promedio de patas para cada clase de animal.<o:p></o:p></span></span></div><div class="MsoListParagraphCxSpMiddle" style="line-height: 24px; text-align: justify; text-indent: -18pt;"><span class="Apple-style-span" style="color: #073763; font-family: Arial, sans-serif;"><span lang="ES-PE" style="font-family: Wingdings; font-size: 14pt; line-height: 28px;">§<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span lang="ES-PE" style="font-family: Arial, sans-serif; font-size: 14pt; line-height: 28px;">Consulta 3: Nos indique el nombre del animal, la clase a la que pertenece salvo aquellos que sean de tierra y que sean cuidados solo por Juan y Ambrosia.<o:p></o:p></span></span></div><div class="MsoListParagraphCxSpMiddle" style="line-height: 24px; text-align: justify; text-indent: -18pt;"><span class="Apple-style-span" style="color: #073763; font-family: Arial, sans-serif;"><span lang="ES-PE" style="font-family: Wingdings; font-size: 14pt; line-height: 28px;">§<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span lang="ES-PE" style="font-family: Arial, sans-serif; font-size: 14pt; line-height: 28px;">Consulta 4: Animales de sangre fría o respiración pulmonar.<o:p></o:p></span></span></div><div class="MsoListParagraphCxSpLast" style="text-align: justify; text-indent: -18pt;"><div style="line-height: 24px;"><span class="Apple-style-span" style="color: #073763; font-family: Arial, sans-serif;"><span lang="ES-PE" style="font-family: Wingdings; font-size: 14pt; line-height: 28px;">§<span style="font: normal normal normal 7pt/normal 'Times New Roman';"> </span></span><span lang="ES-PE" style="font-family: Arial, sans-serif; font-size: 14pt; line-height: 28px;">Consulta 5: Resumen del número de animales para cada tipo de alimentación.</span></span></div><div style="line-height: 24px;"><span class="Apple-style-span" style="color: #073763; font-family: Arial, sans-serif;"><span lang="ES-PE" style="font-family: Arial, sans-serif; font-size: large; line-height: 28px;"><b>ejercicio:</b></span></span></div><div style="line-height: 24px;"><span class="Apple-style-span" style="color: #073763; font-family: Arial, sans-serif;"><span lang="ES-PE" style="font-family: Arial, sans-serif; font-size: 14pt; line-height: 28px;"><a href="http://www.4shared.com/file/PMWEj-ux/ZOO-EJERCICIO.html?">http://www.4shared.com/file/PMWEj-ux/ZOO-EJERCICIO.html?</a></span></span></div><div style="line-height: 24px;"><span class="Apple-style-span" style="color: #073763; font-family: Arial, sans-serif; font-size: large;"><br />
</span></div><span class="Apple-style-span" style="color: #073763; font-family: Arial, sans-serif; font-size: large;"><b><span class="Apple-style-span" style="line-height: 24px;">el ejercicio solucionado:</span></b></span><br />
<span class="Apple-style-span" style="color: #073763; font-family: Arial, sans-serif;"><a href="http://www.4shared.com/file/x-kwDWs8/zoo_solucionada.html?" style="font-size: 19px; line-height: 28px;">http://www.4shared.com/file/x-kwDWs8/zoo_solucionada.html?</a></span><br />
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: large;"><b><br />
</b></span><br />
<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: large;"><b>vídeo</b></span><span class="Apple-style-span" style="color: #073763; font-family: Arial, Helvetica, sans-serif; font-size: large;"><b> opcional para guiarse:</b></span><br />
<span class="Apple-style-span" style="color: #073763; font-family: Arial, Helvetica, sans-serif; font-size: large;"><b><a href="http://www.youtube.com/watch?v=AYrMKjl4GEE">http://www.youtube.com/watch?v=AYrMKjl4GEE</a></b></span><br />
<span class="Apple-style-span" style="color: #073763; font-family: Arial, sans-serif;"><span class="Apple-style-span" style="font-size: 19px; line-height: 28px;"><br />
</span></span></div><div class="MsoListParagraphCxSpLast" style="line-height: 24px; text-align: justify; text-indent: -18pt;"><span class="Apple-style-span" style="color: #073763; font-family: Arial, sans-serif;"><span lang="ES-PE" style="font-family: Arial, sans-serif; font-size: 14pt; line-height: 28px;"><br />
</span></span></div><br />
<br />
<br />
SILVANNA Y ELENAhttp://www.blogger.com/profile/05017704346143911212noreply@blogger.com0tag:blogger.com,1999:blog-9133948333684272688.post-51751813706924515012011-07-12T15:38:00.000-07:002011-07-12T15:38:07.157-07:00"RELACIONES"<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"><span style="color: black;">CAMPO PRINCIPAL:</span></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"><span style="color: black;">*Relacionar</span></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"><span style="color: black;">*Filtrar y Ordenar </span></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"><span style="color: black;">*Duplicidad</span></span></div><div class="separator" style="clear: both; text-align: center;"><span style="color: black;"></span></div><br />
<div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizgKqKmJdrNXq8xYCVCBzdQVwpn1YIIihUG379NnOa7COS-9pNjw0CGJ2qoglauhp0JUU5GcXlRepz_lVuSqetQtLSfKHZrLVlNLLqxjDKoMy-WZh3U62TArogysNM8AHlBs5OOiR-TBc/s1600/ELIPCE.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="213" m$="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizgKqKmJdrNXq8xYCVCBzdQVwpn1YIIihUG379NnOa7COS-9pNjw0CGJ2qoglauhp0JUU5GcXlRepz_lVuSqetQtLSfKHZrLVlNLLqxjDKoMy-WZh3U62TArogysNM8AHlBs5OOiR-TBc/s320/ELIPCE.png" width="320" /></a></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"></span><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"><strong>TIPOS DE RELACIONES:</strong></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;">1) <strong>UNO A UNO</strong>.- un solo campo,una sola tabla.</span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"> ejm:</span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"> PRESIDENTE------------PAIS</span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;">2)<strong>UNO A VARIOS.-</strong></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"> ejm: </span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"> DISTRITO--------------HABITANTES</span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"> Sabiendo que en un distrito se puede registrar varios habitantes.</span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;">3) <strong>VARIOS A VARIOS.-</strong></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"><strong> </strong>ejm:</span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"> CLIENTES-----------------PRODUCTO</span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"><strong><em>ESTABLECER LA RELACION</em></strong></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;">1.-Identificar la tabla principal</span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;">2.- Identificar la tabla secundaria</span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;">3.- Agregar el campo secundario en t.s</span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;">4.- Seleccionar el campo principal y arrastrarlo hacia el campo secundario.</span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"><em><strong>Caso Practico de Base de Datos "RELACIONES"</strong></em></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"><em><strong><span style="color: blue;">Ejercicio N°1:</span></strong></em></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;">Se desea informatizar la gestión de una empresa de transportes que reparte paquetes por todo el Perú. Los encargados de llevar los paquetes son los camioneros, de los que se quiere guardar el dni, nombre, teléfono, dirección, salario y provincia en la que vive. De los paquetes transportados interesa conocer el código de paquete, descripción, destinatario y dirección del destinatario. Un camionero distribuye muchos paquetes. De las provincias a las que llegan los paquetes interesa guardar el código de provincia y el nombre. A una provincia pueden llegar varios paquetes. De los camiones que llevan los camioneros, interesa conocer la matrícula, modelo, tipo y potencia. Un camionero puede conducir diferentes camiones en fechas diferentes.”</span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"><em><span style="color: blue;">DESARROLLO 1:</span></em></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-Lt-OaoGL9Kz3tqPLkyy6G4wIQKIgmkqUbB5qlm1TXEY1ZXD0mPVwHZQtAuMDqq6y19EeqKH-UYaZEagaFQ3UmmW_TNg7BVSPqggxL91PwCZQlNJmZ0SOS1K6lJcm4w4OBNfjhjHZyoE/s1600/IMAGEN+1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="180" m$="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-Lt-OaoGL9Kz3tqPLkyy6G4wIQKIgmkqUbB5qlm1TXEY1ZXD0mPVwHZQtAuMDqq6y19EeqKH-UYaZEagaFQ3UmmW_TNg7BVSPqggxL91PwCZQlNJmZ0SOS1K6lJcm4w4OBNfjhjHZyoE/s320/IMAGEN+1.png" width="320" /></a></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><br />
</div><div align="center" class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: center;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"><em><span style="color: blue;"><strong>Ejercicio N° 2:</strong></span></em></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 10pt; text-align: justify;"><span style="font-family: Calibri;"><span lang="ES" style="font-size: 12pt; mso-ansi-language: ES; mso-ascii-font-family: Calibri; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE; mso-hansi-font-family: Calibri;">Se desea informatizar la gestión de una tienda informática. La tienda dispone de una serie de productos que se pueden vender a los clientes.”De cada producto informático se desea guardar el código, descripción, precio y número de existencias. De cada cliente se desea guardar el código, nombre, apellidos, dirección y número de teléfono. Un mismo producto puede ser comprado por varios clientes. Cada vez que se compre un artículo quedará registrada la compra en la base de datos junto con la fecha en la que se ha comprado el artículo. La tienda tiene contactos con varios proveedores que son los que suministran los productos. Un mismo producto puede ser suministrado por varios proveedores. De cada proveedor se desea guardar el código, nombre, apellidos, dirección, provincia y número de teléfono.</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"></span></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 10pt; text-align: justify;"><span style="color: blue; font-family: Calibri;"><em><span lang="ES" style="font-size: 12pt; mso-ansi-language: ES; mso-ascii-font-family: Calibri; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE; mso-hansi-font-family: Calibri;">DESARROLLO 2:</span></em></span></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirUaCrZhhKmcsDNz3gL5UcAeuoRtI0Pscl3o3GgGcykThM1M1jgDCOEJ4Lx2nTCNbenIpj8dRllzfEbZVBdxvCoRYCG280o3NBt8C7-k6fxkwJbHU2RUlHOQ7WUcyxU6wTyNHDtiXNCkQ/s1600/IMAGEN+2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="180" m$="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirUaCrZhhKmcsDNz3gL5UcAeuoRtI0Pscl3o3GgGcykThM1M1jgDCOEJ4Lx2nTCNbenIpj8dRllzfEbZVBdxvCoRYCG280o3NBt8C7-k6fxkwJbHU2RUlHOQ7WUcyxU6wTyNHDtiXNCkQ/s320/IMAGEN+2.png" width="320" /></a></div><br />
<em><span style="color: blue;">IMAGENES:</span></em><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1_ucAaJ_Rb5ca0C7N97xEGuv5vLUwiFw5s6SY96BYfVPFAxTyL3dXTfCFeQlNPzP62RMHitI6w2z_5vuKgIzow-22R78aChjx4-9181Dqw5gafSRzogQBjUNmfNuLiHdR9Wl8IePSJB0/s1600/PARTE+1.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" m$="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1_ucAaJ_Rb5ca0C7N97xEGuv5vLUwiFw5s6SY96BYfVPFAxTyL3dXTfCFeQlNPzP62RMHitI6w2z_5vuKgIzow-22R78aChjx4-9181Dqw5gafSRzogQBjUNmfNuLiHdR9Wl8IePSJB0/s320/PARTE+1.jpeg" width="232" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfPQz_EAuq92RhJwSvtUh7JZUkt0bKX9Nt8n4jui5Y4BKHjTRTu2LO15Ly8b_HV6iX9CeyWT5e4FA-LZgksYR5mYWquq1R_A9MR2-Yvqa40UZUmAkThCAkBaEB-RIh2EQmjNvqjggQM8s/s1600/PARTE+2.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" m$="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfPQz_EAuq92RhJwSvtUh7JZUkt0bKX9Nt8n4jui5Y4BKHjTRTu2LO15Ly8b_HV6iX9CeyWT5e4FA-LZgksYR5mYWquq1R_A9MR2-Yvqa40UZUmAkThCAkBaEB-RIh2EQmjNvqjggQM8s/s320/PARTE+2.jpeg" width="232" /></a></div><br />
<span style="color: magenta;"> ANEXOS:</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 10pt; text-align: justify;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="color: blue; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE; mso-no-proof: yes; text-decoration: none; text-underline: none;"></span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 10pt; text-align: justify;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"> <a href="http://www.4shared.com/get/s6EOm-Yy/elena_y_silvanaa_1.html">http://www.4shared.com/get/s6EOm-Yy/elena_y_silvanaa_1.html</a></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 10pt; text-align: justify;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"><a href="http://www.4shared.com/get/AGIPFqJ9/elena_y_silvanna.html">http://www.4shared.com/get/AGIPFqJ9/elena_y_silvanna.html</a></span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><br />
</div></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt;"><span style="color: blue; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE; mso-no-proof: yes; text-decoration: none; text-underline: none;"><shapetype coordsize="21600,21600" filled="f" id="_x0000_t75" o:preferrelative="t" o:spt="75" path="m@4@5l@4@11@9@11@9@5xe" stroked="f"><stroke joinstyle="miter"></stroke><formulas><f eqn="if lineDrawn pixelLineWidth 0"></f><f eqn="sum @0 1 0"></f><f eqn="sum 0 0 @1"></f><f eqn="prod @2 1 2"></f><f eqn="prod @3 21600 pixelWidth"></f><f eqn="prod @3 21600 pixelHeight"></f><f eqn="sum @0 0 1"></f><f eqn="prod @6 1 2"></f><f eqn="prod @7 21600 pixelWidth"></f><f eqn="sum @8 21600 0"></f><f eqn="prod @7 21600 pixelHeight"></f><f eqn="sum @10 21600 0"></f></formulas><path gradientshapeok="t" o:connecttype="rect" o:extrusionok="f"></path><lock aspectratio="t" v:ext="edit"></lock></shapetype></span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES-PE;"></span></div>SILVANNA Y ELENAhttp://www.blogger.com/profile/05017704346143911212noreply@blogger.com0