{"id":108,"date":"2021-02-18T22:00:09","date_gmt":"2021-02-18T22:00:09","guid":{"rendered":"http:\/\/javierjimenez.mondaenlaweb.com\/?p=108"},"modified":"2021-02-18T22:00:09","modified_gmt":"2021-02-18T22:00:09","slug":"transformacion-modelo-entidad-relacion-a-modelo-relacional","status":"publish","type":"post","link":"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/","title":{"rendered":"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional"},"content":{"rendered":"<h1 style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\">Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional<\/span><\/h1>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">He preparado una tabla para hacer m\u00e1s f\u00e1cil la transformaci\u00f3n de un diagrama entidad-relaci\u00f3n a un modelo relacional. Seg\u00fan la relaci\u00f3n y la cardinalidad entre las entidades de nuestro diagrama, estas pueden transformarse a tablas o no.<\/span><\/p>\n<p><a href=\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/entidad-relacion_a_modelo_relacional\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-109\" title=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional\" src=\"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2016\/09\/entidad-relacion_a_modelo_relacional-300x192.jpg\" alt=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional\" width=\"500\" height=\"320\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><iframe loading=\"lazy\" style=\"border: none;\" src=\"https:\/\/rcm-eu.amazon-adsystem.com\/e\/cm?o=30&amp;p=48&amp;l=ur1&amp;category=prime_student&amp;banner=04E4YST7J9TCC3S73ZR2&amp;f=ifr&amp;linkID=b8142665a23147742b9357ca4e0ae3c6&amp;t=javierjg-21&amp;tracking_id=javierjg-21\" width=\"728\" height=\"90\" frameborder=\"0\" marginwidth=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Os dejo un archivo\u00a0<strong>PDF<\/strong> con la tabla de transformaciones y paso a explicarosla:<\/span><!--more--><\/p>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\"><strong><a href=\"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2016\/09\/TransformacionERrelacional.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional<\/a><\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>LEYENDA<\/strong><\/span><\/h2>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Para el esquema relacional de los siguientes casos hay que tener en cuenta:<\/span><\/p>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Negrita<\/strong>: Clave<\/span><\/p>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\"><span style=\"text-decoration: underline;\"><strong>Negrita y subrayado<\/strong><\/span>: clave primaria<\/span><\/p>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>(fk)<\/strong>: Foreign Key (Clave for\u00e1nea)<\/span><\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>RELACI\u00d3N N:M<\/strong><\/span><\/h2>\n<hr \/>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Cuando la cardinalidad de la relaci\u00f3n entre dos entidades es <em>varios a varios<\/em>\u00a0(<strong>N:M<\/strong>), la relaci\u00f3n siempre se transforma en tabla, adoptando como clave primaria y a la vez for\u00e1nea, las claves primarias de las dos entidades, y teniendo como atributos los propios de la relaci\u00f3n.<\/span><\/p>\n<p><a href=\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/casonm-2\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-112 size-medium\" title=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - CasoNM\" src=\"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2016\/09\/casoNM-1-300x183.jpg\" alt=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - CasoNM\" width=\"300\" height=\"183\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline; font-family: verdana, geneva, sans-serif;\">ESQUEMA RELACIONAL<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Entidad 1<\/strong> (<span style=\"text-decoration: underline;\"><strong>Id1<\/strong><\/span>, atributo1)<\/span><br \/>\n<span style=\"font-family: verdana, geneva, sans-serif;\"> <strong>Entidad 2<\/strong> (<span style=\"text-decoration: underline;\"><strong>Id2<\/strong><\/span>, atributo2)<\/span><br \/>\n<span style=\"font-family: verdana, geneva, sans-serif;\"> <strong>Relaci\u00f3n<\/strong> (<span style=\"text-decoration: underline;\"><strong>Id1(fk), Id2(fk)<\/strong><\/span>, atributoRelaci\u00f3n)<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>RELACI\u00d3N 1:N<\/strong><\/span><\/h2>\n<hr \/>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Relaci\u00f3n <em>uno a varios <\/em>(<strong>1:<\/strong><strong>N<\/strong>). Para estas relaciones\u00a0tenemos dos casos distintos:<\/span><\/p>\n<h3><span style=\"font-family: verdana, geneva, sans-serif;\"><strong><span style=\"text-decoration: underline;\">Caso 1:1<\/span><\/strong><\/span><\/h3>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Se aplica cuando la entidad con cardinalidad m\u00e1xima 1 es obligatoria, es decir (1,1).<\/span><\/p>\n<p><a href=\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/caso1n\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-115 size-medium\" title=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - caso 1N\" src=\"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2016\/09\/caso1N-300x186.jpg\" alt=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - caso1N\" width=\"300\" height=\"186\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline; font-family: verdana, geneva, sans-serif;\">ESQUEMA RELACIONAL<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Entidad(1,1)<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdEntidad(1,1)<\/strong><\/span>, Atributos_Entidad(1,1))<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Entidad(N)<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdEntidad(N)<\/strong><\/span>, Atributos_Entidad(N), <strong>IdEntidad(1,1)(fk)<\/strong>)<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"font-family: verdana, geneva, sans-serif;\"><strong><span style=\"text-decoration: underline;\">Caso 0:1<\/span><\/strong><\/span><\/h3>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Este caso se aplica cuando la entidad con cardinalidad m\u00e1xima 1 no es obligatoria, es decir (0,1).<\/span><\/p>\n<p><a href=\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/caso1n2\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-116 size-medium\" title=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - caso 01\" src=\"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2016\/09\/caso1N2-300x185.jpg\" alt=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - caso 01\" width=\"300\" height=\"185\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline; font-family: verdana, geneva, sans-serif;\">ESQUEMA RELACIONAL<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Entidad(1)<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdEntidad(1)<\/strong><\/span>, AtributosEntidad(1))<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Entidad(N)<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdEntidad(N)<\/strong><\/span>, AtributosEntidad(N))<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Relaci\u00f3n<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdEntidad(N)(fk)<\/strong><\/span>, AtributosRelaci\u00f3n, <strong>IdEntidad(1)(fk)<\/strong>)<\/span><\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>RELACI\u00d3N 1:1<\/strong><\/span><\/h2>\n<hr \/>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Para las relaciones 1:1 podemos encontrarnos con tres casos distintos:<\/span><\/p>\n<h3><span style=\"font-family: verdana, geneva, sans-serif;\"><span style=\"text-decoration: underline;\"><strong>Caso (1,1)(1,1)<\/strong><\/span><\/span><\/h3>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Se unen ambas entidades en una tabla y se escoge como clave primaria una cualquiera de las dos.<\/span><\/p>\n<p><a href=\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/caso11-11\/\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-117 size-medium\" title=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - caso 11-11\" src=\"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2016\/09\/caso11-11-300x189.jpg\" alt=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - caso 11-11\" width=\"300\" height=\"189\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline; font-family: verdana, geneva, sans-serif;\">ESQUEMA RELACIONAL<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Entidad1yEntidad2<\/strong> (<span style=\"text-decoration: underline;\"><strong>Id1<\/strong><\/span>, Atributos1, Atributos2, <strong>Id2(fk)<\/strong>)<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\">Se puede elegir c\u00faal clave ser\u00e1 primaria y cu\u00e1l for\u00e1nea<\/span><\/p>\n<h3><span style=\"font-family: verdana, geneva, sans-serif;\"><span style=\"text-decoration: underline;\"><strong>Caso (1,1)(0,1)<\/strong><\/span><\/span><\/h3>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">La clave primaria de la entidad con cardinalidad (1,1) se propaga como clave for\u00e1nea de la entidad con cardinalidad (0,1).<\/span><\/p>\n<p><a href=\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/caso01-11\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-118 size-medium\" title=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - caso 01-11\" src=\"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2016\/09\/caso01-11-300x199.jpg\" alt=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - caso 01-11\" width=\"300\" height=\"199\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline; font-family: verdana, geneva, sans-serif;\">ESQUEMA RELACIONAL<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Entidad(1,1)<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdEntidad(1,1)<\/strong><\/span>, AtributosEntidad(1,1))<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Entidad(0,1)<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdEntidad(0,1)<\/strong><\/span>, AtributosEntidad(0,1), <strong>IdEntidad(1,1)(fk)<\/strong>)<\/span><\/p>\n<h3><span style=\"font-family: verdana, geneva, sans-serif;\"><span style=\"text-decoration: underline;\"><strong>Caso (0,1)(0,1)<\/strong><\/span><\/span><\/h3>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">La relaci\u00f3n se convierte en tabla y su clave primaria estar\u00e1 compuesta por las claves primarias de ambas entidades, que a la vez ser\u00e1n claves for\u00e1neas.<\/span><\/p>\n<p><a href=\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/caso01-01\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-119 size-medium\" title=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - caso 01-01\" src=\"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2016\/09\/caso01-01-300x179.jpg\" alt=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - caso 01-01\" width=\"300\" height=\"179\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline; font-family: verdana, geneva, sans-serif;\">ESQUEMA RELACIONAL<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Entidad1<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdEntidad1<\/strong><\/span>, AtributosEntidad1)<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Entidad2<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdEntidad2<\/strong><\/span>, AtributosEntidad2)<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Relaci\u00f3n<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdEntidad1(fk)<\/strong><strong>, IdEntidad2(fk)<\/strong><\/span>, AtributosRelaci\u00f3n)<\/span><\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>RELACI\u00d3N REFLEXIVA<\/strong><\/span><\/h2>\n<hr \/>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Pueden darse los siguientes casos:<\/span><\/p>\n<h3><span style=\"font-family: verdana, geneva, sans-serif;\"><span style=\"text-decoration: underline;\"><strong>Caso (1:1)<\/strong><\/span><\/span><\/h3>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">En la tabla resultante se agregar\u00e1 2 veces el mismo atributo, como clave primaria y como clave for\u00e1nea a ella misma.<\/span><\/p>\n<p><a href=\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/reflexiva11\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-120 size-medium\" title=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - reflexiva 11\" src=\"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2016\/09\/reflexiva11-300x215.jpg\" alt=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - reflexiva 11\" width=\"300\" height=\"215\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline; font-family: verdana, geneva, sans-serif;\">ESQUEMA RELACIONAL<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Entidad1<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdEntidad1<\/strong><\/span>, AtributosEntidad1, <strong>IdRol(fk)<\/strong>)<\/span><\/p>\n<h3><span style=\"font-family: verdana, geneva, sans-serif;\"><span style=\"text-decoration: underline;\"><strong>Caso (1:N)<\/strong><\/span><\/span><\/h3>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Para este tipo hay dos casos:<\/span><\/p>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">&#8211; 1:N. Si tiene cardinalidad (1,N) se procede igual que en las relaciones 1:1<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline; font-family: verdana, geneva, sans-serif;\">ESQUEMA RELACIONAL<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Entidad1<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdEntidad1<\/strong><\/span>, AtributosEntidad1, <strong>IdRol(fk)<\/strong>)<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\">Igual que el caso anterior<\/span><\/p>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">\u00a0&#8211; 0:N. Si tiene cardinalidad (0,N) se crea una nueva tabla cuya clave ser\u00e1 la de la entidad del lado de <em>varios\u00a0<\/em>y, adem\u00e1s, se propaga la clave a la nueva tabla como clave for\u00e1nea.<\/span><\/p>\n<p><a href=\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/reflexiva0n\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-121 size-medium\" title=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - reflexiva 0N\" src=\"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2016\/09\/reflexiva0N-300x204.jpg\" alt=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - reflexiva 0N\" width=\"300\" height=\"204\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline; font-family: verdana, geneva, sans-serif;\">ESQUEMA RELACIONAL<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Entidad1<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdEntidad1<\/strong><\/span>, Atributos1)<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Rol<\/strong> (<strong><span style=\"text-decoration: underline;\">IdEntidad1<\/span>, IdRol(fk)<\/strong>)<\/span><\/p>\n<h3><span style=\"font-family: verdana, geneva, sans-serif;\"><span style=\"text-decoration: underline;\"><strong>Caso (N:M)<\/strong><\/span><\/span><\/h3>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Se procede igual que las relaciones N:M. La relaci\u00f3n se convierte en tabla y su clave primaria estar\u00e1 compuesta por la clave primaria de ambos roles. Estas a la vez ser\u00e1n clave primaria y for\u00e1neas.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-122 size-medium\" title=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - reflexiva NM\" src=\"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2016\/09\/reflexivaNM-300x206.jpg\" alt=\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional - reflexiva NM\" width=\"300\" height=\"206\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline; font-family: verdana, geneva, sans-serif;\">ESQUEMA RELACIONAL<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Entidad1<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdEntidad1<\/strong><\/span>, Atributos1)<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Rol<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdRol<\/strong><\/span>, AtributosRol)<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Relaci\u00f3n<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdEntidad1(fk), IdRol(fk)<\/strong><\/span>, AtributosRelaci\u00f3n)<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\">Igual que las relaciones N:M Binarias<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>RELACI\u00d3N TERNARIA<\/strong><\/span><\/h2>\n<hr \/>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">La relaci\u00f3n se convierte en tabla, conteniendo sus atributos m\u00e1s las claves primarias de todas las entidades que asocia como claves ajenas.<\/span><br \/>\n<span style=\"font-family: verdana, geneva, sans-serif;\"> La clave primaria de la tabla resultante se compondr\u00e1 de las claves de las entidades, teniendo en cuenta los siguientes casos:<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"font-family: verdana, geneva, sans-serif;\"><strong><span style=\"text-decoration: underline;\">Relaci\u00f3n\u00a0N:N:N.<\/span><\/strong>\u00a0<\/span><\/h3>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Clave primaria de la relaci\u00f3n compuesta por las claves de las entidades que a la vez ser\u00e1n for\u00e1neas.<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline; font-family: verdana, geneva, sans-serif;\">ESQUEMA RELACIONAL<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Relaci\u00f3n<\/strong> (<span style=\"text-decoration: underline;\"><strong>Id1(fk), Id2(fk), Id3(fk)<\/strong><\/span>)<\/span><\/p>\n<h3><span style=\"font-family: verdana, geneva, sans-serif;\"><strong><span style=\"text-decoration: underline;\">Relaci\u00f3n 1:N:N.<\/span><\/strong> <\/span><\/h3>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Igual que la anterior, pero la clave de la entidad con cardinalidad m\u00e1xima 1 s\u00f3lo ser\u00e1 for\u00e1nea, pero no primaria.<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline; font-family: verdana, geneva, sans-serif;\">ESQUEMA RELACIONAL<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Relaci\u00f3n<\/strong> (<span style=\"text-decoration: underline;\"><strong>Id1(fk), Id2(fk)<\/strong><\/span>,<strong> Id3(fk)<\/strong>)<\/span><\/p>\n<h3><span style=\"font-family: verdana, geneva, sans-serif;\"><strong><span style=\"text-decoration: underline;\">Relaci\u00f3n 1:1:N.<\/span> <\/strong><\/span><\/h3>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Las claves primarias de las entidades ser\u00e1n for\u00e1neas de la relaci\u00f3n, y la clave de la entidad con cardinalidad m\u00e1xima N ser\u00e1 a la vez primaria de la relaci\u00f3n.<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline; font-family: verdana, geneva, sans-serif;\">ESQUEMA RELACIONAL<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Relaci\u00f3n<\/strong> (<span style=\"text-decoration: underline;\"><strong>Id1(fk)<\/strong><\/span>,<strong> Id2(fk), Id3(fk)<\/strong>)<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>GENERALIZACI\u00d3N<\/strong><\/span><\/h2>\n<hr \/>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Para este tipo de relaciones tenemos 3 opciones:<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"font-family: verdana, geneva, sans-serif;\"><strong><span style=\"text-decoration: underline;\">Opci\u00f3n\u00a01.<\/span><\/strong> <\/span><\/h3>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Integrar todas las entidades en una \u00fanica tabla absorbiendo los subtipos. Se crea una tabla que contiene todos los atributos de la superentidad, todos los de las subentidades y el atributo discriminatorio para distinguir a qu\u00e9 subentidad pertenece cada registro de la tabla. Esta regla puede aplicarse a cualquier tipo de jerarqu\u00eda.<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline; font-family: verdana, geneva, sans-serif;\">ESQUEMA RELACIONAL<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\">Todas las subentidades dentro de la tabla de superentidad<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Superentidad<\/strong> ( <span style=\"text-decoration: underline;\"><strong>IdSuperentidad<\/strong><\/span>, AtributosEntidad, AtributosSub1, AtributosSub2)<\/span><\/p>\n<h3><span style=\"font-family: verdana, geneva, sans-serif;\"><strong><span style=\"text-decoration: underline;\">Opci\u00f3n\u00a02.<\/span><\/strong> <\/span><\/h3>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Eliminaci\u00f3n de la superentidad en jerarqu\u00edas totales y exclusivas. transfiriendo los atributos de la superentidad a cada subentidad, cre\u00e1ndose una tabla por cada subentidad, por tanto la superentidad no tendr\u00e1 tabla y se elimina el atributo que distingue entre subentidades.<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline; font-family: verdana, geneva, sans-serif;\">ESQUEMA RELACIONAL<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\">Eliminaci\u00f3n de la superentidad en jerarqu\u00edas totales y exclusivas<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Sub1<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdSuperentidad<\/strong><\/span>, AtributosSuperentidad, AtributosSub1)<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Sub2<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdSuperentidad<\/strong><\/span>, AtributosSuperentidad, AtributosSub2)<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Relaci\u00f3n_Sub1<\/strong> (Depende de la cardinalidad de la relaci\u00f3n)<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Relaci\u00f3n_Sub2<\/strong> (Depende de la cardinalidad de la relaci\u00f3n)<\/span><\/p>\n<h3><span style=\"font-family: verdana, geneva, sans-serif;\"><strong><span style=\"text-decoration: underline;\">Opci\u00f3n\u00a03.<\/span><\/strong> <\/span><\/h3>\n<p><span style=\"font-family: verdana, geneva, sans-serif;\">Insertar una relaci\u00f3n 1:1 entre la superentidad y las subentidades. Los atributos se mantienen y cada subentidad se identificar\u00e1 con una clave ajena referenciando a la clave primaria de la superentidad. La superentidad mantendr\u00e1 una relaci\u00f3n 1:1 con cada subentidad.<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline; font-family: verdana, geneva, sans-serif;\">ESQUEMA RELACIONAL<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\">Insertar relaci\u00f3n 1:1 entre la superentidad y las subentidades<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Superentidad<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdSuperentidad<\/strong><\/span>, AtributosSuperentidad)<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Sub1<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdSuperentidad<\/strong><\/span>, AtributosSub1)<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Sub2<\/strong> (<span style=\"text-decoration: underline;\"><strong>IdSuperentidad<\/strong><\/span>, AtributosSub2)<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\"><strong>Relaci\u00f3n<\/strong> (Depende de la cardinalidad de la relaci\u00f3n entre Supertipo y la otra<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: verdana, geneva, sans-serif;\">entidad)<\/span><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: center;\"><span style=\"font-family: ABeeZee;\">Libros recomendados<\/span><\/h2>\n<p style=\"text-align: center;\"><strong><a href=\"https:\/\/amzn.to\/2OsMeYU\" target=\"_blank\" rel=\"noopener noreferrer\">Aprende SQL en un fin de semana<\/a><\/strong><\/p>\n<p><a href=\"https:\/\/amzn.to\/2OsMeYU\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-676 size-medium\" title=\"Aprende SQL en un fin de semana\" src=\"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2017\/11\/Aprende_SQL-200x300.jpg\" alt=\"Aprende SQL en un fin de semana\" width=\"200\" height=\"300\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><strong><a href=\"https:\/\/amzn.to\/36uhzkL\" target=\"_blank\" rel=\"noopener\">Modelos de Bases de Datos<\/a><\/strong><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/amzn.to\/36uhzkL\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1074 size-medium\" title=\"Modelos de Bases de Datos\" src=\"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2016\/09\/modelos-de-bases-de-datos-188x300.jpg\" alt=\"Modelos de Bases de Datos\" width=\"188\" height=\"300\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/amzn.to\/37sQsXP\" target=\"_blank\" rel=\"noopener\">The Coder Habits: Los 39 h\u00e1bitos del programador profesional<\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/amzn.to\/2NcwtpE\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1093 size-full\" title=\"The Coder Habits\" src=\"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2016\/09\/theCoderHabits.png\" alt=\"The Coder Habits\" width=\"262\" height=\"348\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: center;\"><strong>Otros art\u00edculos<\/strong><\/h2>\n<p style=\"text-align: center;\"><span style=\"color: #0000ff;\"><strong><a style=\"color: #0000ff;\" href=\"https:\/\/javierjg.es\/blog\/instalacion-y-configuracion-mysql-5-7-windows\/\">Instalaci\u00f3n de MySQL 5.7<\/a><\/strong><\/span><\/p>\n<p style=\"text-align: center;\"><strong><a href=\"https:\/\/javierjg.es\/blog\/antivirus-eset-nod32-2021\/\">Antivirus ESET Nod32 100% Recomendado<\/a><\/strong><\/p>\n<p style=\"text-align: center;\"><em>Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional &#8211; Javier Jim\u00e9nez<\/em><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional &nbsp; He preparado una tabla para hacer m\u00e1s f\u00e1cil la transformaci\u00f3n de un diagrama entidad-relaci\u00f3n a un modelo relacional. Seg\u00fan la relaci\u00f3n y la cardinalidad entre las entidades de nuestro diagrama, estas pueden transformarse a tablas o no. Os dejo un archivo\u00a0PDF con la tabla de transformaciones y paso [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":119,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[38,77,90,117,118,121,150],"class_list":["post-108","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-base-de-datos","tag-bases-de-datos","tag-entidad-relacion-a-modelo-relacional","tag-gtb","tag-modelo-entidad-relacion","tag-modelo-relacional","tag-mysql","tag-transformacion-modelo-entidad-relacion-a-modelo-relacional"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.3.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Transformacion modelo E\/R a modelo relacional - JavierJG<\/title>\n<meta name=\"description\" content=\"He preparado una tabla para hacer m\u00e1s f\u00e1cil la transformaci\u00f3n de un diagrama entidad-relaci\u00f3n a un modelo relacional. Seg\u00fan la relaci\u00f3n ....\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Transformacion modelo E\/R a modelo relacional - JavierJG\" \/>\n<meta property=\"og:description\" content=\"He preparado una tabla para hacer m\u00e1s f\u00e1cil la transformaci\u00f3n de un diagrama entidad-relaci\u00f3n a un modelo relacional. Seg\u00fan la relaci\u00f3n ....\" \/>\n<meta property=\"og:url\" content=\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/\" \/>\n<meta property=\"og:site_name\" content=\"JavierJG\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/javierjimenez.emprendedor\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/javierjimenez.emprendedor\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-18T22:00:09+00:00\" \/>\n<meta name=\"author\" content=\"JavierJG\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@javiermonda\" \/>\n<meta name=\"twitter:site\" content=\"@javiermonda\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"JavierJG\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/\"},\"author\":{\"name\":\"JavierJG\",\"@id\":\"https:\/\/javierjg.es\/blog\/#\/schema\/person\/daf3e3ab7db4bf40e58d8ab3b495685e\"},\"headline\":\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional\",\"datePublished\":\"2021-02-18T22:00:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/\"},\"wordCount\":1050,\"commentCount\":7,\"publisher\":{\"@id\":\"https:\/\/javierjg.es\/blog\/#\/schema\/person\/daf3e3ab7db4bf40e58d8ab3b495685e\"},\"image\":{\"@id\":\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/#primaryimage\"},\"thumbnailUrl\":\"\",\"keywords\":[\"bases de datos\",\"entidad-relacion a modelo relacional\",\"gtb\",\"modelo entidad-relacion\",\"modelo relacional\",\"mysql\",\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional\"],\"articleSection\":[\"Base de datos\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/\",\"url\":\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/\",\"name\":\"Transformacion modelo E\/R a modelo relacional - JavierJG\",\"isPartOf\":{\"@id\":\"https:\/\/javierjg.es\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/#primaryimage\"},\"thumbnailUrl\":\"\",\"datePublished\":\"2021-02-18T22:00:09+00:00\",\"description\":\"He preparado una tabla para hacer m\u00e1s f\u00e1cil la transformaci\u00f3n de un diagrama entidad-relaci\u00f3n a un modelo relacional. Seg\u00fan la relaci\u00f3n ....\",\"breadcrumb\":{\"@id\":\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/javierjg.es\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/javierjg.es\/blog\/#website\",\"url\":\"https:\/\/javierjg.es\/blog\/\",\"name\":\"JavierJG\",\"description\":\"Blog personal de JavierJG\",\"publisher\":{\"@id\":\"https:\/\/javierjg.es\/blog\/#\/schema\/person\/daf3e3ab7db4bf40e58d8ab3b495685e\"},\"alternateName\":\"Blog personal de JavierJG\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/javierjg.es\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/javierjg.es\/blog\/#\/schema\/person\/daf3e3ab7db4bf40e58d8ab3b495685e\",\"name\":\"JavierJG\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/javierjg.es\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2024\/01\/JavierJG_Perfil.jpg\",\"contentUrl\":\"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2024\/01\/JavierJG_Perfil.jpg\",\"width\":958,\"height\":960,\"caption\":\"JavierJG\"},\"logo\":{\"@id\":\"https:\/\/javierjg.es\/blog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/javierjg.es\/blog\",\"https:\/\/www.facebook.com\/javierjimenez.emprendedor\",\"https:\/\/www.instagram.com\/javierjg.es\",\"https:\/\/www.linkedin.com\/in\/javierjg\/\",\"https:\/\/x.com\/javiermonda\"],\"url\":\"https:\/\/javierjg.es\/blog\/author\/platysendar\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Transformacion modelo E\/R a modelo relacional - JavierJG","description":"He preparado una tabla para hacer m\u00e1s f\u00e1cil la transformaci\u00f3n de un diagrama entidad-relaci\u00f3n a un modelo relacional. Seg\u00fan la relaci\u00f3n ....","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/","og_locale":"es_ES","og_type":"article","og_title":"Transformacion modelo E\/R a modelo relacional - JavierJG","og_description":"He preparado una tabla para hacer m\u00e1s f\u00e1cil la transformaci\u00f3n de un diagrama entidad-relaci\u00f3n a un modelo relacional. Seg\u00fan la relaci\u00f3n ....","og_url":"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/","og_site_name":"JavierJG","article_publisher":"https:\/\/www.facebook.com\/javierjimenez.emprendedor","article_author":"https:\/\/www.facebook.com\/javierjimenez.emprendedor","article_published_time":"2021-02-18T22:00:09+00:00","author":"JavierJG","twitter_card":"summary_large_image","twitter_creator":"@javiermonda","twitter_site":"@javiermonda","twitter_misc":{"Escrito por":"JavierJG","Tiempo de lectura":"7 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/#article","isPartOf":{"@id":"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/"},"author":{"name":"JavierJG","@id":"https:\/\/javierjg.es\/blog\/#\/schema\/person\/daf3e3ab7db4bf40e58d8ab3b495685e"},"headline":"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional","datePublished":"2021-02-18T22:00:09+00:00","mainEntityOfPage":{"@id":"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/"},"wordCount":1050,"commentCount":7,"publisher":{"@id":"https:\/\/javierjg.es\/blog\/#\/schema\/person\/daf3e3ab7db4bf40e58d8ab3b495685e"},"image":{"@id":"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/#primaryimage"},"thumbnailUrl":"","keywords":["bases de datos","entidad-relacion a modelo relacional","gtb","modelo entidad-relacion","modelo relacional","mysql","Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional"],"articleSection":["Base de datos"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/","url":"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/","name":"Transformacion modelo E\/R a modelo relacional - JavierJG","isPartOf":{"@id":"https:\/\/javierjg.es\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/#primaryimage"},"image":{"@id":"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/#primaryimage"},"thumbnailUrl":"","datePublished":"2021-02-18T22:00:09+00:00","description":"He preparado una tabla para hacer m\u00e1s f\u00e1cil la transformaci\u00f3n de un diagrama entidad-relaci\u00f3n a un modelo relacional. Seg\u00fan la relaci\u00f3n ....","breadcrumb":{"@id":"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/javierjg.es\/blog\/transformacion-modelo-entidad-relacion-a-modelo-relacional\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/javierjg.es\/blog\/"},{"@type":"ListItem","position":2,"name":"Transformaci\u00f3n modelo entidad-relaci\u00f3n a modelo relacional"}]},{"@type":"WebSite","@id":"https:\/\/javierjg.es\/blog\/#website","url":"https:\/\/javierjg.es\/blog\/","name":"JavierJG","description":"Blog personal de JavierJG","publisher":{"@id":"https:\/\/javierjg.es\/blog\/#\/schema\/person\/daf3e3ab7db4bf40e58d8ab3b495685e"},"alternateName":"Blog personal de JavierJG","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/javierjg.es\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/javierjg.es\/blog\/#\/schema\/person\/daf3e3ab7db4bf40e58d8ab3b495685e","name":"JavierJG","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/javierjg.es\/blog\/#\/schema\/person\/image\/","url":"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2024\/01\/JavierJG_Perfil.jpg","contentUrl":"https:\/\/javierjg.es\/blog\/wp-content\/uploads\/2024\/01\/JavierJG_Perfil.jpg","width":958,"height":960,"caption":"JavierJG"},"logo":{"@id":"https:\/\/javierjg.es\/blog\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/javierjg.es\/blog","https:\/\/www.facebook.com\/javierjimenez.emprendedor","https:\/\/www.instagram.com\/javierjg.es","https:\/\/www.linkedin.com\/in\/javierjg\/","https:\/\/x.com\/javiermonda"],"url":"https:\/\/javierjg.es\/blog\/author\/platysendar\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/javierjg.es\/blog\/wp-json\/wp\/v2\/posts\/108","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/javierjg.es\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/javierjg.es\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/javierjg.es\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/javierjg.es\/blog\/wp-json\/wp\/v2\/comments?post=108"}],"version-history":[{"count":0,"href":"https:\/\/javierjg.es\/blog\/wp-json\/wp\/v2\/posts\/108\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/javierjg.es\/blog\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/javierjg.es\/blog\/wp-json\/wp\/v2\/media?parent=108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/javierjg.es\/blog\/wp-json\/wp\/v2\/categories?post=108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/javierjg.es\/blog\/wp-json\/wp\/v2\/tags?post=108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}