PM01-0207. Relaciones entre tablas

Tablas como bases de datos

Relaciones entre tablas

[{"selector":"#anim-8993e851-aa71-4b62-beb1-745eccbacfa5","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-806e2a83-fc07-47a4-8057-fd48c7834939","keyframes":{"transform":["translate3d(0px, -219.02784%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2ca1a522-bd63-4a89-9eb1-5f6f592efe79","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-43bfeb93-f23b-4645-84fd-0cf07c64ea4c","keyframes":{"transform":["translate3d(107.51635%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-dbc22ee8-ab28-4c6d-9f24-b261053f50c4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cf33aed5-1533-4303-8c85-514afe26e582","keyframes":{"transform":["translate3d(-113.9394%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Ellas permiten conectar información relacionada y realizar análisis más profundos.

[{"selector":"#anim-667b1b27-9974-486e-9b71-510ce5751092","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-690ce2d8-d548-451a-ab90-9f883e02177e","keyframes":{"transform":["translate3d(0px, 189.48058%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-64ac7ada-42eb-49b6-9ce3-958b4ac392c9","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-991b13d5-c7c0-4046-9b37-7e53594f9990","keyframes":{"transform":["rotate(-348deg) translate3d(0px, -143.05555%, 0) rotate(348deg)","rotate(-348deg) translate3d(0px, 0px, 0) rotate(348deg)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] En una relación, una tabla tiene una clave primaria que se vincula con la clave externa de otra tabla. Esto establece una conexión entre los conjuntos de datos.

Esto es especialmente útil para:

[{"selector":"#anim-7ef90463-68e4-47e3-865e-87a180a5be5a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c1d6a4b1-76db-4f03-a9ce-6ff93a95d603","keyframes":{"transform":["translate3d(116.66667%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-84b10bd9-a8d3-4aed-bed9-307fcb6525e3","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-66915b56-1a64-4eea-891a-87a05ac9f140","keyframes":{"transform":["translate3d(0px, -213.47909%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0152bed5-25f7-44ca-bc37-9eae07105c97","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-512dbfcf-2467-42e9-a90c-201dbdde75d1","keyframes":{"transform":["translate3d(0px, 392.59225%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4a28d5e8-0b24-4fdc-8039-eb0e66a40537","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-af84696b-2c56-4f70-b4ad-d87536ee677b","keyframes":{"transform":["translate3d(-329.99998%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-310367e7-c093-4cd9-9422-35034808090c","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1c11b6b8-34ee-47b7-b1f9-3432ec053968","keyframes":{"transform":["translate3d(-329.99998%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-441cca1a-c97f-475c-9435-9c2962f34aa9","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5219fd59-883a-4cf2-9bf4-8695fc575d7b","keyframes":{"transform":["translate3d(-329.99998%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e3336a61-3449-4ee8-8585-19a558ffa768","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9ffa9a7b-ae8d-429f-aae0-047bc4eabb2a","keyframes":{"transform":["translate3d(-329.99998%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-30b68e57-7824-4555-8d63-e06adf1d2e01","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-eb602f96-89b9-4a7b-aee5-c94912a0eed2","keyframes":{"transform":["translate3d(-329.99998%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-25885024-5261-406d-b8f4-f59100f72281","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-57226ea1-8117-4313-8260-93211639829d","keyframes":{"transform":["translate3d(-329.99998%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0ed2bea3-ba40-4fd1-82df-208131bb3261","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b4e613cf-6494-4473-8d44-48e1b78c1d99","keyframes":{"transform":["translate3d(-329.99998%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] La integración de datos. Evitar la redundancia de datos. Facilitar el análisis relacional. Mejorar la precisión en los cálculos. Facilitar la creación de informes dinámicos. Mejorar la claridad y organización. Facilitar la colaboración en equipos. Entre otras aplicaciones más. Dot Dot Dot Dot Dot Dot Dot

Para ello, tú puedes:

[{"selector":"#anim-fa0cb40b-36dc-4839-841f-3498854acfc8","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1823fff2-c398-4e20-9b15-90c1eb63fe60","keyframes":{"transform":["translate3d(117.98561%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7239248f-bb37-4091-ba3d-e5484492f553","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-bb80f26f-3a5a-4d04-b3ca-c84b8f7f7cf2","keyframes":{"transform":["translate3d(-114.8265%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-820f8032-8200-44e1-a6de-d04e7539cab4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6130616a-511d-4edf-928c-84c9b76af25d","keyframes":{"transform":["translate3d(-364.99999%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-445d205b-3271-4441-baa6-2e14389f5261","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3598394d-694f-40d9-b5cf-b71378f4e185","keyframes":{"transform":["translate3d(-364.99999%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f81a6485-a114-40d5-a376-3fc389455213","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-02592a37-fa8a-4336-b91b-aad05a4b9817","keyframes":{"transform":["translate3d(0px, -117.34007%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Integrar la nueva información a tu misma base. Crear una nueva tabla dinámica con la información seleccionada. Dot Dot

Aprende cómo hacerlo:

[{"selector":"#anim-452b0654-a1c3-49cf-836c-11f28924db51","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5bb4d814-1529-4e76-97a8-a31044034963","keyframes":{"transform":["translate3d(-114.8265%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-31beb63b-4d31-4df0-9577-16867c3ee5c1","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fa17a8d3-5936-42cc-a588-21c63afcdc0d","keyframes":{"transform":["translate3d(-386.51686%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1c961fd3-492d-469d-b5c8-58ea5476659d","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6c725558-86da-4822-9d5a-6995593a266f","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cab5b35d-c813-4444-b8ec-945b74a51295","keyframes":{"transform":["translate3d(100.00000%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Aplica Burst with Arrow

[{"selector":"#anim-d2a089d8-138d-4376-90ec-eab714a52e47","keyframes":[{"offset":0,"transform":"translate3d(0, -166.2263%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.29,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.45,"transform":"translate3d(0, -46.74283556%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.61,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.71,"transform":"translate3d(0, -15.89123428%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.85,"transform":"translate3d(0, -5.967524170000001%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.96,"transform":"translate3d(0, -2.59313028%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1400,"fill":"both"}]