{"id":19881,"date":"2024-02-01T03:48:53","date_gmt":"2024-02-01T02:48:53","guid":{"rendered":"https:\/\/complex-systems-ai.com\/?page_id=19881"},"modified":"2024-02-11T21:30:56","modified_gmt":"2024-02-11T20:30:56","slug":"exo-entite-association","status":"publish","type":"page","link":"https:\/\/complex-systems-ai.com\/es\/analisis-de-software\/modelo-de-entidad-de-asociacion-de-ejercicios-corregidos\/","title":{"rendered":"6 Ejercicios corregidos Modelo de Entidad de Asociaci\u00f3n"},"content":{"rendered":"<div data-elementor-type=\"wp-page\" data-elementor-id=\"19881\" class=\"elementor elementor-19881\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a295187 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a295187\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-2596ab2\" data-id=\"2596ab2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3146971 elementor-align-justify elementor-widget elementor-widget-button\" data-id=\"3146971\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/complex-systems-ai.com\/es\/analisis-de-software\/\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">An\u00e1lisis de software<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-15bdd73\" data-id=\"15bdd73\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b714534 elementor-align-justify elementor-widget elementor-widget-button\" data-id=\"b714534\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/complex-systems-ai.com\/es\/\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Pagina de inicio<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-3946c35\" data-id=\"3946c35\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f9f527e elementor-align-justify elementor-widget elementor-widget-button\" data-id=\"f9f527e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/fr.wikipedia.org\/wiki\/UML_(informatique)\" target=\"_blank\" rel=\"noopener\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Wiki<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c7d622f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c7d622f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7f54bf5\" data-id=\"7f54bf5\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4e367ad elementor-widget elementor-widget-heading\" data-id=\"4e367ad\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Contenido<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Tabla de contenido alternativo\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Palanca<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/complex-systems-ai.com\/es\/analisis-de-software\/modelo-de-entidad-de-asociacion-de-ejercicios-corregidos\/#Exercices-corriges-Modele-Entite-Association\" >Ejercicios corregidos Asociaci\u00f3n de Entidades Modelo<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/complex-systems-ai.com\/es\/analisis-de-software\/modelo-de-entidad-de-asociacion-de-ejercicios-corregidos\/#Exercice-1\" >Ejercicio 1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/complex-systems-ai.com\/es\/analisis-de-software\/modelo-de-entidad-de-asociacion-de-ejercicios-corregidos\/#Exercice-2\" >Ejercicio 2<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/complex-systems-ai.com\/es\/analisis-de-software\/modelo-de-entidad-de-asociacion-de-ejercicios-corregidos\/#Exercice-3\" >Ejercicio 3<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/complex-systems-ai.com\/es\/analisis-de-software\/modelo-de-entidad-de-asociacion-de-ejercicios-corregidos\/#Exercice-4\" >Ejercicio 4<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/complex-systems-ai.com\/es\/analisis-de-software\/modelo-de-entidad-de-asociacion-de-ejercicios-corregidos\/#Exercice-5\" >Ejercicio 5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/complex-systems-ai.com\/es\/analisis-de-software\/modelo-de-entidad-de-asociacion-de-ejercicios-corregidos\/#Exercice-6\" >Ejercicio 6<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"elementor-heading-title elementor-size-default\"><span class=\"ez-toc-section\" id=\"Exercices-corriges-Modele-Entite-Association\"><\/span>Ejercicios corregidos Asociaci\u00f3n de Entidades Modelo<span class=\"ez-toc-section-end\"><\/span><\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b6ef6db elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b6ef6db\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7ba5e4c\" data-id=\"7ba5e4c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ad70c95 elementor-widget elementor-widget-text-editor\" data-id=\"ad70c95\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Los siguientes ejercicios corregidos se refieren al modelo de Entidad de Asociaci\u00f3n, su construcci\u00f3n, modelado y comprensi\u00f3n basados en casos de uso.<\/p><p><img decoding=\"async\" class=\"aligncenter wp-image-11096 size-full\" src=\"http:\/\/complex-systems-ai.com\/wp-content\/uploads\/2020\/09\/cropped-Capture.png\" alt=\"modelo de entidad de asociaci\u00f3n\" width=\"97\" height=\"97\" title=\"\"><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3e2611a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3e2611a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bc991b6\" data-id=\"bc991b6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0f06011 elementor-widget elementor-widget-heading\" data-id=\"0f06011\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span class=\"ez-toc-section\" id=\"Exercice-1\"><\/span>Ejercicio 1<span class=\"ez-toc-section-end\"><\/span><\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-50a3d1b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"50a3d1b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6a1b5b7\" data-id=\"6a1b5b7\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-70b9d81 elementor-widget elementor-widget-text-editor\" data-id=\"70b9d81\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A continuaci\u00f3n se muestra el diagrama E\/A que representa las visitas a un centro m\u00e9dico. Responda las siguientes preguntas (estrictamente seg\u00fan lo indicado en el diagrama).<\/p><p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone wp-image-19886 size-full\" src=\"http:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd1.png\" alt=\"asociaci\u00f3n-entidad\" width=\"389\" height=\"328\" title=\"\" srcset=\"https:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd1.png 389w, https:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd1-300x253.png 300w, https:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd1-14x12.png 14w\" sizes=\"(max-width: 389px) 100vw, 389px\" \/><\/p><p>1. \u00bfPuede un paciente tener m\u00faltiples consultas?<\/p><p>2. \u00bfPuede un m\u00e9dico atender a varios pacientes en una misma consulta?<\/p><p>3. \u00bfSe pueden recetar varios medicamentos en una misma consulta?<\/p><p>4. \u00bfPueden dos m\u00e9dicos distintos recetar el mismo medicamento?<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-03fc4b1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"03fc4b1\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-61c2e0a\" data-id=\"61c2e0a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-562c9d0 elementor-widget elementor-widget-toggle\" data-id=\"562c9d0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"toggle.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-9031\" class=\"elementor-tab-title\" data-tab=\"1\" role=\"button\" aria-controls=\"elementor-tab-content-9031\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon elementor-toggle-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-closed\"><i class=\"fas fa-caret-right\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-opened\"><i class=\"elementor-toggle-icon-opened fas fa-caret-up\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-toggle-title\" tabindex=\"0\">Soluci\u00f3n<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<div id=\"elementor-tab-content-9031\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"region\" aria-labelledby=\"elementor-tab-title-9031\"><ol><li>S\u00ed =&gt; (1,n) para ayudar<\/li><li>No =&gt; consulta a asistencia (1,1)<\/li><li>\u00a0S\u00ed =&gt; consulta a prescrito (0,n), Y a n medicamentos se prescriben en una consulta\u00a0\u00a0<\/li><li><p>S\u00ed =&gt; Nada lo proh\u00edbe en el diagrama. Un m\u00e9dico da consultas, se prescriben medicamentos pero no hay v\u00ednculo entre el medicamento y el m\u00e9dico que los prescribe. No hay informaci\u00f3n sobre este punto sin restricciones escritas adem\u00e1s del diagrama.<\/p><\/li><\/ol><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ee9e42e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ee9e42e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5e2ab8a\" data-id=\"5e2ab8a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dc6a90f elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"dc6a90f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-23caa80 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"23caa80\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-afa48ce\" data-id=\"afa48ce\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-904f572 elementor-widget elementor-widget-heading\" data-id=\"904f572\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span class=\"ez-toc-section\" id=\"Exercice-2\"><\/span>Ejercicio 2<span class=\"ez-toc-section-end\"><\/span><\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4689847 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4689847\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e4e40c9\" data-id=\"e4e40c9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-96748e8 elementor-widget elementor-widget-text-editor\" data-id=\"96748e8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A continuaci\u00f3n se muestra el diagrama E\/A que representa un torneo de tenis. Responda las siguientes preguntas (bas\u00e1ndose estrictamente en lo que se muestra en el diagrama)<\/p><p><img decoding=\"async\" class=\"alignnone wp-image-19887 size-full\" src=\"http:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd2.png\" alt=\"modelo de entidad de asociaci\u00f3n\" width=\"347\" height=\"371\" title=\"\" srcset=\"https:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd2.png 347w, https:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd2-281x300.png 281w, https:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd2-11x12.png 11w\" sizes=\"(max-width: 347px) 100vw, 347px\" \/><\/p><ol><li>\u00bfPodemos jugar partidos de dobles?<\/li><li>\u00bfPuede un jugador ganar un partido sin haberlo jugado?<\/li><li>\u00bfPueden haber dos partidos en el mismo campo al mismo tiempo?<\/li><li>\u00bfC\u00f3mo evitar 2 partidos a la vez en el mismo campo?<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c6c6c8b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c6c6c8b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-83dc039\" data-id=\"83dc039\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2f898b5 elementor-widget elementor-widget-toggle\" data-id=\"2f898b5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"toggle.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-4981\" class=\"elementor-tab-title\" data-tab=\"1\" role=\"button\" aria-controls=\"elementor-tab-content-4981\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon elementor-toggle-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-closed\"><i class=\"fas fa-caret-right\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-opened\"><i class=\"elementor-toggle-icon-opened fas fa-caret-up\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-toggle-title\" tabindex=\"0\">Soluci\u00f3n<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<div id=\"elementor-tab-content-4981\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"region\" aria-labelledby=\"elementor-tab-title-4981\"><ol><li>No, solo partidos individuales =&gt; partido para participar (2,2) solo 2 jugadores<\/li><li><span style=\"font-size: 1.125rem;\">S\u00ed, nada lo proh\u00edbe en el esquema, ning\u00fan v\u00ednculo entre participar y ganar.<\/span><\/li><\/ol><p><strong>Es necesario agregar una restricci\u00f3n de integridad que no se puede expresar en el modelo.<\/strong><\/p><ol start=\"3\"><li>S\u00ed, seg\u00fan el esquema =&gt; el horario es una propiedad de Match \u00fanicamente<\/li><li>El calendario pasa a ser propiedad de (partido, campo), por lo tanto, propiedad de la asociaci\u00f3n.<\/li><\/ol><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d7d350c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d7d350c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-85a68fd\" data-id=\"85a68fd\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-06a08ba elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"06a08ba\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c4c47ea elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c4c47ea\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9c012d9\" data-id=\"9c012d9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e8c981b elementor-widget elementor-widget-heading\" data-id=\"e8c981b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span class=\"ez-toc-section\" id=\"Exercice-3\"><\/span>Ejercicio 3<span class=\"ez-toc-section-end\"><\/span><\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-37199ef elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"37199ef\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ad9f1c7\" data-id=\"ad9f1c7\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-19456a9 elementor-widget elementor-widget-text-editor\" data-id=\"19456a9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Un grupo de compa\u00f1\u00edas a\u00e9reas que operan en territorio europeo desea organizar un sistema de informaci\u00f3n com\u00fan. Cada compa\u00f1\u00eda organiza vuelos entre las ciudades a las que sirve. <\/strong><\/p>\n<p><strong>Una empresa se define por su nombre y un vuelo se identifica por un n\u00famero de vuelo (AF234 por ejemplo)<\/strong><\/p>\n<ol>\n<li>Escribe el diagrama E\/A correspondiente.<\/li>\n<li>Completa el diagrama teniendo en cuenta la siguiente informaci\u00f3n:<\/li>\n<\/ol>\n<p>Los vuelos se fletan en aviones de su propiedad o arrendados a otras empresas del grupo.<\/p>\n<p>Una aeronave se identifica por un n\u00famero de aeronave y es de un tipo definido (Airbus A340) por ejemplo 3. Integre en su diagrama la siguiente necesidad (de seguimiento de su personal) expresada por las aerol\u00edneas<\/p>\n<p>\u00bfQui\u00e9n vol\u00f3 en qu\u00e9 vuelo y cu\u00e1l era su funci\u00f3n (capit\u00e1n, piloto de vuelo, mec\u00e1nico, tripulaci\u00f3n de cabina)?<\/p><p><span style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-weight: var( --e-global-typography-text-font-weight ); font-size: 1.125rem;\">Para los pilotos, es necesario integrar la noci\u00f3n de rango y calificaci\u00f3n de los pilotos para tal o cual tipo de aeronave.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-79f8e57 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"79f8e57\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0710d49\" data-id=\"0710d49\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dd793d1 elementor-widget elementor-widget-toggle\" data-id=\"dd793d1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"toggle.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-2321\" class=\"elementor-tab-title\" data-tab=\"1\" role=\"button\" aria-controls=\"elementor-tab-content-2321\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon elementor-toggle-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-closed\"><i class=\"fas fa-caret-right\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-opened\"><i class=\"elementor-toggle-icon-opened fas fa-caret-up\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-toggle-title\" tabindex=\"0\">Soluci\u00f3n<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<div id=\"elementor-tab-content-2321\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"region\" aria-labelledby=\"elementor-tab-title-2321\"><p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19888 size-full\" src=\"http:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd3.png\" alt=\"modelo entidad-asociaci\u00f3n\" width=\"605\" height=\"321\" title=\"\" srcset=\"https:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd3.png 605w, https:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd3-300x159.png 300w, https:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd3-18x10.png 18w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3376001 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3376001\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8f8e3fd\" data-id=\"8f8e3fd\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9941baa elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"9941baa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c734720 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c734720\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b991644\" data-id=\"b991644\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-68f8d64 elementor-widget elementor-widget-heading\" data-id=\"68f8d64\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span class=\"ez-toc-section\" id=\"Exercice-4\"><\/span>Ejercicio 4<span class=\"ez-toc-section-end\"><\/span><\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-66ba6e6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"66ba6e6\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b0f1d9d\" data-id=\"b0f1d9d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bb754ee elementor-widget elementor-widget-text-editor\" data-id=\"bb754ee\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Construya el diagrama relacional de los casos anteriores:<\/p><ul><li>Centro M\u00e9dico<\/li><li>Torneo de tenis<\/li><li>Compa\u00f1\u00eda a\u00e9rea<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2110ead elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2110ead\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d3886e0\" data-id=\"d3886e0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fde43e6 elementor-widget elementor-widget-toggle\" data-id=\"fde43e6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"toggle.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-2661\" class=\"elementor-tab-title\" data-tab=\"1\" role=\"button\" aria-controls=\"elementor-tab-content-2661\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon elementor-toggle-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-closed\"><i class=\"fas fa-caret-right\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-opened\"><i class=\"elementor-toggle-icon-opened fas fa-caret-up\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-toggle-title\" tabindex=\"0\">Soluci\u00f3n<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<div id=\"elementor-tab-content-2661\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"region\" aria-labelledby=\"elementor-tab-title-2661\"><p><strong>Centro M\u00e9dico\u00a0 <\/strong><\/p><p>Medicamento ( <u>codificado<\/u> , redacci\u00f3n )<\/p><p>Doctor (<u> N\u00famero de registro<\/u> , Apellido )<\/p><p>Paciente ( <u>SS No.<\/u> , Apellido )<\/p><p>Consulta ( <u>No.<\/u> , Fecha ,#N\u00b0SS , #Matr\u00edcula )<\/p><p>Prescrito (#<u>No., #C\u00f3digo<\/u> , NbSockets )<\/p><p><strong style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1.125rem;\">Torneo de tenis<\/strong><\/p><p>Jugador <u>(N\u00b0J<\/u> , Apellido )<\/p><p>Partido (N\u00b0M, Horario, #N\u00b0T, #N\u00b0J1, #N\u00b0J2, #N\u00b0G)<\/p><p>Suelo ( <u>No<\/u> , Superficie )<\/p><p><strong style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1.125rem;\">Compa\u00f1\u00eda a\u00e9rea<\/strong><\/p><p>compa\u00f1\u00eda ( <u>nombreC<\/u> , nacionalidad, direcci\u00f3n)<\/p><p>vuelos ( <u>numVuelo<\/u> , d\u00eda , hora , cname , #departureVname , #arrivalVname , #devicenum )\u00a0<\/p><p>aviones ( <u>numDispositivo<\/u> , a\u00f1oFab, modelo #)\u00a0<\/p><p>ciudades ( <u>nombreV <\/u>, pa\u00eds )<\/p><p>tipo de aeronave ( <u>modelo<\/u> , n\u00fameroPasajero)<\/p><p>personal ( <u>n\u00fameroSS<\/u> , nombre, funci\u00f3n)<\/p><p>alquiler (#<u>n\u00fameroC<\/u>\u00a0 , #numDevice , fecha de inicio , fecha de finalizaci\u00f3n )<\/p><p>tiene (#<u>n\u00fameroC<\/u> <u>, #num_dispositivo<\/u> , fecha de compra)<\/p><p>usos (#<u>n\u00famC, #n\u00famSS<\/u> , Fecha de contrataci\u00f3n )<\/p><p>tiene_para_funci\u00f3n (#<u>n\u00famVol, #numSS<\/u> , funci\u00f3nOnFlight )<\/p><p>est\u00e1_calificado (#<u>n\u00fameroSS, modelo #<\/u> , calificaci\u00f3n )<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-109c467 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"109c467\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f5b5462\" data-id=\"f5b5462\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ed7e440 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"ed7e440\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-da2441c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"da2441c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-71ae06f\" data-id=\"71ae06f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8ecfb5f elementor-widget elementor-widget-heading\" data-id=\"8ecfb5f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span class=\"ez-toc-section\" id=\"Exercice-5\"><\/span>Ejercicio 5<span class=\"ez-toc-section-end\"><\/span><\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6238990 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6238990\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1a9b402\" data-id=\"1a9b402\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a883fab elementor-widget elementor-widget-text-editor\" data-id=\"a883fab\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Queremos crear un sistema de informaci\u00f3n hospitalaria. El objetivo es poder responder a las siguientes preguntas:<\/p><ul><li>\u00bfQu\u00e9 m\u00e9dico trabaja en qu\u00e9 departamento?<\/li><li>\u00bfQu\u00e9 m\u00e9dico sigue a qu\u00e9 paciente? y rec\u00edprocamente ?<\/li><li>\u00bfA qu\u00e9 departamento ingres\u00f3 el paciente?<\/li><li>Permitir el seguimiento de las recetas dadas a un paciente (qu\u00e9 y por qui\u00e9n, etc.)<\/li><\/ul><p>En este hospital existen varios departamentos, cada uno identificado por su nombre;<\/p><p>Cada m\u00e9dico est\u00e1 adscrito a un departamento;<\/p><p>Un paciente ingresa en un departamento y nunca lo cambia;<\/p><p>Un paciente puede ser seguido por varios m\u00e9dicos (potencialmente de diferentes departamentos).<\/p><p>La informaci\u00f3n que queremos tener en el SI es:<\/p><ul><li><strong>servicio<\/strong> : especialidad, n\u00famero_camas, ubicaci\u00f3n (edificio-piso)<\/li><li><strong>metro<\/strong><strong>doctor<\/strong> : nombre, n\u00fam_tel\u00e9fono, n\u00fam_inscripci\u00f3n_orden, especialidad<\/li><li><strong>paciente<\/strong> : nombre, num_SS, patolog\u00eda, fecha_entrada, fecha_salida<\/li><li><strong>prescripci\u00f3n<\/strong> : paciente, m\u00e9dico, medicaci\u00f3n, dosis, fecha<\/li><\/ul><p>A\u00f1adir\u00e1s toda la informaci\u00f3n que te parezca necesaria para construir el diagrama E\/A y escribir\u00e1s el diagrama E\/A del hospital IS y luego el diagrama relacional.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c882e36 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c882e36\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e8a9cfe\" data-id=\"e8a9cfe\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-51a198c elementor-widget elementor-widget-toggle\" data-id=\"51a198c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"toggle.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-8551\" class=\"elementor-tab-title\" data-tab=\"1\" role=\"button\" aria-controls=\"elementor-tab-content-8551\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon elementor-toggle-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-closed\"><i class=\"fas fa-caret-right\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-opened\"><i class=\"elementor-toggle-icon-opened fas fa-caret-up\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-toggle-title\" tabindex=\"0\">Soluci\u00f3n<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<div id=\"elementor-tab-content-8551\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"region\" aria-labelledby=\"elementor-tab-title-8551\"><p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19889 size-full\" src=\"http:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd4.png\" alt=\"modelo entidad-asociaci\u00f3n\" width=\"613\" height=\"498\" title=\"\" srcset=\"https:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd4.png 613w, https:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd4-300x244.png 300w, https:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd4-15x12.png 15w\" sizes=\"(max-width: 613px) 100vw, 613px\" \/><\/p><p><strong>Hospital<\/strong> ( <u>nombreH:varchar<\/u> , tel\u00e9fonoH:varchar)<\/p><p><strong>Servicios<\/strong> (<u>nombres:varchar<\/u> , especialidad: varchar, nbre_beds: int, #nomH: varchar, #num_floor: int)<\/p><p><strong>doctores<\/strong> (n\u00fam_pedido: int, n\u00fam_tel\u00e9fono: varchar, especialidad_m\u00e9dica: varchar, #nomH: varchar, #nomS: varchar)<\/p><p><strong>Pacientes<\/strong> ( <u>n\u00famero_SS<\/u> , P_nombre )<\/p><p><strong>hospitalizado<\/strong> ( #<u>n\u00fam_SS, #nomS<\/u> , fecha_entrada, fecha_salida)<\/p><p><strong>Aseado<\/strong> ( #<u>n\u00fam_orden, # n\u00fam_SS<\/u> , patolog\u00eda)<\/p><p><strong>Piso<\/strong> ( <u>n\u00famero_piso, #nombre_edificio<\/u> )<\/p><p><strong>Edificio<\/strong> ( <u>Nombre del edificio<\/u> , numero de pisos)<\/p><p><strong>Consulta<\/strong> (<u>numero_Consulta<\/u>, fecha_Consulta, #num_pedido, #num_ss)<\/p><p><strong>Prescrito<\/strong> (<u>numero_Consulta<\/u>, <u>n\u00famero_droga<\/u>, dosis_Prescrita)<\/p><p><strong>Medicamento<\/strong> (<u>n\u00famero_droga<\/u>, libelle_Medicamento)<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b8f6e4b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b8f6e4b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ed035bb\" data-id=\"ed035bb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a87f577 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"a87f577\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-97fde42 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"97fde42\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-64d30bb\" data-id=\"64d30bb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4238bc2 elementor-widget elementor-widget-heading\" data-id=\"4238bc2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span class=\"ez-toc-section\" id=\"Exercice-6\"><\/span>Ejercicio 6<span class=\"ez-toc-section-end\"><\/span><\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9dd59c4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9dd59c4\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-10768ee\" data-id=\"10768ee\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6ae2852 elementor-widget elementor-widget-text-editor\" data-id=\"6ae2852\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>El responsable del m\u00e1ster GG quiere desarrollar una aplicaci\u00f3n web para gestionar la informaci\u00f3n de los alumnos matriculados en la opci\u00f3n y antiguos alumnos de la opci\u00f3n.<\/p><p>La informaci\u00f3n que se conservar\u00e1 son los datos de contacto (apellido, nombre, direcci\u00f3n, correo electr\u00f3nico, contrase\u00f1a, baja o suspensi\u00f3n), progreso en el curso (curso realizado y calificaciones, as\u00ed como cursos a realizar), informaci\u00f3n sobre la tesis (t\u00edtulo , director(es), lectores, fecha de obtenci\u00f3n, nota). Para los antiguos alumnos tambi\u00e9n nos gustar\u00eda conservar los datos de contacto y los trabajos actuales y anteriores.<\/p><p>Las modificaciones de datos se rigen por las siguientes reglas:<\/p><p>\u2013 El responsable de la opci\u00f3n puede modificar todos los datos;<\/p><p>\u2013 Los estudiantes pueden actualizar sus datos de contacto, el curso a seguir y las calificaciones obtenidas en los cursos tomados (el sistema no est\u00e1 conectado al sistema de la Escuela y las calificaciones est\u00e1n ah\u00ed solo para informaci\u00f3n del responsable de la opci\u00f3n de curso) como as\u00ed como informaci\u00f3n sobre sus puestos de trabajo.<\/p><p>El sistema debe recordar la fecha de la \u00faltima modificaci\u00f3n del curso realizada por un alumno para que el gestor pueda consultar las modificaciones.<\/p><p>S\u00f3lo el administrador de opciones y el estudiante interesado pueden ver la informaci\u00f3n relativa al curso.<\/p><p>Nos gustar\u00eda poder, para las personas autorizadas, enviar un correo electr\u00f3nico a estudiantes actuales y\/o antiguos estudiantes.<\/p><p>Tambi\u00e9n deseamos publicar, para el p\u00fablico en general, el directorio de exalumnos de la opci\u00f3n DataScience as\u00ed como la lista de estudiantes actualmente en el curso.<\/p><p>Agregar\u00e1s toda la informaci\u00f3n que te parezca necesaria para construir el diagrama E\/A y luego el diagrama relacional.<\/p><p><strong>Ojo con no querer escribir todo en el modelo E\/A, los derechos de lectura, escritura y modificaci\u00f3n se configurar\u00e1n seg\u00fan los perfiles de usuario.<\/strong><\/p><p><strong>El env\u00edo de correos electr\u00f3nicos no forma parte de las estructuras de datos sino de las acciones a realizar. S\u00f3lo tienes que asegurarte de que los datos estar\u00e1n ah\u00ed para que esto suceda.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-86d9be5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"86d9be5\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bcf445f\" data-id=\"bcf445f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d953e13 elementor-widget elementor-widget-toggle\" data-id=\"d953e13\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"toggle.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-2271\" class=\"elementor-tab-title\" data-tab=\"1\" role=\"button\" aria-controls=\"elementor-tab-content-2271\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon elementor-toggle-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-closed\"><i class=\"fas fa-caret-right\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-opened\"><i class=\"elementor-toggle-icon-opened fas fa-caret-up\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-toggle-title\" tabindex=\"0\">Soluci\u00f3n<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<div id=\"elementor-tab-content-2271\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"region\" aria-labelledby=\"elementor-tab-title-2271\"><p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19890 size-full\" src=\"http:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd5.png\" alt=\"modelo entidad-asociaci\u00f3n\" width=\"542\" height=\"558\" title=\"\" srcset=\"https:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd5.png 542w, https:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd5-291x300.png 291w, https:\/\/complex-systems-ai.com\/wp-content\/uploads\/2024\/02\/bdd5-12x12.png 12w\" sizes=\"(max-width: 542px) 100vw, 542px\" \/><\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>An\u00e1lisis de software P\u00e1gina de inicio Wiki Ejercicios corregidos Modelo de Entidad de Asociaci\u00f3n Los siguientes ejercicios corregidos se refieren al modelo de Entidad de Asociaci\u00f3n, construcci\u00f3n, modelado y\u2026 <\/p>","protected":false},"author":1,"featured_media":0,"parent":4609,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-19881","page","type-page","status-publish","hentry"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/complex-systems-ai.com\/es\/wp-json\/wp\/v2\/pages\/19881","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/complex-systems-ai.com\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/complex-systems-ai.com\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/complex-systems-ai.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/complex-systems-ai.com\/es\/wp-json\/wp\/v2\/comments?post=19881"}],"version-history":[{"count":10,"href":"https:\/\/complex-systems-ai.com\/es\/wp-json\/wp\/v2\/pages\/19881\/revisions"}],"predecessor-version":[{"id":20494,"href":"https:\/\/complex-systems-ai.com\/es\/wp-json\/wp\/v2\/pages\/19881\/revisions\/20494"}],"up":[{"embeddable":true,"href":"https:\/\/complex-systems-ai.com\/es\/wp-json\/wp\/v2\/pages\/4609"}],"wp:attachment":[{"href":"https:\/\/complex-systems-ai.com\/es\/wp-json\/wp\/v2\/media?parent=19881"}],"curies":[{"name":"gracias","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}