Exercici: Funcions

<div class="page"> <div class="cover text-center"> <img class="mx-auto" src=/itb/images/logo_mislata.png alt="logo"> # Funcions <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/funcions/__ per guardar els scripts de creació de les funcions. - Anomena els fitxers segons el nom indicat en cada exercici. - Cada script ha de crear la funció indicada, 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 ### Mitjana de les notes d'un estudiant - Fitxer: __nota_mitjana_estudiant.sql__ Crear una funció anomenada __nota_mitjana_estudiant(nia, curs_academic)__ que calcule la mitjana de les notes de l'estudiant amb el NIA especificat en el curs acadèmic especificat. - Si el curs acadèmic és `NULL`, s'ha de calcular la mitjana de les notes de l'estudiant en tots els cursos acadèmics. - Si no hi ha notes per l'estudiant en el curs acadèmic especificat, la funció ha de retornar `NULL`. #### Exemple d'utilització ```sql SELECT mitjana_estudiant(nia, "23/24") AS mitjana_23_24 FROM estudiant; ``` ??? solution ```sql drop function if exists nota_mitjana_estudiant; DELIMITER // CREATE FUNCTION nota_mitjana_estudiant ( nia varchar(8), curs_academic char(5) ) RETURNS DECIMAL(10, 2) NOT DETERMINISTIC READS SQL DATA BEGIN DECLARE nota_mitjana DECIMAL(10, 2); IF curs_academic IS NULL THEN SELECT AVG(c.nota) INTO nota_mitjana from cursa c where c.nia = nia; ELSE SELECT AVG(c.nota) INTO nota_mitjana from cursa c where c.nia = nia and c.curs_academic = curs_academic; END IF; RETURN nota_mitjana; END // DELIMITER ; ``` ??? ### Nota mitjana d'un mòdul - Fitxer: __funcions/nota_mitjana_modul.sql__ Crea una funció anomenada __nota_mitjana_modul(modul_id, curs_academic)__ que retorne la nota mitjana d'un mòdul en un curs acadèmic. - Si no hi ha cap nota per eixe mòdul en el curs acadèmic especificat, la funció ha de retornar `NULL`. - Si curs_academic és `NULL`, la funció ha de retornar la nota mitjana de tots els cursos acadèmics. ??? solution ```sql drop function if exists nota_mitjana_modul; DELIMITER // CREATE FUNCTION nota_mitjana_modul ( id_modul varchar(6), curs_academic char(5) ) RETURNS DECIMAL(10, 2) NOT DETERMINISTIC READS SQL DATA BEGIN DECLARE nota_mitjana DECIMAL(10, 2); -- Si el curs acadèmic és NULL IF curs_academic IS NULL THEN -- Calcula la nota mitjana del mòdul en tots els cursos acadèmics SELECT AVG(c.nota) INTO nota_mitjana from cursa c where c.id_modul = id_modul; ELSE -- Calcula la nota mitjana del mòdul en un curs acadèmic concret SELECT AVG(c.nota) INTO nota_mitjana from cursa c where c.id_modul = id_modul and c.curs_academic = curs_academic; END IF; RETURN nota_mitjana; END // DELIMITER ; ``` ??? ### Generar ID del grup - Fitxer: __id_grup.sql__ Crea una funció anomenada __id_grup(id_cicle, curs, semipresencial, lletra)__ que genere l'identificador del grup especificat. L'identificador del grup ha de tenir el format següent: ``` {CURS}{SIGLES_CICLE}{SEMIPRESENCIAL}-{LLETRA} ``` On: - Curs del grup (1 o 2) - Sigles del cicle formatiu - Semipresencialitat del grup. - Si el grup és semipresencial, s'afegirà la lletra s minúscula. - Si no és semipresencial, no s'afegirà res. - Lletra del grup. - Si el grup té lletra, s'afegirà al final separada per un guió -. - Si no té lletra, no s'afegirà res. #### Exemple d'utilització ```sql select *, id_grup(g.id_cicle, g.curs, g.semipresencial, g.lletra) as id_grup from grup g order by id_grup; ``` ??? solution ```sql DROP FUNCTION IF EXISTS id_grup; DELIMITER // CREATE FUNCTION id_grup ( id_cicle int, curs int, semipresencial boolean, lletra char ) RETURNS varchar(10) NOT DETERMINISTIC READS SQL DATA BEGIN DECLARE sigles varchar(5); DECLARE id_grup varchar(10); SELECT cf.sigles INTO sigles FROM cicle_formatiu cf WHERE cf.id_cicle = id_cicle; SELECT CONCAT( curs, sigles, IF(semipresencial, "s", ""), IF(lletra != "", concat("-", lletra), "") ) INTO id_grup; RETURN id_grup; END // DELIMITER ; ``` ??? ### Estudiant titula - Fitxer: __titula.sql__ Crea una funció anomenada __titula(nia)__ que retorne `TRUE` o `FALSE` segons si l'estudiant amb el NIA especificat pot titular o no. Un estudiant pot titular si ha superat tots els mòduls del cicle formatiu en el que està matriculat. ??? solution ```sql DROP FUNCTION IF EXISTS titula; DELIMITER // CREATE FUNCTION titula ( nia varchar(8) ) RETURNS BOOLEAN NOT DETERMINISTIC READS SQL DATA BEGIN RETURN COALESCE(5 <= all( select c.nota from estudiant e inner join cicle_formatiu cf on e.id_cicle = cf.id_cicle inner join cicle_modul cm on cf.id_cicle = cm.id_cicle left join cursa c on cm.id_modul = c.id_modul and c.nia = e.nia where e.nia = nia ), FALSE); END // DELIMITER ; ``` ???