Exercici: Disparadors (triggers)

<div class="page"> <div class="cover text-center"> <img class="mx-auto" src=/itb/images/logo_mislata.png alt="logo"> # Disparadors (triggers) <div class="text-end fit-content ms-auto my-3 mt-auto pt-3"> <p><strong>Autor:</strong> Joan Puigcerver Ibáñez</p> <p><strong>Correu electrònic:</strong> j.puigcerveribanez@edu.gva.es</p> <p><strong>Curs:</strong> 2023/2024</p> </div> <div> <p class="fw-bold mb-0">Llicència: BY-NC-SA</p> <p class="d-none d-md-block">(Reconeixement - No Comercial - Compartir Igual)</p> <a href="https://creativecommons.org/licenses/by-nc-sa/4.0/deed.ca" target="_blank"> <img class="mx-auto" src="/itb/images/license.png" alt="Licence"/> </a> </div> </div> </div> {:toc} ## Introducció - Utilitza la carpeta __institut/triggers/__ per guardar els scripts de creació dels disparadors. - Anomena els fitxers segons el nom indicat en cada exercici. - Cada script ha de crear el disparador i res més. ## Base de dades Institut Utilitzant <a href="/itb/DAM-BD/UD6/exercicis/01_transactions.html" target="_blank">la base de dades institut amb l'ampliació de material</a>: __Fitxers:__ - <a href="/itb/DAM-BD/files/ca/institut/schema/create_schema_institut.sql" download="create_schema_institut.sql">create_schema_institut.sql</a> - <a href="/itb/DAM-BD/files/ca/institut/schema/create_schema_institut_material.sql" download="create_schema_institut_material.sql">create_schema_institut_material.sql</a> - <a href="/itb/DAM-BD/files/ca/institut/data/insert_data_institut.sql" download="insert_data_institut.sql">insert_data_institut.sql</a> - <a href="/itb/DAM-BD/files/ca/institut/data/insert_data_institut_material.sql" download="insert_data_institut_material.sql">insert_data_institut_material.sql</a> <div class="mxgraph" style="max-width:100%;border:1px solid transparent;" data-mxgraph="{"highlight":"#0000ff","nav":true,"resize":true,"toolbar":"zoom layers tags lightbox","edit":"_blank","xml":"<mxfile host=\"app.diagrams.net\" modified=\"2024-03-01T09:36:16.592Z\" agent=\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36\" etag=\"y37bCIXeTdM294vy4Zdy\" version=\"24.0.0\" type=\"device\">\n <diagram name=\"Pàgina-1\" id=\"5p1RK1gfJNGb53cNKMp1\">\n <mxGraphModel dx=\"3328\" dy=\"1907\" grid=\"1\" gridSize=\"10\" guides=\"1\" tooltips=\"1\" connect=\"1\" arrows=\"1\" fold=\"1\" page=\"1\" pageScale=\"1\" pageWidth=\"1654\" pageHeight=\"1169\" math=\"0\" shadow=\"0\">\n <root>\n <mxCell id=\"0\" />\n <mxCell id=\"1\" parent=\"0\" />\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-1\" value=\"PERSONA\" style=\"shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;\" parent=\"1\" vertex=\"1\">\n <mxGeometry x=\"-390\" y=\"740\" width=\"180\" height=\"240\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-2\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-1\" vertex=\"1\">\n <mxGeometry y=\"30\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-3\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-2\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-4\" value=\"dni\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-2\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-5\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-1\" vertex=\"1\">\n <mxGeometry y=\"60\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-6\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-5\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-7\" value=\"nom\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-5\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-8\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-1\" vertex=\"1\">\n <mxGeometry y=\"90\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-9\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-8\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-10\" value=\"cognoms\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-8\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-19\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-1\" vertex=\"1\">\n <mxGeometry y=\"120\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-20\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;\" parent=\"fk1w-hWQ3lKRHGFDh40k-19\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-21\" value=\"data_naixement\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;\" parent=\"fk1w-hWQ3lKRHGFDh40k-19\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-22\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-1\" vertex=\"1\">\n <mxGeometry y=\"150\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-23\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;\" parent=\"fk1w-hWQ3lKRHGFDh40k-22\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-24\" value=\"telefon\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;\" parent=\"fk1w-hWQ3lKRHGFDh40k-22\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-26\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-1\" vertex=\"1\">\n <mxGeometry y=\"180\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-27\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;\" parent=\"fk1w-hWQ3lKRHGFDh40k-26\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-28\" value=\"correu_personal\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;\" parent=\"fk1w-hWQ3lKRHGFDh40k-26\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-11\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-1\" vertex=\"1\">\n <mxGeometry y=\"210\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-12\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-11\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-13\" value=\"correu_corporatiu\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-11\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-29\" value=\"ESTUDIANT\" style=\"shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;\" parent=\"1\" vertex=\"1\">\n <mxGeometry x=\"-530\" y=\"390\" width=\"180\" height=\"210\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-30\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-29\" vertex=\"1\">\n <mxGeometry y=\"30\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-31\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-30\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-32\" value=\"nia\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-30\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-33\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-29\" vertex=\"1\">\n <mxGeometry y=\"60\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-34\" value=\"FK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-33\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-35\" value=\"dni\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-33\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-36\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-29\" vertex=\"1\">\n <mxGeometry y=\"90\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-37\" value=\"FK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-36\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-38\" value=\"id_cicle\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-36\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-39\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-29\" vertex=\"1\">\n <mxGeometry y=\"120\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-40\" value=\"FK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;\" parent=\"fk1w-hWQ3lKRHGFDh40k-39\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-41\" value=\"curs\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;\" parent=\"fk1w-hWQ3lKRHGFDh40k-39\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-42\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-29\" vertex=\"1\">\n <mxGeometry y=\"150\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-43\" value=\"FK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;\" parent=\"fk1w-hWQ3lKRHGFDh40k-42\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-44\" value=\"lletra_grup\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;\" parent=\"fk1w-hWQ3lKRHGFDh40k-42\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-45\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-29\" vertex=\"1\">\n <mxGeometry y=\"180\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-46\" value=\"FK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;\" parent=\"fk1w-hWQ3lKRHGFDh40k-45\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-47\" value=\"semipresencial\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;\" parent=\"fk1w-hWQ3lKRHGFDh40k-45\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-51\" value=\"\" style=\"triangle;whiteSpace=wrap;html=1;rotation=-90;\" parent=\"1\" vertex=\"1\">\n <mxGeometry x=\"-315\" y=\"638.75\" width=\"30\" height=\"42.5\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-52\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=none;endFill=0;\" parent=\"1\" source=\"fk1w-hWQ3lKRHGFDh40k-1\" target=\"fk1w-hWQ3lKRHGFDh40k-51\" edge=\"1\">\n <mxGeometry relative=\"1\" as=\"geometry\">\n <mxPoint x=\"-200\" y=\"710\" as=\"sourcePoint\" />\n <mxPoint x=\"-152\" y=\"760\" as=\"targetPoint\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-53\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=none;endFill=0;edgeStyle=orthogonalEdgeStyle;entryX=0.228;entryY=1.033;entryDx=0;entryDy=0;entryPerimeter=0;\" parent=\"1\" source=\"fk1w-hWQ3lKRHGFDh40k-51\" target=\"fk1w-hWQ3lKRHGFDh40k-59\" edge=\"1\">\n <mxGeometry relative=\"1\" as=\"geometry\">\n <mxPoint x=\"-105\" y=\"786\" as=\"sourcePoint\" />\n <mxPoint x=\"-80\" y=\"510\" as=\"targetPoint\" />\n <Array as=\"points\">\n <mxPoint x=\"-159\" y=\"660\" />\n </Array>\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-54\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=none;endFill=0;edgeStyle=orthogonalEdgeStyle;\" parent=\"1\" source=\"fk1w-hWQ3lKRHGFDh40k-51\" target=\"fk1w-hWQ3lKRHGFDh40k-29\" edge=\"1\">\n <mxGeometry relative=\"1\" as=\"geometry\">\n <mxPoint x=\"-280\" y=\"640\" as=\"sourcePoint\" />\n <mxPoint x=\"-320\" y=\"510\" as=\"targetPoint\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-55\" value=\"PROFESSOR\" style=\"shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;\" parent=\"1\" vertex=\"1\">\n <mxGeometry x=\"-200\" y=\"390\" width=\"180\" height=\"90\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-56\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-55\" vertex=\"1\">\n <mxGeometry y=\"30\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-57\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-56\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-58\" value=\"dni\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-56\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-59\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-55\" vertex=\"1\">\n <mxGeometry y=\"60\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-60\" value=\"FK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-59\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-61\" value=\"id_especialitat\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-59\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-74\" value=\"GRUP\" style=\"shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;\" parent=\"1\" vertex=\"1\">\n <mxGeometry x=\"-390\" y=\"80\" width=\"180\" height=\"180\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-98\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;fontStyle=1\" parent=\"fk1w-hWQ3lKRHGFDh40k-74\" vertex=\"1\">\n <mxGeometry y=\"30\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-99\" value=\"&lt;b&gt;PK&lt;/b&gt;\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=0;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-98\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-100\" value=\"&lt;b&gt;&lt;u&gt;id_cicle&amp;nbsp;&lt;/u&gt;&lt;/b&gt;&lt;u style=&quot;border-color: var(--border-color); font-weight: 700;&quot;&gt;(FK)&lt;/u&gt;\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=0;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-98\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-106\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-74\" vertex=\"1\">\n <mxGeometry y=\"60\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-107\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-106\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-108\" value=\"&lt;b&gt;&lt;u&gt;curs&lt;/u&gt;&lt;/b&gt;\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=0;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-106\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-102\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-74\" vertex=\"1\">\n <mxGeometry y=\"90\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-103\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-102\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-104\" value=\"&lt;b&gt;&lt;u&gt;lletra&lt;/u&gt;&lt;/b&gt;\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=0;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-102\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-75\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-74\" vertex=\"1\">\n <mxGeometry y=\"120\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-76\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-75\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-77\" value=\"semipresencial\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-75\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-78\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-74\" vertex=\"1\">\n <mxGeometry y=\"150\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-79\" value=\"FK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-78\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-80\" value=\"dni_tutor\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-78\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-109\" value=\"agrupats\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=ERmany;endFill=0;edgeStyle=orthogonalEdgeStyle;startArrow=ERone;startFill=0;endSize=12;startSize=12;exitX=0;exitY=0.5;exitDx=0;exitDy=0;\" parent=\"1\" source=\"fk1w-hWQ3lKRHGFDh40k-102\" target=\"fk1w-hWQ3lKRHGFDh40k-29\" edge=\"1\">\n <mxGeometry relative=\"1\" as=\"geometry\">\n <mxPoint x=\"250\" y=\"390\" as=\"sourcePoint\" />\n <mxPoint x=\"190\" y=\"450\" as=\"targetPoint\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-110\" value=\"tutoritza\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=ERone;endFill=0;edgeStyle=orthogonalEdgeStyle;startArrow=ERzeroToOne;startFill=0;endSize=12;startSize=12;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0.25;entryY=0;entryDx=0;entryDy=0;\" parent=\"1\" source=\"fk1w-hWQ3lKRHGFDh40k-75\" target=\"fk1w-hWQ3lKRHGFDh40k-55\" edge=\"1\">\n <mxGeometry relative=\"1\" as=\"geometry\">\n <mxPoint x=\"-380\" y=\"195\" as=\"sourcePoint\" />\n <mxPoint x=\"-430\" y=\"400\" as=\"targetPoint\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-111\" value=\"CICLE FORMATIU\" style=\"shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;\" parent=\"1\" vertex=\"1\">\n <mxGeometry x=\"-390\" y=\"-255\" width=\"180\" height=\"180\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-112\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-111\" vertex=\"1\">\n <mxGeometry y=\"30\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-113\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-112\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-114\" value=\"id_cicle\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-112\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-115\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-111\" vertex=\"1\">\n <mxGeometry y=\"60\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-116\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-115\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-117\" value=\"nom\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-115\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-118\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-111\" vertex=\"1\">\n <mxGeometry y=\"90\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-119\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-118\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-120\" value=\"nivell\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-118\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-121\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-111\" vertex=\"1\">\n <mxGeometry y=\"120\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-122\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;\" parent=\"fk1w-hWQ3lKRHGFDh40k-121\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-123\" value=\"sigles\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;\" parent=\"fk1w-hWQ3lKRHGFDh40k-121\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-124\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-111\" vertex=\"1\">\n <mxGeometry y=\"150\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-125\" value=\"FK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;\" parent=\"fk1w-hWQ3lKRHGFDh40k-124\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-126\" value=\"id_familia\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;\" parent=\"fk1w-hWQ3lKRHGFDh40k-124\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-131\" value=\"associat\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=ERmany;endFill=0;edgeStyle=orthogonalEdgeStyle;startArrow=ERone;startFill=0;endSize=12;startSize=12;\" parent=\"1\" source=\"fk1w-hWQ3lKRHGFDh40k-111\" target=\"fk1w-hWQ3lKRHGFDh40k-74\" edge=\"1\">\n <mxGeometry relative=\"1\" as=\"geometry\">\n <mxPoint x=\"-380\" y=\"195\" as=\"sourcePoint\" />\n <mxPoint x=\"-430\" y=\"400\" as=\"targetPoint\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-132\" value=\"CICLE_MODUL\" style=\"shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;\" parent=\"1\" vertex=\"1\">\n <mxGeometry x=\"-80\" y=\"-225\" width=\"180\" height=\"120\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-27\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-132\" vertex=\"1\">\n <mxGeometry y=\"30\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-28\" value=\"&lt;b&gt;PK&lt;/b&gt;\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=0;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-27\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-29\" value=\"&lt;u&gt;id_cicle (FK)&lt;/u&gt;\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-27\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-133\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-132\" vertex=\"1\">\n <mxGeometry y=\"60\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-134\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-133\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-135\" value=\"id_modul&amp;nbsp;&lt;u style=&quot;border-color: var(--border-color);&quot;&gt;(FK)&lt;/u&gt;\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-133\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-136\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"fk1w-hWQ3lKRHGFDh40k-132\" vertex=\"1\">\n <mxGeometry y=\"90\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-137\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-136\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"fk1w-hWQ3lKRHGFDh40k-138\" value=\"curs\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"fk1w-hWQ3lKRHGFDh40k-136\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-1\" value=\"MÒDUL PROFESSIONAL\" style=\"shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;\" parent=\"1\" vertex=\"1\">\n <mxGeometry x=\"220\" y=\"-240\" width=\"180\" height=\"240\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-2\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-1\" vertex=\"1\">\n <mxGeometry y=\"30\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-3\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-2\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-4\" value=\"id_modul\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-2\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-5\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-1\" vertex=\"1\">\n <mxGeometry y=\"60\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-6\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-5\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-7\" value=\"nom\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-5\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-8\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-1\" vertex=\"1\">\n <mxGeometry y=\"90\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-9\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-8\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-10\" value=\"sigles\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-8\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-11\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-1\" vertex=\"1\">\n <mxGeometry y=\"120\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-12\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-11\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-13\" value=\"hores\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-11\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-14\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-1\" vertex=\"1\">\n <mxGeometry y=\"150\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-15\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-14\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-16\" value=\"hores_setmanals\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-14\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-17\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-1\" vertex=\"1\">\n <mxGeometry y=\"180\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-18\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-17\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-19\" value=\"ects\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-17\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-20\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-1\" vertex=\"1\">\n <mxGeometry y=\"210\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-21\" value=\"FK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-20\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-22\" value=\"id_especialitat\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-20\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-30\" value=\"\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=ERmany;endFill=0;edgeStyle=orthogonalEdgeStyle;startArrow=ERone;startFill=0;endSize=12;startSize=12;\" parent=\"1\" source=\"fk1w-hWQ3lKRHGFDh40k-111\" target=\"fk1w-hWQ3lKRHGFDh40k-132\" edge=\"1\">\n <mxGeometry relative=\"1\" as=\"geometry\">\n <mxPoint x=\"-290\" y=\"-20\" as=\"sourcePoint\" />\n <mxPoint x=\"-290\" y=\"90\" as=\"targetPoint\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-31\" value=\"\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=ERmany;endFill=0;edgeStyle=orthogonalEdgeStyle;startArrow=ERone;startFill=0;endSize=12;startSize=12;exitX=0;exitY=0.5;exitDx=0;exitDy=0;\" parent=\"1\" source=\"x7KStC2Lg6ZnUdNC_nw6-5\" target=\"fk1w-hWQ3lKRHGFDh40k-132\" edge=\"1\">\n <mxGeometry relative=\"1\" as=\"geometry\">\n <mxPoint x=\"-200\" y=\"-110\" as=\"sourcePoint\" />\n <mxPoint x=\"-70\" y=\"-110\" as=\"targetPoint\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-32\" value=\"FAMILIA PROFESSIONAL\" style=\"shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;\" parent=\"1\" vertex=\"1\">\n <mxGeometry x=\"-690\" y=\"-210\" width=\"180\" height=\"90\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-33\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-32\" vertex=\"1\">\n <mxGeometry y=\"30\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-34\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-33\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-35\" value=\"id_familia\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-33\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-36\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-32\" vertex=\"1\">\n <mxGeometry y=\"60\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-37\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-36\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-38\" value=\"nom\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-36\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-48\" value=\"pertany\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=ERmany;endFill=0;edgeStyle=orthogonalEdgeStyle;startArrow=ERone;startFill=0;endSize=12;startSize=12;\" parent=\"1\" source=\"x7KStC2Lg6ZnUdNC_nw6-32\" target=\"fk1w-hWQ3lKRHGFDh40k-111\" edge=\"1\">\n <mxGeometry relative=\"1\" as=\"geometry\">\n <mxPoint x=\"-200\" y=\"-110\" as=\"sourcePoint\" />\n <mxPoint x=\"-70\" y=\"-110\" as=\"targetPoint\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-49\" value=\"ESPECIALITAT\" style=\"shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;\" parent=\"1\" vertex=\"1\">\n <mxGeometry x=\"220\" y=\"330\" width=\"180\" height=\"150\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-50\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-49\" vertex=\"1\">\n <mxGeometry y=\"30\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-51\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-50\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-52\" value=\"id_especialitat\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-50\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-53\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-49\" vertex=\"1\">\n <mxGeometry y=\"60\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-54\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-53\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-55\" value=\"nom\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-53\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-62\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-49\" vertex=\"1\">\n <mxGeometry y=\"90\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-63\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-62\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-64\" value=\"sigles\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-62\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-58\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-49\" vertex=\"1\">\n <mxGeometry y=\"120\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-59\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-58\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-60\" value=\"cos\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-58\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-65\" value=\"té habilitada\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=ERmany;endFill=0;edgeStyle=orthogonalEdgeStyle;startArrow=ERone;startFill=0;endSize=12;startSize=12;exitX=0;exitY=0.5;exitDx=0;exitDy=0;\" parent=\"1\" source=\"x7KStC2Lg6ZnUdNC_nw6-62\" target=\"fk1w-hWQ3lKRHGFDh40k-55\" edge=\"1\">\n <mxGeometry x=\"0.0017\" relative=\"1\" as=\"geometry\">\n <mxPoint x=\"140\" y=\"310\" as=\"sourcePoint\" />\n <mxPoint x=\"130\" y=\"370\" as=\"targetPoint\" />\n <mxPoint as=\"offset\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-66\" value=\"pot ser impartit\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=ERmany;endFill=0;edgeStyle=orthogonalEdgeStyle;startArrow=ERone;startFill=0;endSize=12;startSize=12;exitX=0.5;exitY=0;exitDx=0;exitDy=0;\" parent=\"1\" source=\"x7KStC2Lg6ZnUdNC_nw6-49\" target=\"x7KStC2Lg6ZnUdNC_nw6-1\" edge=\"1\">\n <mxGeometry relative=\"1\" as=\"geometry\">\n <mxPoint x=\"-115\" y=\"400\" as=\"sourcePoint\" />\n <mxPoint x=\"-30\" y=\"135\" as=\"targetPoint\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-68\" value=\"IMPARTEIX\" style=\"shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;\" parent=\"1\" vertex=\"1\">\n <mxGeometry x=\"-80\" y=\"35\" width=\"180\" height=\"240\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-86\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-68\" vertex=\"1\">\n <mxGeometry y=\"30\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-87\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-86\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-88\" value=\"dni_professor&amp;nbsp;&lt;u style=&quot;border-color: var(--border-color);&quot;&gt;(FK)&lt;/u&gt;\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-86\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-102\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-68\" vertex=\"1\">\n <mxGeometry y=\"60\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-103\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;fontStyle=1\" parent=\"x7KStC2Lg6ZnUdNC_nw6-102\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-104\" value=\"id_modul (FK)\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;fontStyle=5\" parent=\"x7KStC2Lg6ZnUdNC_nw6-102\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-98\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-68\" vertex=\"1\">\n <mxGeometry y=\"90\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-99\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-98\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-100\" value=\"id_cicle&amp;nbsp;&lt;u style=&quot;border-color: var(--border-color);&quot;&gt;(FK)&lt;/u&gt;\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-98\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-94\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-68\" vertex=\"1\">\n <mxGeometry y=\"120\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-95\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-94\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-96\" value=\"curs&amp;nbsp;&lt;u style=&quot;border-color: var(--border-color);&quot;&gt;(FK)&lt;/u&gt;\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-94\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-90\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-68\" vertex=\"1\">\n <mxGeometry y=\"150\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-91\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-90\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-92\" value=\"lletra_grup&amp;nbsp;&lt;u style=&quot;border-color: var(--border-color);&quot;&gt;(FK)&lt;/u&gt;\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-90\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-82\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-68\" vertex=\"1\">\n <mxGeometry y=\"180\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-83\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-82\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-84\" value=\"semipresencial&amp;nbsp;&lt;u style=&quot;border-color: var(--border-color);&quot;&gt;(FK)&lt;/u&gt;\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-82\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-69\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-68\" vertex=\"1\">\n <mxGeometry y=\"210\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-70\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-69\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-71\" value=\"curs_academic\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-69\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-105\" value=\"\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=ERmany;endFill=0;edgeStyle=orthogonalEdgeStyle;startArrow=ERone;startFill=0;endSize=12;startSize=12;exitX=1;exitY=0.5;exitDx=0;exitDy=0;\" parent=\"1\" source=\"fk1w-hWQ3lKRHGFDh40k-106\" target=\"x7KStC2Lg6ZnUdNC_nw6-68\" edge=\"1\">\n <mxGeometry relative=\"1\" as=\"geometry\">\n <mxPoint x=\"-200\" y=\"-155\" as=\"sourcePoint\" />\n <mxPoint x=\"-70\" y=\"-155\" as=\"targetPoint\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-106\" value=\"\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=ERmany;endFill=0;edgeStyle=orthogonalEdgeStyle;startArrow=ERone;startFill=0;endSize=12;startSize=12;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;\" parent=\"1\" source=\"x7KStC2Lg6ZnUdNC_nw6-17\" target=\"x7KStC2Lg6ZnUdNC_nw6-68\" edge=\"1\">\n <mxGeometry relative=\"1\" as=\"geometry\">\n <mxPoint x=\"-200\" y=\"165\" as=\"sourcePoint\" />\n <mxPoint x=\"-70\" y=\"165\" as=\"targetPoint\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-108\" value=\"\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=ERmany;endFill=0;edgeStyle=orthogonalEdgeStyle;startArrow=ERone;startFill=0;endSize=12;startSize=12;exitX=0.75;exitY=0;exitDx=0;exitDy=0;\" parent=\"1\" source=\"fk1w-hWQ3lKRHGFDh40k-55\" target=\"x7KStC2Lg6ZnUdNC_nw6-68\" edge=\"1\">\n <mxGeometry relative=\"1\" as=\"geometry\">\n <mxPoint x=\"-200\" y=\"165\" as=\"sourcePoint\" />\n <mxPoint x=\"-70\" y=\"165\" as=\"targetPoint\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-109\" value=\"CURSA\" style=\"shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;\" parent=\"1\" vertex=\"1\">\n <mxGeometry x=\"440\" y=\"480\" width=\"180\" height=\"150\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-110\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-109\" vertex=\"1\">\n <mxGeometry y=\"30\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-111\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-110\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-112\" value=\"nia&amp;nbsp;&lt;u style=&quot;border-color: var(--border-color);&quot;&gt;(FK)&lt;/u&gt;\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-110\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-113\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-109\" vertex=\"1\">\n <mxGeometry y=\"60\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-114\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;fontStyle=1\" parent=\"x7KStC2Lg6ZnUdNC_nw6-113\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-115\" value=\"id_modul (FK)\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;fontStyle=5\" parent=\"x7KStC2Lg6ZnUdNC_nw6-113\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-128\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-109\" vertex=\"1\">\n <mxGeometry y=\"90\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-129\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-128\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-130\" value=\"curs_academic\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-128\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-132\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-109\" vertex=\"1\">\n <mxGeometry y=\"120\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-133\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-132\" vertex=\"1\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-134\" value=\"nota\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;\" parent=\"x7KStC2Lg6ZnUdNC_nw6-132\" vertex=\"1\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-135\" value=\"\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=ERmany;endFill=0;edgeStyle=orthogonalEdgeStyle;startArrow=ERone;startFill=0;endSize=12;startSize=12;exitX=1;exitY=0.5;exitDx=0;exitDy=0;jumpStyle=arc;jumpSize=18;\" parent=\"1\" source=\"fk1w-hWQ3lKRHGFDh40k-42\" target=\"x7KStC2Lg6ZnUdNC_nw6-109\" edge=\"1\">\n <mxGeometry relative=\"1\" as=\"geometry\">\n <mxPoint x=\"-55\" y=\"400\" as=\"sourcePoint\" />\n <mxPoint x=\"20\" y=\"285\" as=\"targetPoint\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"x7KStC2Lg6ZnUdNC_nw6-136\" value=\"\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=ERmany;endFill=0;edgeStyle=orthogonalEdgeStyle;startArrow=ERone;startFill=0;endSize=12;startSize=12;jumpStyle=arc;jumpSize=18;\" parent=\"1\" source=\"x7KStC2Lg6ZnUdNC_nw6-1\" target=\"x7KStC2Lg6ZnUdNC_nw6-109\" edge=\"1\">\n <mxGeometry relative=\"1\" as=\"geometry\">\n <mxPoint x=\"-340\" y=\"565\" as=\"sourcePoint\" />\n <mxPoint x=\"450\" y=\"565\" as=\"targetPoint\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-5\" value=\"REGISTRE MATERIAL\" style=\"shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;\" vertex=\"1\" parent=\"1\">\n <mxGeometry x=\"-40\" y=\"740\" width=\"180\" height=\"180\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-6\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-5\">\n <mxGeometry y=\"30\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-7\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-6\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-8\" value=\"id_registre\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-6\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-9\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-5\">\n <mxGeometry y=\"60\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-10\" value=\"FK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-9\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-11\" value=\"id_material\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-9\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-12\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-5\">\n <mxGeometry y=\"90\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-13\" value=\"FK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-12\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-14\" value=\"dni_professor\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-12\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-15\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-5\">\n <mxGeometry y=\"120\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-16\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-15\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-17\" value=\"quantitat\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-15\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-18\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-5\">\n <mxGeometry y=\"150\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-19\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-18\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-20\" value=\"timestamp\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-18\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-27\" value=\"\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=ERmany;endFill=0;edgeStyle=orthogonalEdgeStyle;startArrow=ERone;startFill=0;endSize=12;startSize=12;exitX=0.744;exitY=1.033;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;exitPerimeter=0;\" edge=\"1\" parent=\"1\" source=\"fk1w-hWQ3lKRHGFDh40k-59\" target=\"Bb3FIsuME6LueLsiomxI-5\">\n <mxGeometry x=\"0.0017\" relative=\"1\" as=\"geometry\">\n <mxPoint x=\"230\" y=\"445\" as=\"sourcePoint\" />\n <mxPoint x=\"-10\" y=\"445\" as=\"targetPoint\" />\n <mxPoint as=\"offset\" />\n <Array as=\"points\">\n <mxPoint x=\"-66\" y=\"610\" />\n <mxPoint x=\"50\" y=\"610\" />\n </Array>\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-28\" value=\"MATERIAL\" style=\"shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;\" vertex=\"1\" parent=\"1\">\n <mxGeometry x=\"280\" y=\"740\" width=\"180\" height=\"120\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-29\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-28\">\n <mxGeometry y=\"30\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-30\" value=\"PK\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-29\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-31\" value=\"id_material\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-29\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-32\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-28\">\n <mxGeometry y=\"60\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-33\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-32\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-34\" value=\"nom\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-32\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-35\" value=\"\" style=\"shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-28\">\n <mxGeometry y=\"90\" width=\"180\" height=\"30\" as=\"geometry\" />\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-36\" value=\"\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-35\">\n <mxGeometry width=\"30\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"30\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-37\" value=\"quantitat_inventari\" style=\"shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;\" vertex=\"1\" parent=\"Bb3FIsuME6LueLsiomxI-35\">\n <mxGeometry x=\"30\" width=\"150\" height=\"30\" as=\"geometry\">\n <mxRectangle width=\"150\" height=\"30\" as=\"alternateBounds\" />\n </mxGeometry>\n </mxCell>\n <mxCell id=\"Bb3FIsuME6LueLsiomxI-45\" value=\"\" style=\"rounded=0;orthogonalLoop=1;jettySize=auto;html=1;endArrow=ERmany;endFill=0;edgeStyle=orthogonalEdgeStyle;startArrow=ERone;startFill=0;endSize=12;startSize=12;\" edge=\"1\" parent=\"1\" source=\"Bb3FIsuME6LueLsiomxI-28\" target=\"Bb3FIsuME6LueLsiomxI-5\">\n <mxGeometry x=\"0.0017\" relative=\"1\" as=\"geometry\">\n <mxPoint x=\"-56\" y=\"491\" as=\"sourcePoint\" />\n <mxPoint x=\"60\" y=\"750\" as=\"targetPoint\" />\n <mxPoint as=\"offset\" />\n <Array as=\"points\">\n <mxPoint x=\"150\" y=\"800\" />\n <mxPoint x=\"150\" y=\"800\" />\n </Array>\n </mxGeometry>\n </mxCell>\n </root>\n </mxGraphModel>\n </diagram>\n</mxfile>\n\n"}"></div><script type="text/javascript" src="https://viewer.diagrams.net/js/viewer-static.min.js"></script><figcaption>Diagrama Relacional d'un Institut amb un registre de materials</figcaption> ## Exercicis ### Inventari de material - Fitxer: __inventari_material.sql__ Crea els disparadors necessaris per mantindre actualitzat el nombre total d'unitats de material que hi ha a l'institut. Aquest valor s'emmagatzemarà a la taula `inventari_material`, que conté un únic registre amb el nombre total d'unitats de material. ```sql CREATE TABLE inventari_material ( total_unitats INT ); INSERT INTO inventari_material VALUES (0); ``` Cada vegada que es realitze una operació que puga afectar a la quantitat a la taula `material`, s'ha de modificar el valor de la taula `inventari_material`. ??? solution ```sql use institut; drop trigger if exists insert_inventari_material; drop trigger if exists update_inventari_material; drop trigger if exists delete_inventari_material; delimiter // create trigger insert_inventari_material after insert on material for each row begin declare quantitat_insertada int; set quantitat_insertada = new.quantitat_inventari; update inventari_material set total_unitats = total_unitats + quantitat_insertada; end // create trigger update_inventari_material after update on material for each row begin declare diferencia_quantitat int; set diferencia_quantitat = new.quantitat_inventari - old.quantitat_inventari; update inventari_material set total_unitats = total_unitats + diferencia_quantitat; end // create trigger delete_inventari_material after delete on material for each row begin declare quantitat_eliminada int; set quantitat_eliminada = old.quantitat_inventari; update inventari_material set total_unitats = total_unitats - quantitat_eliminada; end // delimiter ; ``` ??? ### Matricula mòdul i cicle formatiu - Fitxer: __matricula_modul_cicle.sql__ Crea un disparador que evite que un estudiant es puga matricular en un mòdul professional que no pertanya al cicle formatiu en el que està inscrit. El missatge d'error ha de ser: ``` El mòdul "<codi>" no pertany al cicle formatiu de l'estudiant "<nia>". ``` ??? solution ```sql drop trigger if exists matricula_modul_cicle; delimiter // create trigger matricula_modul_cicle before insert on cursa for each row begin declare error_message varchar(200); if not exists ( select cm.id_modul from estudiant e inner join cicle_formatiu cf on cf.id_cicle = e.id_cicle inner join cicle_modul cm on cf.id_cicle = cm.id_cicle where e.nia = new.nia and cm.id_modul = new.id_modul ) then set error_message = concat( "El mòdul ", new.id_modul, " no pertany al cicle formatiu de l'estudiant ", new.nia ); SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = error_message; end if; end // delimiter ; ``` ??? ### Màxim hores matriculades - Fitxer: __matricula_max_hores.sql__ Crea un disparador que evite que un estudiant es puga matricular en més de 1000 hores de mòduls en total en un mateix curs acadèmic. El missatge d'error ha de ser: ``` L'estudiant "<nia>" no pot ser matriculat en més de 1000 hores en el curs acadèmic "<curs_academic>". ``` ??? solution ```sql drop trigger if exists matricula_max_hores_insert; drop trigger if exists matricula_max_hores_update; delimiter // create trigger matricula_max_hores_insert before insert on cursa for each row begin declare total_hores_matriculades int; declare hores_nou_modul int; declare error_message varchar(200); -- Calculem les hores matriculades de l'estudiant en el curs acadèmic select sum(mp.hores) into total_hores_matriculades from cursa c inner join modul_professional mp on c.id_modul = mp.id_modul where c.nia = new.nia and c.curs_academic = new.curs_academic; -- Calculem les hores del modul que es desitja matricular-se select mp.hores into hores_nou_modul from modul_professional mp where mp.id_modul = new.id_modul; if (total_hores_matriculades + hores_nou_modul) > 1000 then set error_message = concat( "L'estudiant ", new.nia, " no pot ser matriculat en més de 1000 hores en el curs acadèmic ", new.curs_academic, "." ); SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = error_message; end if; end // create trigger matricula_max_hores_update before update on cursa for each row begin declare total_hores_matriculades int; declare hores_nou_modul int; declare hores_antic_modul int; declare error_message varchar(200); -- Calculem les hores matriculades de l'estudiant en el curs acadèmic select sum(mp.hores) into total_hores_matriculades from cursa c inner join modul_professional mp on c.id_modul = mp.id_modul where c.nia = new.nia and c.curs_academic = new.curs_academic; -- Calculem les hores del modul que es desitja matricular-se select mp.hores into hores_nou_modul from modul_professional mp where mp.id_modul = new.id_modul; -- Sols es resta si no canvia l'estudiant if new.nia == old.nia then -- Calculem les hores del modul que es desitja desmatricular-se select mp.hores into hores_antic_modul from modul_professional mp where mp.id_modul = old.id_modul set total_hores_matriculades = total_hores_matriculades - hores_antic_modul; end if; if (total_hores_matriculades + hores_nou_modul) > 1000 then set error_message = concat( "L'estudiant ", new.nia, " no pot ser matriculat en més de 1000 hores en el curs acadèmic ", new.curs_academic, "." ); SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = error_message; end if; end // delimiter ; ``` ??? ### Mòdul superat - Fitxer: __matricula_modul_superat.sql__ Crea un disparador que evite que un estudiant es puga matricular en un mòdul que ja ha superat anteriorment. El missatge d'error ha de ser: ``` L'estudiant "<nia>" ja ha superat el mòdul "<codi>". ``` ??? solution ```sql drop trigger if exists matricula_modul_superat; delimiter // create trigger matricula_modul_superat before insert on cursa for each row begin declare error_message varchar(200); if exists ( select c.nia, c.id_modul, c.nota from cursa c where e.nia = new.nia and cm.id_modul = new.id_modul and c.nota >= 5 ) then set error_message = concat( "L'estudiant ", new.nia, " ja ha superat el mòdul ", new.id_modul, "." ); SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = error_message; end if; end // delimiter ; ``` ??? ### Màxim d'estudiants per grup - Fitxer: __triggers/max_estudiants_per_grup.sql__ Crea els disparadors necessaris que impedisquen que: - Un grup en modalitat __presencial__ tinga més de 25 estudiants. - Un grup en modalitat __semipresencial__ tinga més de 45 estudiants. ``` El grup "<codi_grup>" no pot tindre més de X estudiants. ``` - `codi_grup` és el codi del grup generat en la funció __[id_grup(id_cicle, curs, semipresencial, lletra)](/itb/DAM-BD/UD7/exercicis/02_functions.html#generar-id-del-grup)__. ### Impartir mòdul de l'especialitat - Fitxer: __triggers/impartir_modul_especialitat.sql__ Crea els disparadors necessaris que impedisquen que: - Si un mòdul té especificada una especialitat, un professor no puga impartir-lo si no pertany a aquesta especialitat. - Si un mòdul no té especificada una especialitat, cap professor pot impartir-lo. ??? solution ```sql use institut; drop trigger if exists impartir_modul_especialitat; delimiter // create trigger impartir_modul_especialitat before insert on imparteix for each row begin declare error_message varchar(200); declare especialitat_modul char(3); declare especialitat_professor char(3); -- Obtem l'especialitat del mòdul select id_especialitat into especialitat_modul from modul_professional where id_modul = new.id_modul; -- Obtem l'especialitat del professor select id_especialitat into especialitat_professor from professor where dni = new.dni_professor; if especialitat_modul is null then set error_message = concat( "El mòdul ", new.id_modul, " no pot ser impartit per cap professor." ); SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = error_message; elseif especialitat_modul != especialitat_professor then set error_message = concat( "El professor ", new.dni_professor, " no pot impartir el mòdul ", new.id_modul, " perquè no pertany a l'especialitat ", especialitat_modul, "." ); SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = error_message; end if; end // delimiter ; ``` ???