<div class="page">
<div class="cover text-center">
<img class="mx-auto" src=/itb/images/logo_mislata.png alt="logo">
# Consultes 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 corresponent dins de la carpeta __institut/queries__.
- Exemple: __institut/queries/basic/__
- El nom de cada fitxer ha de ser __query\_#{number}.sql__, on `#{number}` es el número de la consulta amb 2 dígits.
- Exemple: __/institut/queries/basic/query_01.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>
## Consultes amb una única relació
::: warning
Si no s'indica el contrari, els resultats de les consultes
estan ordenats pels atributs de la taula resultat, d'esquerra a dreta.
:::
Utilitza la carpeta __/institut/queries/basic/__
1. Mostra les sigles i el nom dels cicles formatius.
```
+--------+----------------------------------------------------------------+
| sigles | nom |
+--------+----------------------------------------------------------------+
| AC | Activitats Comercials |
| AF | Administració i Finances |
| ASIX | Administració de Sistemes Informàtics en Xarxa |
| AVGE | Agències de Viatges i Gestió d'Esdeveniments |
| CAE | Cures Auxiliars d'Infermeria |
| CETI | Ciberseguretat en Entorns de les Tecnologies de la Informació |
| CI | Comerç Internacional |
| DAM | Desenvolupament d'Aplicacions Multiplataforma |
| DAW | Desenvolupament d'Aplicacions Web |
| GA | Gestió Administrativa |
| GAT | Gestió d'Allotjaments Turístics |
| GIAT | Guia, Informació i Assistències Turístiques |
| IABD | Inteligència Artificial i Big Data |
| LCB | Laboratori Clínic i Biomèdic |
| MP | Màrqueting i Publicitat |
| OPT | Òptica i Protètica Ocular |
| SMX | Sistemes Microinformàtics en Xarxa |
+--------+----------------------------------------------------------------+
```
??? solution
```sql
use institut;
select sigles, nom
from cicle_formatiu
order by sigles;
```
???
2. Obté l'id, el nom i les hores dels mòduls que la id dels quals comence per "03".
```
+----------+-------------------------------------------------------------+-------+
| id_modul | nom | hores |
+----------+-------------------------------------------------------------+-------+
| 0369 | Implantació de Sistemes Operatius en Xarxa | 224 |
| 0370 | Planificació i administració de xarxes | 192 |
| 0371 | Fonaments de maquinari | 96 |
| 0372 | Gestió de Base de Dades | 160 |
| 0373 | Llenguatge de marques i sistemes de gestió d'informació | 96 |
| 0374 | Administració de sistemes operatius | 120 |
| 0375 | Serveis de xarxa i Internet | 120 |
| 0376 | Implantació d'aplicacions web | 100 |
| 0377 | Administració de sistemes gestors de bases de dades | 60 |
| 0378 | Seguretat i alta disponibilitat | 100 |
| 0379 | Projecte d'Administració de Sistemes Informàtics en Xarxa | 40 |
| 0380 | Formació i Orientació Laboral | 96 |
| 0381 | Empresa i Iniciativa Emprenedora | 60 |
| 0382 | Formació en Centres de Treball | 400 |
+----------+-------------------------------------------------------------+-------+
```
??? solution
```sql
use institut;
select id_modul, nom, hores
from modul_professional
where id_modul like "03%";
```
???
3. Obté la id, les sigles, el nom i les hores dels mòduls amb menys de 100 hores.
Ordena'ls per nom, hores i id_modul.
```
+----------+--------+-------------------------------------------------------------+-------+
| id_modul | sigles | nom | hores |
+----------+--------+-------------------------------------------------------------+-------+
| 0377 | SGBD | Administració de sistemes gestors de bases de dades | 60 |
| CV0001 | ATM-I | Anglés Tècnic I-M | 96 |
| CV0003 | ATS-I | Anglés Tècnic I-S | 96 |
| CV0002 | ATM-II | Anglés Tècnic II-M | 40 |
| CV0004 | ATS-II | Anglés Tècnic II-S | 40 |
| 0228 | AW | Aplicacions Web | 88 |
| 0614 | DAW | Desplegament d’Aplicacions Web | 80 |
| 0230 | EIE | Empresa i Iniciativa Emprenedora | 60 |
| 0381 | EIE | Empresa i Iniciativa Emprenedora | 60 |
| 0494 | EIE | Empresa i Iniciativa Emprenedora | 60 |
| 0618 | EIE | Empresa i Iniciativa Emprenedora | 60 |
| 0487 | ED | Entorns de Desenvolupament | 96 |
| 0371 | FHW | Fonaments de maquinari | 96 |
| 0229 | FOL | Formació i Orientació Laboral | 96 |
| 0380 | FOL | Formació i Orientació Laboral | 96 |
| 0493 | FOL | Formació i Orientació Laboral | 96 |
| 0617 | FOL | Formació i Orientació Laboral | 96 |
| 0373 | LLM | Llenguatge de marques i sistemes de gestió d'informació | 96 |
| 0490 | PSP | Programació de Serveis i Processos | 60 |
| 0379 | PRJ | Projecte d'Administració de Sistemes Informàtics en Xarxa | 40 |
| 0492 | PRJ | Projecte de Desenvolupament d'Aplicacions Multiplataforma | 40 |
| 0616 | PRJ | Projecte de Desenvolupament d'Aplicacions Web | 40 |
+----------+--------+-------------------------------------------------------------+-------+
```
??? solution
```sql
use institut;
select id_modul, sigles, nom, hores
from modul_professional
where hores < 100
order by nom, hores, id_modul;
```
???
4. Obté el nombre de persones que hi ha a la base de dades.
```
+-----------------+
| nombre_presones |
+-----------------+
| 254 |
+-----------------+
```
??? solution
```sql
use institut;
select count(dni) nombre_presones
from persona;
```
???
5. Obté el nombre d'estudiants que pertanyen a un grup amb una lletra assignada (_Ex. 1SMX-A_).
```
+-------------------+
| nombre_estudiants |
+-------------------+
| 50 |
+-------------------+
```
??? solution
```sql
use institut;
select count(nia) nombre_estudiants
from estudiant
where lletra_grup != "";
```
???
6. Obté el nombre de professors de l'especialitat 254.
```
+-------------------+
| nombre_professors |
+-------------------+
| 10 |
+-------------------+
```
??? solution
```sql
use institut;
select count(dni) nombre_professors
from professor
where id_especialitat = 254;
```
???
7. Obté el nom, els cognoms i la data de naixement de les persones el cognom de les quals conté una 'o'
i el seu nom acaba en 'e' o té una 'r' en segona posició.
Ordena les persones per data de naixement.
```
+-----------+----------+----------------+
| nom | cognoms | data_naixement |
+-----------+----------+----------------+
| Èric | Losada | 1997-09-25 |
| Jorge | Corral | 1998-12-20 |
| José | Quiroga | 1999-04-03 |
| Arnau | Osorio | 2000-02-28 |
| Bruno | Morillo | 2000-03-07 |
| Jorge | Pons | 2000-05-10 |
| Arlet | Pons | 2000-09-23 |
| José | Palacios | 2001-01-31 |
| Francisca | Marco | 2001-02-23 |
| Jorge | Mariño | 2001-04-30 |
| Èric | Leon | 2001-10-05 |
| José | Sola | 2001-11-14 |
| Bruno | Prado | 2002-10-29 |
| Èric | Torrens | 2003-10-29 |
+-----------+----------+----------------+
```
??? solution
```sql
use institut;
select nom, cognoms, data_naixement
from persona
where lower(cognoms) like "%o%"
and (nom like "%e" or nom like "_r%")
order by data_naixement;
```
???
8. Mostra el dni, l'id del mòdul i la nota dels estudiants cursant un mòdul en el curs
acadèmic "23/24" amb una nota igual o superior a 9 dels mòduls '0223' i '0224'.
Ordena els resultats per la id del mòdul i després per la nota, de major a menor.
```
+----------+----------+-------+
| nia | id_modul | nota |
+----------+----------+-------+
| 51626375 | 0223 | 10.00 |
| 71974128 | 0223 | 10.00 |
| 74607625 | 0223 | 10.00 |
| 97019104 | 0223 | 10.00 |
| 98030593 | 0223 | 10.00 |
| 16611638 | 0223 | 9.00 |
| 23687805 | 0223 | 9.00 |
| 26267634 | 0223 | 9.00 |
| 36549183 | 0223 | 9.00 |
| 75116193 | 0223 | 9.00 |
| 82237117 | 0223 | 9.00 |
| 93477492 | 0223 | 9.00 |
| 98683565 | 0223 | 9.00 |
| 98977554 | 0223 | 9.00 |
| 23164278 | 0224 | 10.00 |
| 31821835 | 0224 | 10.00 |
| 62230816 | 0224 | 10.00 |
| 63351740 | 0224 | 10.00 |
| 24699333 | 0224 | 9.00 |
| 33520299 | 0224 | 9.00 |
| 36214064 | 0224 | 9.00 |
| 77012526 | 0224 | 9.00 |
| 97428687 | 0224 | 9.00 |
+----------+----------+-------+
```
??? solution
```sql
use institut;
select nia, id_modul, nota
from cursa
where curs_academic = "23/24" and nota >= 9 and id_modul in ('0223', '0224')
order by id_modul, nota desc, nia;
```
???
9. Obté el nom, els cognoms i el telèfon de les persones el telefon
el qual acaba en `7X9`. Ordenals per cognoms i nom.
```
+------------+---------+-----------------+
| nom | cognoms | telefon |
+------------+---------+-----------------+
| Montserrat | Jimenez | +34 620 686 799 |
| Manuel | Morales | +34 630 735 709 |
| José | Quiroga | +34 650 957 739 |
| Aina | Salcedo | +34 681 519 779 |
+------------+---------+-----------------+
```
??? solution
```sql
use institut;
select nom, cognoms, telefon
from persona
where telefon like "+34 %7_9"
order by cognoms, nom;
```
???
10. Obté el nom complet (nom i cognoms) de les persones que tenen
18 anys.
::: warning
El resultat d'aquesta consuta pot variar amb el temps.
Aquest resultat ha segut calculat el 16/01/2024.
:::
```
+------------------+----------------+
| nom_complet | data_naixement |
+------------------+----------------+
| Arellano, Sofía | 2005-05-26 |
| Colomer, Martina | 2005-09-16 |
| Cortina, Abril | 2005-07-18 |
| Ordóñez, Biel | 2005-06-22 |
| Tovar, Sara | 2005-11-04 |
| Vilalta, Noa | 2005-06-09 |
+------------------+----------------+
```
??? solution
```sql
use institut;
select concat(cognoms, ", ", nom) nom_complet, data_naixement
from persona
where timestampdiff(year, data_naixement, curdate()) = 18
order by nom_complet;
```
???
## Consultes que utilitzen més d'una relació
Utilitza la carpeta __/institut/queries/join/__
1. Obté el dni, el nom i els cognoms dels professors.
```
+-----------+-------------------+-------------+
| dni | nom | cognoms |
+-----------+-------------------+-------------+
| 02827316H | Laura | Vázquez |
| 03603738Y | Enzo | Quevedo |
| 04687146E | Jana | Torrijos |
| 05652754K | Manuel | Reig |
| 09818415Z | Albert | Abellán |
| 11071670E | Enzo | Miró |
| 15606014P | Anna | Ballesteros |
| 19208116B | Aina | Salcedo |
| 20347218S | Laura | Barranco |
| 31279106A | Júlia | Ramis |
| 33970785S | Dolores | Lerma |
| 38772382V | Antonio | Borrell |
| 43865478Q | Josep | Bautista |
| 52116309B | Valèria | Valle |
| 67068658Z | Abril | Gargallo |
| 73265618S | Laia | Posada |
| 76279685R | Sílvia | Solsona |
| 81415721E | María Del Carmen | Grau |
| 84692292J | Sofía | Arregui |
| 96426929G | José | Quiroga |
+-----------+-------------------+-------------+
```
??? solution
```sql
use institut;
select p.dni, p.nom, p.cognoms
from persona p
inner join professor pr
on p.dni = pr.dni
order by dni;
```
???
2. Obté el dni, el nom i els cognoms dels professors de
l'especialitat amb sigles "INF". Ordena'ls per nom
i cognom.
```
+-----------+---------+----------+
| dni | nom | cognoms |
+-----------+---------+----------+
| 67068658Z | Abril | Gargallo |
| 19208116B | Aina | Salcedo |
| 09818415Z | Albert | Abellán |
| 04687146E | Jana | Torrijos |
| 43865478Q | Josep | Bautista |
| 31279106A | Júlia | Ramis |
| 02827316H | Laura | Vázquez |
| 05652754K | Manuel | Reig |
| 76279685R | Sílvia | Solsona |
| 84692292J | Sofía | Arregui |
+-----------+---------+----------+
```
??? solution
```sql
use institut;
select p.dni, p.nom, p.cognoms
from persona p
inner join professor pr
on p.dni = pr.dni
inner join especialitat e
on pr.id_especialitat = e.id_especialitat
where e.sigles = "INF"
order by nom, cognoms;
```
???
3. Obté les sigles, el nom i el curs on s'imparteix dels mòduls que
es cursen en el cicle amb sigles "DAW".
Ordenals per curs i després alfabèticament.
```
+--------+-----------------------------------------------------------+------+
| sigles | nom | curs |
+--------+-----------------------------------------------------------+------+
| ATS-I | Anglés Tècnic I-S | 1 |
| BD | Bases de Dades | 1 |
| ED | Entorns de Desenvolupament | 1 |
| FOL | Formació i Orientació Laboral | 1 |
| LLM | Llenguatge de marques i sistemes de gestió d'informació | 1 |
| PRG | Programació | 1 |
| SI | Sistemes Informàtics | 1 |
| ATS-II | Anglés Tècnic II-S | 2 |
| DEC | Desenvolupament Web en Entorn Client | 2 |
| DES | Desenvolupament Web en Entorn Servidor | 2 |
| DAW | Desplegament d’Aplicacions Web | 2 |
| DIW | Disseny d'Interfícies Web | 2 |
| EIE | Empresa i Iniciativa Emprenedora | 2 |
| FCT | Formació en Centres de Treball | 2 |
| PRJ | Projecte de Desenvolupament d'Aplicacions Web | 2 |
+--------+-----------------------------------------------------------+------+
```
??? solution
```sql
use institut;
select mp.sigles, mp.nom, cm.curs
from modul_professional mp
inner join cicle_modul cm
on mp.id_modul = cm.id_modul
inner join cicle_formatiu cf
on cm.id_cicle = cf.id_cicle
where cf.sigles = "DAW"
order by curs, mp.nom;
```
???
4. Obté un identificador únic per els grups de l'institut amb el format
`{CURS}{SIGLES_CICLE}{SEMIPRESENCIAL}-{LLETRA}`.
La semipresencialitat s'indica amb una 's' minúscula.
Ordena'ls perquè el resultat concorde amb l'indicat.
```
+---------+
| id_grup |
+---------+
| 1ASIX |
| 2ASIX |
| 1DAMs |
| 2DAMs |
| 1DAW |
| 2DAW |
| 1SMX-A |
| 1SMX-B |
| 2SMX |
+---------+
```
??? solution
```sql
use institut;
select
concat(
g.curs,
cf.sigles,
if(g.semipresencial, "s", ""),
if(g.lletra != "", "-", ""),
g.lletra
) as id_grup
from grup g
inner join cicle_formatiu cf
on g.id_cicle = cf.id_cicle
order by cf.sigles, curs, semipresencial, lletra;
```
???
5. Obté el codi, nom i hores setmanals dels mòduls profesionals que el professor amb DNI '31279106A'
està ha impartit el curs "23/24".
```
+----------+----------------------------------+-----------------+
| id_modul | nom | hores_setmanals |
+----------+----------------------------------+-----------------+
| 0225 | Xarxes Locals | 7 |
| 0484 | Bases de Dades | 5 |
| 0618 | Empresa i Iniciativa Emprenedora | 3 |
+----------+----------------------------------+-----------------+
```
??? solution
```sql
use institut;
select mp.id_modul, mp.nom, mp.hores_setmanals
from imparteix i
inner join modul_professional mp
on i.id_modul = mp.id_modul
where i.dni_professor = '31279106A' and curs_academic = "23/24"
order by mp.id_modul;
```
???
6. Obté el codi, nom i hores setmanals dels mòduls profesionals que s'imparteixen
en el grup '1DAMs'. Indica també el nom i cognoms del professor
que imparteix cada mòdul.
```
+----------+-----------------------------------------------------------+-----------------+---------+----------+
| id_modul | nom | hores_setmanals | nom | cognoms |
+----------+-----------------------------------------------------------+-----------------+---------+----------+
| 0373 | Llenguatge de marques i sistemes de gestió d'informació | 3 | Sofía | Arregui |
| 0483 | Sistemes Informàtics | 5 | Dolores | Lerma |
| 0484 | Bases de Dades | 5 | Aina | Salcedo |
| 0485 | Programació | 8 | Albert | Abellán |
| 0487 | Entorns de Desenvolupament | 3 | Aina | Salcedo |
| 0493 | Formació i Orientació Laboral | 3 | Laura | Barranco |
| CV0003 | Anglés Tècnic I-S | 3 | Enzo | Miró |
+----------+-----------------------------------------------------------+-----------------+---------+----------+
```
??? solution
```sql
use institut;
select mp.id_modul, mp.nom, mp.hores_setmanals, pe.nom, pe.cognoms
from grup g
inner join imparteix i
on i.id_cicle = g.id_cicle
and i.curs = g.curs
and i.lletra_grup = g.lletra
and i.semipresencial = g.semipresencial
inner join cicle_formatiu cf
on g.id_cicle = cf.id_cicle
inner join modul_professional mp
on i.id_modul = mp.id_modul
inner join professor p
on i.dni_professor = p.dni
inner join persona pe
on p.dni = pe.dni
where g.curs = 1
and cf.sigles = "DAM"
and g.lletra = ""
and g.semipresencial = true
order by mp.id_modul;
```
???
7. Obté el nia, nom, cognom i la nota obtinguda
dels estudiants del grup '1DAW' que cursen el
mòdul de 'Programació'. Ordena els resultats per nota, cognom i nom.
```
+----------+---------------+------------+-------+
| nia | nom | cognoms | nota |
+----------+---------------+------------+-------+
| 99769575 | Hugo | Alcántara | 10.00 |
| 18002434 | Miguel | Egea | 10.00 |
| 28283845 | Dolores | Guzman | 10.00 |
| 12507685 | Arlet | Ibáñez | 10.00 |
| 98337501 | Francisca | Marco | 10.00 |
| 14076370 | Álex | Mur | 10.00 |
| 19286411 | Pau | Agustí | 9.00 |
| 14924329 | Ana | Pareja | 9.00 |
| 93340135 | Lucia | Porta | 9.00 |
| 93549324 | José | Sola | 9.00 |
| 18566589 | Joan | Álvarez | 8.00 |
| 38320170 | Ona | Rios | 8.00 |
| 72293901 | Aina | Zapata | 7.00 |
| 82186272 | Rosa | Carranza | 6.00 |
| 40485884 | Dolores | Manrique | 6.00 |
| 76104165 | Antònia | Niño | 6.00 |
| 32331827 | Sara | Villena | 6.00 |
| 17662352 | Isabel | Aguirre | 5.00 |
| 27894173 | María Teresa | Bilbao | 5.00 |
| 22751397 | Sílvia | Cortina | 5.00 |
| 31897885 | Clàudia | Gomis | 5.00 |
| 75782460 | Álex | Sanjuan | 4.00 |
| 34018064 | Biel | Ordóñez | 3.00 |
| 54411276 | Biel | Torrent | 3.00 |
| 29203720 | Manuel | Bárcena | 0.00 |
+----------+---------------+------------+-------+
```
??? solution
```sql
use institut;
select e.nia, p.nom, p.cognoms, c.nota
from estudiant e
inner join persona p
on e.dni = p.dni
inner join grup g
on e.id_cicle = g.id_cicle
and e.curs = g.curs
and e.lletra_grup = g.lletra
and e.semipresencial = g.semipresencial
inner join cicle_formatiu cf
on g.id_cicle = cf.id_cicle
inner join cursa c
on c.nia = e.nia
inner join modul_professional mp
on c.id_modul = mp.id_modul
where g.curs = 1
and cf.sigles = "DAW"
and g.lletra = ""
and g.semipresencial = false
and mp.nom = "Programació"
order by c.nota desc, p.cognoms, p.nom;
```
???
8. Obté la nota mitjana amb dos decimals obtinguda pels estudiants
en els mòduls impartits per la professora 'Aina Salcedo'. Indica
també el nombre total de notes processades per a fer el càlcul.
```
+--------------+--------------+
| nombre_notes | nota_mitjana |
+--------------+--------------+
| 75 | 6.20 |
+--------------+--------------+
```
??? solution
```sql
use institut;
select count(c.nota) nombre_notes, round(avg(c.nota), 2) nota_mitjana
from persona p
inner join professor pr
on p.dni = pr.dni
inner join imparteix i
on i.dni_professor = pr.dni
inner join grup g
on i.id_cicle = g.id_cicle
and i.curs = g.curs
and i.lletra_grup = g.lletra
and i.semipresencial = g.semipresencial
inner join estudiant e
on e.id_cicle = g.id_cicle
and e.curs = g.curs
and e.lletra_grup = g.lletra
and e.semipresencial = g.semipresencial
inner join cursa c
on e.nia = c.nia
and i.id_modul = c.id_modul
where p.nom = "Aina" and p.cognoms = "Salcedo";
```
???
## Consultes amb subconsultes
Utilitza la carpeta __/institut/queries/subqueries/__
1. Obté el nom, els cognoms i la data de naixement
de l'estudiant més major.
```
+---------+-----------+----------------+
| nom | cognoms | data_naixement |
+---------+-----------+----------------+
| Dolores | Calderón | 1995-05-09 |
+---------+-----------+----------------+
```
??? solution
```sql
select p.nom, p.cognoms, p.data_naixement
from persona p
inner join estudiant e
on p.dni = e.dni
where p.data_naixement = (
select min(p.data_naixement)
from persona p
inner join estudiant e
on p.dni = e.dni
);
```
???
2. Obté el NIA, nom i cognoms dels estudiants
que no han superat cap assignatura.
```
+----------+------+---------+
| nia | nom | cognoms |
+----------+------+---------+
| 41921444 | Marc | Cañas |
+----------+------+---------+
```
??? solution
```sql
select e.nia, p.nom, p.cognoms
from persona p
inner join estudiant e
on e.dni = p.dni
where 5 > all (
select c.nota
from cursa c
where c.nia = e.nia
);
```
???
3. Mostra el codi, el nom i les hores
totals del mòdul amb més hores
que no siga "Formació en Centres de Treball".
```
+----------+--------------+-------+
| id_modul | nom | hores |
+----------+--------------+-------+
| 0485 | Programació | 256 |
+----------+--------------+-------+
```
??? solution
```sql
select mp.id_modul, mp.nom, mp.hores
from modul_professional mp
where mp.hores = (
select max(hores)
from modul_professional
where nom != "Formació en Centres de Treball"
);
```
???
4. Obté el NIA, nom i cognoms dels estudiants
que han superat exactament 5 mòduls amb
una nota igual o superior a 9.
```
+----------+------------+----------+
| nia | nom | cognoms |
+----------+------------+----------+
| 93753171 | Abril | Cortina |
| 26267634 | Nil | Aramburu |
| 24699333 | Anna | Vicens |
| 56628159 | Bruno | Morillo |
| 43685640 | Manuel | Múñiz |
| 30476456 | Nil | Salinas |
| 41353026 | Juan | Verdejo |
| 69826104 | Laura | Asenjo |
| 33055389 | Montserrat | Rosales |
+----------+------------+----------+
```
??? solution
```sql
select e.nia, p.nom, p.cognoms
from persona p
inner join estudiant e
on p.dni = e.dni
where 5 = (
select count(c.nota)
from cursa c
where c.nia = e.nia
and c.nota >= 9
);
```
???
5. Obté el codi i el nom dels mòduls professionals
on tots els estudiants que han cursat
han obtingut una nota igual o superior a 3.
```
+----------+-------------------------------------------------------------+
| id_modul | nom |
+----------+-------------------------------------------------------------+
| 0224 | Sistemes Operatius en Xarxa |
| 0230 | Empresa i Iniciativa Emprenedora |
| 0378 | Seguretat i alta disponibilitat |
| 0379 | Projecte d'Administració de Sistemes Informàtics en Xarxa |
| 0382 | Formació en Centres de Treball |
| 0486 | Accés a Dades |
| 0488 | Desenvolupament d'Interfícies |
| 0492 | Projecte de Desenvolupament d'Aplicacions Multiplataforma |
| 0495 | Formació en Centres de Treball |
| 0612 | Desenvolupament Web en Entorn Client |
| 0613 | Desenvolupament Web en Entorn Servidor |
| 0618 | Empresa i Iniciativa Emprenedora |
+----------+-------------------------------------------------------------+
```
??? solution
```sql
select mp.id_modul, mp.nom
from modul_professional mp
where 3 <= all(
select c.nota
from cursa c
where mp.id_modul = c.id_modul
) order by mp.id_modul;
```
???
6. Obté el codi i el nom dels mòduls professionals
on l'estudiant amb NIA '14076370'
ha obtés la seua millor nota.
```
+----------+-----------------------+-------+---------------+
| id_modul | nom | nota | curs_academic |
+----------+-----------------------+-------+---------------+
| 0483 | Sistemes Informàtics | 10.00 | 23/24 |
| 0485 | Programació | 10.00 | 23/24 |
+----------+-----------------------+-------+---------------+
```
??? solution
```sql
select mp.id_modul, mp.nom, c.nota, c.curs_academic
from estudiant e
inner join cursa c
on e.nia = c.nia
inner join modul_professional mp
on c.id_modul = mp.id_modul
where e.nia = '14076370' and c.nota = (
select max(c.nota)
from estudiant e
inner join cursa c
on e.nia = c.nia
where e.nia = '14076370'
) order by mp.id_modul;
```
???
## Consultes amb agrupació
Utilitza la carpeta __/institut/queries/group_by/__
1. Obté el codi, nom dels mòduls on la nota mitjana amb dos decimals del curs acadèmic '23/24' és igual o superior a 7.
Ordena els resultats per nota mitjana i alfabèticament.
```
+----------+------------------------------------------------+--------------+
| id_modul | nom | nota_mitjana |
+----------+------------------------------------------------+--------------+
| 0493 | Formació i Orientació Laboral | 7.36 |
| 0380 | Formació i Orientació Laboral | 7.24 |
| 0486 | Accés a Dades | 7.20 |
| 0612 | Desenvolupament Web en Entorn Client | 7.12 |
| 0378 | Seguretat i alta disponibilitat | 7.12 |
| 0224 | Sistemes Operatius en Xarxa | 7.12 |
| 0489 | Programació multimèdia i dispositius mòbils | 7.04 |
+----------+------------------------------------------------+--------------+
```
??? solution
```sql
select mp.id_modul, mp.nom, round(avg(c.nota), 2) nota_mitjana
from modul_professional mp
inner join cursa c
on c.id_modul = mp.id_modul
where c.curs_academic = "23/24"
group by mp.id_modul
having nota_mitjana >= 7
order by nota_mitjana desc, mp.nom;
```
???
2. Obté la nota mitjana dels grups del curs '23/24'. Ordena els resultats per nota mitjana i alfabèticament.
```
+---------+--------------+
| id_grup | nota_mitjana |
+---------+--------------+
| 2SMX | 6.71 |
| 2ASIX | 6.64 |
| 1ASIX | 6.60 |
| 1DAMs | 6.60 |
| 2DAMs | 6.60 |
| 1DAW | 6.52 |
| 2DAW | 6.52 |
| 1SMX-B | 6.50 |
| 1SMX-A | 6.45 |
+---------+--------------+
```
??? solution
```sql
select
concat(
g.curs,
cf.sigles,
if(g.semipresencial, "s", ""),
if(g.lletra != "", "-", ""),
g.lletra
) as id_grup,
round(avg(c.nota), 2) nota_mitjana
from grup g
inner join cicle_formatiu cf
on g.id_cicle = cf.id_cicle
inner join estudiant e
on g.id_cicle = e.id_cicle
and g.curs = e.curs
and g.lletra = e.lletra_grup
and g.semipresencial = e.semipresencial
inner join cursa c
on e.nia = c.nia
where c.curs_academic = "23/24"
group by g.id_cicle, g.curs, g.semipresencial, g.lletra
order by nota_mitjana desc, id_grup;
```
???
3. Obté el nombre de moduls professionals associats a cada especialitat.
```
+-----------------+---------------------------------------+-----------------------------+
| id_especialitat | nom | nombre_moduls_professionals |
+-----------------+---------------------------------------+-----------------------------+
| 254 | Informàtica | 20 |
| 2B8 | Sistemes i aplicacions informàtiques | 12 |
| 222 | Formació i orientació laboral | 7 |
| 211 | Anglés | 4 |
+-----------------+---------------------------------------+-----------------------------+
```
??? solution
```sql
select es.id_especialitat,
es.nom,
count(mp.id_modul) nombre_moduls_professionals
from especialitat es
inner join modul_professional mp
on mp.id_especialitat = es.id_especialitat
group by es.id_especialitat
order by nombre_moduls_professionals desc;
```
???
4. Obté el nia, nom i cognoms dels estudiants que han suspés més mòduls.
```
+----------+--------+------------+-----------------+
| nia | nom | cognoms | moduls_suspesos |
+----------+--------+------------+-----------------+
| 64345071 | Jorge | Corral | 12 |
| 72613565 | Èric | Torrens | 12 |
| 98266788 | Javier | Villanueva | 12 |
+----------+--------+------------+-----------------+
```
??? solution
```sql
select e.nia, p.nom, p.cognoms, count(c.id_modul) moduls_suspesos
from estudiant e
inner join persona p
on p.dni = e.dni
inner join cursa c
on c.nia = e.nia
where c.nota < 5
group by e.nia
having moduls_suspesos = (
select max(s.moduls_suspesos)
from (
select count(c.id_modul) moduls_suspesos
from estudiant e
inner join cursa c
on c.nia = e.nia
where c.nota < 5
group by e.nia
) s
) order by e.nia;
```
???
5. Obté el nombre d'estudiants que han aprovat
tots els mòduls que han cursat en el curs '23/24'.
```
+---------+-----------------------+
| id_grup | estudiant_tot_aprovat |
+---------+-----------------------+
| 1ASIX | 15 |
| 1DAMs | 15 |
| 1DAW | 15 |
| 1SMX-A | 15 |
| 1SMX-B | 17 |
| 2ASIX | 15 |
| 2DAMs | 15 |
| 2DAW | 15 |
| 2SMX | 15 |
+---------+-----------------------+
```
??? solution
```sql
select
concat(
g.curs,
cf.sigles,
if(g.semipresencial, "s", ""),
if(g.lletra != "", "-", ""),
g.lletra
) as id_grup,
count(e.nia) estudiant_tot_aprovat
from grup g
inner join cicle_formatiu cf
on g.id_cicle = cf.id_cicle
inner join estudiant e
on g.id_cicle = e.id_cicle
and g.curs = e.curs
and g.lletra = e.lletra_grup
and g.semipresencial = e.semipresencial
where 5 <= all (
select c.nota
from cursa c
where c.nia = e.nia
and c.curs_academic = '23/24'
)
group by id_grup
order by id_grup;
```
???
6. Obté la nota mitjana dels estudiants que han cursat més assignatures.
Mostra aquells que tenen una mitjana superior a 8.
```
+----------+--------+------------+--------------+
| nia | nom | cognoms | nota_mitjana |
+----------+--------+------------+--------------+
| 95838816 | Júlia | Calleja | 9.500000 |
| 13963624 | Noa | Vilalta | 9.187500 |
| 51176958 | Èric | Losada | 9.000000 |
| 88601876 | Carla | Pereira | 8.937500 |
| 76739576 | Josep | Peinado | 8.937500 |
| 30268657 | Abril | Francisco | 8.812500 |
| 72313554 | Enzo | Gelabert | 8.812500 |
| 15920428 | Max | Sacristán | 8.812500 |
| 89302040 | Albert | Aguirre | 8.750000 |
| 48633790 | María | Gutierrez | 8.687500 |
+----------+--------+------------+--------------+
```
??? solution
```sql
select e.nia, p.nom, p.cognoms, avg(c.nota) nota_mitjana
from estudiant e
inner join persona p
on e.dni = p.dni
inner join cursa c
on c.nia = e.nia
group by e.nia
having count(id_modul) = (
select max(n.nombre_moduls)
from (
select count(c.id_modul) as nombre_moduls
from estudiant e
inner join persona p
on e.dni = p.dni
inner join cursa c
on c.nia = e.nia
group by e.nia
) n
) and nota_mitjana > 8
order by nota_mitjana desc, p.nom, p.cognoms;
```
???
7. Obté el nombre de professors de cada especialitat necessaris per impartir els mòduls
professionals associats a cada grup.
El nombre de professors es calcula dividint la suma d'hores setmanals totals de cada
especialitat entre 18.
```
+-----------------+---------------------------------------+-------------------+
| id_especialitat | nom | nombre_professors |
+-----------------+---------------------------------------+-------------------+
| 254 | Informàtica | 8 |
| 2B8 | Sistemes i aplicacions informàtiques | 6 |
| 222 | Formació i orientació laboral | 2 |
| 211 | Anglés | 2 |
+-----------------+---------------------------------------+-------------------+
```
??? solution
```sql
select es.id_especialitat, es.nom,
ceil(sum(mp.hores_setmanals) / 18) as nombre_professors
from grup g
inner join cicle_formatiu cf
on g.id_cicle = cf.id_cicle
inner join cicle_modul cm
on cf.id_cicle = cm.id_cicle and g.curs = cm.curs
inner join modul_professional mp
on cm.id_modul = mp.id_modul
inner join especialitat es
on mp.id_especialitat = es.id_especialitat
where mp.id_especialitat is not null
group by mp.id_especialitat
order by nombre_professors desc;
```
???