<div class="page">
<div class="cover text-center">
<img class="mx-auto" src=/itb/images/logo_mislata.png alt="logo">
# Vistes 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}
## Introducció
- Utilitza la carpeta __institut/views/__.
- El nom de cada fitxer ha de ser l'indicat en l'enunciat.
- Exemple: __/institut/views/view_professor.sql__
## Base de dades Institut
Utilitzant <a href="/itb/DAM-BD/UD4/examples/01_ddl_highschool.html" target="_blank">la base de dades institut</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/data/insert_data_institut.sql" download="insert_data_institut.sql">insert_data_institut.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=\"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>
## Vistes
### Vista de professors
- Fitxer: __view_professor.sql__
Crea una vista que mostre tot la informació dels professors ordenats per DNI.
```sql
SELECT * FROM view_professor;
+-----------+-------------------+-------------+----------------+-----------------+------------------------+------------------------------+
| dni | nom | cognoms | data_naixement | telefon | correu_personal | correu_corporatiu |
+-----------+-------------------+-------------+----------------+-----------------+------------------------+------------------------------+
| 02827316H | Laura | Vázquez | 1999-12-14 | +34 635 684 107 | lvázquez@hotmail.com | l.vázquez@alu.edu.gva.es |
| 03603738Y | Enzo | Quevedo | 1998-04-03 | +34 634 682 284 | equevedo@gmail.com | e.quevedo@alu.edu.gva.es |
| 04687146E | Jana | Torrijos | 2001-10-16 | +34 638 494 244 | jtorrijos@hotmail.com | j.torrijos@alu.edu.gva.es |
| 05652754K | Manuel | Reig | 2003-10-02 | +34 676 127 647 | mreig@hotmail.com | m.reig@alu.edu.gva.es |
| 09818415Z | Albert | Abellán | 1998-10-12 | +34 643 216 557 | aabellán@hotmail.com | a.abellán@alu.edu.gva.es |
| 11071670E | Enzo | Miró | 1995-03-11 | +34 628 410 639 | emiró@gmail.com | e.miró@alu.edu.gva.es |
| 15606014P | Anna | Ballesteros | 2001-08-15 | +34 664 550 233 | aballesteros@gmail.com | a.ballesteros@alu.edu.gva.es |
| 19208116B | Aina | Salcedo | 2000-04-02 | +34 681 519 779 | asalcedo@gmail.com | a.salcedo@alu.edu.gva.es |
| 20347218S | Laura | Barranco | 1999-06-07 | +34 674 343 437 | lbarranco@hotmail.com | l.barranco@alu.edu.gva.es |
| 31279106A | Júlia | Ramis | 2004-10-27 | +34 665 755 174 | jramis@gmail.com | j.ramis@alu.edu.gva.es |
| 33970785S | Dolores | Lerma | 2002-10-10 | +34 671 954 624 | dlerma@hotmail.com | d.lerma@alu.edu.gva.es |
| 38772382V | Antonio | Borrell | 2002-04-10 | +34 69 939 660 | aborrell@yahoo.com | a.borrell@alu.edu.gva.es |
| 43865478Q | Josep | Bautista | 2003-07-10 | +34 622 766 635 | jbautista@hotmail.com | j.bautista@alu.edu.gva.es |
| 52116309B | Valèria | Valle | 1998-07-07 | +34 649 749 806 | vvalle@yahoo.com | v.valle@alu.edu.gva.es |
| 67068658Z | Abril | Gargallo | 2006-04-30 | +34 616 449 269 | agargallo@gmail.com | a.gargallo@alu.edu.gva.es |
| 73265618S | Laia | Posada | 2000-12-29 | +34 617 235 133 | lposada@yahoo.com | l.posada@alu.edu.gva.es |
| 76279685R | Sílvia | Solsona | 1999-08-20 | +34 625 567 828 | ssolsona@gmail.com | s.solsona@alu.edu.gva.es |
| 81415721E | María Del Carmen | Grau | 1998-03-09 | +34 671 988 848 | mdcgrau@hotmail.com | mdc.grau@alu.edu.gva.es |
| 84692292J | Sofía | Arregui | 1999-05-17 | +34 647 307 622 | sarregui@gmail.com | s.arregui@alu.edu.gva.es |
| 96426929G | José | Quiroga | 1999-04-03 | +34 650 957 739 | jquiroga@yahoo.com | j.quiroga@alu.edu.gva.es |
+-----------+-------------------+-------------+----------------+-----------------+------------------------+------------------------------+
```
### Vista de grups
- Fitxer: __view_grup.sql__
Crear una vista que afegisca una la columna `id_grup` a la informació de la taula
`grup`.
L'identificador es genera mitjançant la concatenació de:
- 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.
Els resultats s'ordenen per:
- Sigles del cicle formatiu
- Semipresencialitat del grup
- Curs del grup
- Lletra del grup
```sql
SELECT * FROM view_grup;
+---------+----------+------+--------+----------------+-----------+
| id_grup | id_cicle | curs | lletra | semipresencial | dni_tutor |
+---------+----------+------+--------+----------------+-----------+
| 1ASIX | 2 | 1 | | 0 | 33970785S |
| 2ASIX | 2 | 2 | | 0 | 76279685R |
| 1DAMs | 3 | 1 | | 1 | 09818415Z |
| 2DAMs | 3 | 2 | | 1 | 43865478Q |
| 1DAW | 4 | 1 | | 0 | 05652754K |
| 2DAW | 4 | 2 | | 0 | 02827316H |
| 1SMX-A | 1 | 1 | A | 0 | 52116309B |
| 1SMX-B | 1 | 1 | B | 0 | 15606014P |
| 2SMX | 1 | 2 | | 0 | 03603738Y |
+---------+----------+------+--------+----------------+-----------+
```
### Vista estudiant
- Fitxer: __view_estudiant.sql__
Crea una vista que mostre tot la informació dels estudiants ordenats per DNI.
Afegeix la columna `id_grup` a la informació de la taula `estudiant`
a partir de la vista de grups.
```sql
SELECT * FROM view_estudiant LIMIT 10;
+---------+----------+-----------+-------------------+------------+----------------+-----------------+-------------------------+-----------------------------+----------+------+----------------+-------------+
| id_grup | nia | dni | nom | cognoms | data_naixement | telefon | correu_personal | correu_corporatiu | id_cicle | curs | semipresencial | lletra_grup |
+---------+----------+-----------+-------------------+------------+----------------+-----------------+-------------------------+-----------------------------+----------+------+----------------+-------------+
| 1SMX-B | 10720132 | 92364805W | Isabel | Garay | 2000-01-05 | +34 671 936 168 | igaray@hotmail.com | i.garay@alu.edu.gva.es | 1 | 1 | 0 | B |
| 1ASIX | 10975073 | 99183139D | Antonia | Torrijos | 1999-11-12 | +34 686 133 365 | atorrijos@gmail.com | a.torrijos@alu.edu.gva.es | 2 | 1 | 0 | |
| 1SMX-A | 11001795 | 53185864C | María Teresa | Llanos | 2001-11-01 | +34 635 523 937 | mtllanos@gmail.com | mt.llanos@alu.edu.gva.es | 1 | 1 | 0 | A |
| 1ASIX | 11388513 | 53832705D | María Del Carmen | Campillo | 2002-10-23 | +34 69 752 46 | mdccampillo@gmail.com | mdc.campillo@alu.edu.gva.es | 2 | 1 | 0 | |
| 2ASIX | 11549526 | 62314274Y | Daniel | Rodríguez | 2000-11-18 | +34 678 225 889 | drodríguez@hotmail.com | d.rodríguez@alu.edu.gva.es | 2 | 2 | 0 | |
| 1DAW | 12507685 | 10890313C | Arlet | Ibáñez | 2000-09-21 | +34 698 699 404 | aibáñez@gmail.com | a.ibáñez@alu.edu.gva.es | 4 | 1 | 0 | |
| 2ASIX | 12730786 | 10735917T | Marta | Manjón | 2003-01-02 | +34 610 72 458 | mmanjón@yahoo.com | m.manjón@alu.edu.gva.es | 2 | 2 | 0 | |
| 1SMX-B | 12732202 | 57758956E | Javier | Cerdán | 2000-03-07 | +34 671 319 939 | jcerdán@hotmail.com | j.cerdán@alu.edu.gva.es | 1 | 1 | 0 | B |
| 2ASIX | 13963624 | 67599262P | Noa | Vilalta | 2005-06-09 | +34 688 110 469 | nvilalta@hotmail.com | n.vilalta@alu.edu.gva.es | 2 | 2 | 0 | |
| 1DAW | 14076370 | 46867487L | Álex | Mur | 2004-05-15 | +34 636 969 553 | ámur@gmail.com | á.mur@alu.edu.gva.es | 4 | 1 | 0 | |
+---------+----------+-----------+-------------------+------------+----------------+-----------------+-------------------------+-----------------------------+----------+------+----------------+-------------+
```
### Mostra les vistes creades
- Fitxer: __show_views.sql__
Crea una consulta que mostre les vistes creades en la base de dades `institut`.
### Elimina la vista grup
- Fitxer: __drop_view_grup.sql__
Crea una consulta que elimine la vista `view_grup`.
::: question
- Com pots comprovar que la vista ha segut eliminada?
- Què passa si intentes utilitzar la vista `view_estudiant`?
:::