<div class="page">
<div class="cover text-center">
<img class="mx-auto" src=/itb/images/logo_mislata.png alt="logo">
# DDL Institut
<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><!--license-->
</div><!--cover-->
</div><!--page-->
{:toc}
## Objectius
L'objectiu d'aquest exemple és mostrar com definir un model relacional en una base de dades relacional
a partir del Diagrama d'Entitat Relació i el Model Relacional.
## Enunciat
Crea la base de dades __institut__ i defineix les taules necessàries
per emmagatzemar correctament la informació.
Totes les sentències per la creacó de la base de dades i les taules han de ser
especificades en un únic fitxer anomenat __create_schema_institut.sql__, que ha
de poder executar-se directament en el SGBD sense cap error.
### Diagrama Entitat Relació
{.center}
### Model Relacional
::: note
La nomenclatura utilitzada és:
```relational
ENTITAT en majúscula i en blau
#clau_primaria en roig, comença per # i subratllat
clau_forana(ENTITAT:#atribut) en cursiva, on s'indica l'entitat a la que es fa referència i l'atribut d'aquesta
:::
```relational
FAMILIA_PROFESSIONAL (
#id_familia,
nom
)
CICLE_FORMATIU (
#id_cicle,
nom,
sigles,
nivell,
id_familia(FAMILIA_PROFESSIONAL:#id_familia)
)
ESPECIALITAT (
id_especialitat,
nom,
sigles,
cos
)
MODUL_PROFESSIONAL (
#id,
nom,
sigles,
hores,
etcs,
id_especialitat(ESPECIALITAT:#id_especialitat)
)
CICLE_MODUL (
#id_cicle(CICLE:#id_cicle),
#id_modul(MODUL:#id),
curs
)
GRUP (
#id_cicle(CICLE:#id_cicle),
#curs,
#lletra,
#semipresencial,
dni_tutor(PROFESSOR:#dni)
)
PERSONA (
#dni,
nom,
cognoms,
telefon,
correu_personal,
correu_coorporatiu,
data_naixement
)
ESTUDIANT (
#nia,
dni(PERSONA:#dni),
id_cicle(GRUP:#id_cicle),
curs(GRUP:#curs),
lletra_grup(GRUP:#lletra),
semipresencial(GRUP:#semipresencial)
)
PROFESSOR (
#dni(PERSONA:#dni),
id_especialitat(ESPECIALITAT:#id_especialitat)
)
IMPARTEIX (
#dni_professor(PROFESSOR:#dni),
#id_modul(MODUL:#id),
#id_cicle(GRUP:#id_cicle),
#curs(GRUP:#curs),
#lletra_grup(GRUP:#lletra),
#semipresencial(GRUP:#semipresencial),
#curs_academic
)
CURSA (
#nia(ESTUDIANT:#nia),
#id_modul(MODUL:#id),
#curs_academic,
nota
)
```
<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=\"2023-12-20T16:04:58.410Z\" agent=\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36\" etag=\"4vuGaP86ZnyHbRpoat_7\" version=\"22.1.11\" type=\"device\">\n <diagram name=\"Pàgina-1\" id=\"5p1RK1gfJNGb53cNKMp1\">\n <mxGraphModel dx=\"3728\" dy=\"2275\" 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;\" parent=\"1\" source=\"fk1w-hWQ3lKRHGFDh40k-51\" target=\"fk1w-hWQ3lKRHGFDh40k-55\" 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 </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 </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</figcaption>
## Definició de la base de dades Institut
```sql
drop database if exists institut;
create database institut;
use institut;
create table familia_professional (
id_familia int primary key auto_increment,
nom varchar(100) not null unique key
);
create table cicle_formatiu (
id_cicle int primary key auto_increment,
id_familia int not null,
nom varchar(100) not null unique key,
sigles varchar(5) not null unique key,
nivell enum('fpb', 'gm', 'gs', 'ce') not null,
foreign key (id_familia) references familia_professional (id_familia)
);
create table especialitat (
id_especialitat char(3) primary key,
nom varchar(100) not null unique key,
sigles varchar(5) not null unique key,
cos varchar(50) not null
);
create table modul_professional (
id_modul varchar(6) primary key,
id_especialitat char(3),
nom varchar(100) not null,
sigles varchar(10) not null,
hores int unsigned not null,
hores_setmanals int unsigned,
ects int unsigned not null,
foreign key (id_especialitat) references especialitat(id_especialitat)
);
create table cicle_modul (
id_cicle int,
id_modul varchar(6),
curs int unsigned not null,
primary key (id_cicle, id_modul),
foreign key (id_cicle) references cicle_formatiu (id_cicle),
foreign key (id_modul) references modul_professional (id_modul)
);
create table persona (
dni varchar(9) primary key,
nom varchar(50) not null,
cognoms varchar(50) not null,
data_naixement date not null,
telefon varchar(20),
correu_personal varchar(50),
correu_corporatiu varchar(50)
);
create table professor (
dni varchar(9) primary key,
id_especialitat char(3) not null,
foreign key (dni) references persona (dni),
foreign key (id_especialitat) references especialitat (id_especialitat)
);
create table grup (
id_cicle int,
curs int unsigned,
lletra char default "",
semipresencial boolean default false,
dni_tutor varchar(9) not null unique,
primary key (id_cicle, curs, lletra, semipresencial),
foreign key (id_cicle) references cicle_formatiu (id_cicle),
foreign key (dni_tutor) references professor (dni)
);
create table estudiant (
nia varchar(8) primary key,
dni varchar(9) not null unique,
id_cicle int,
lletra_grup char default "",
curs int unsigned,
semipresencial boolean default false,
foreign key (dni) references persona (dni),
foreign key (id_cicle) references cicle_formatiu (id_cicle),
foreign key (id_cicle, curs, lletra_grup, semipresencial) references grup (id_cicle, curs, lletra, semipresencial)
on update cascade
);
create table cursa (
nia varchar(8),
id_modul varchar(6),
curs_academic char(5),
nota decimal(4,2) check (nota >= 0 and nota <= 10),
primary key (nia, id_modul, curs_academic),
foreign key (nia) references estudiant (nia),
foreign key (id_modul) references modul_professional (id_modul)
);
create table imparteix (
dni_professor varchar(9),
id_modul varchar(6),
id_cicle int,
curs int unsigned,
lletra_grup char default "",
semipresencial boolean default false,
curs_academic char(5),
primary key (dni_professor, id_modul, id_cicle, curs, lletra_grup, semipresencial, curs_academic),
foreign key (dni_professor) references professor (dni),
foreign key (id_modul) references modul_professional (id_modul),
foreign key (id_cicle, curs, lletra_grup, semipresencial) references grup (id_cicle, curs, lletra, semipresencial)
on update cascade
);
```