@prefix rr: <http://www.w3.org/ns/r2rml#> .
@prefix foaf: <http://xmlns.com/foaf/0.1/> .
@prefix ex: <http://example.com/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix rml: <http://semweb.mmlab.be/ns/rml#> .
@prefix ql: <http://semweb.mmlab.be/ns/ql#> .
@prefix d2rq: <http://www.wiwiss.fu-berlin.de/suhl/bizer/D2RQ/0.1#> .
@base <http://example.com/base/> .

<TriplesMap1>
  a rr:TriplesMap;
    
  rml:logicalSource [
    rml:source <#DB_source>;
    rr:sqlVersion rr:SQL2008;
    rr:tableName "student";
  ];

  rr:subjectMap [ 
    rr:template "http://example.com/student/{ID}";
  ]; 
	
  rr:predicateObjectMap [ 
    rr:predicate ex:firstName; 
    rr:objectMap [
      rml:reference "FirstName"
    ]
  ]; 
	
  rr:predicateObjectMap [ 
    rr:predicate ex:lastName; 
    rr:objectMap [
      rml:reference "LastName"
    ]
  ].

<TriplesMap2>
  a rr:TriplesMap;
    
  rml:logicalSource [
    rml:source <#DB_source>;
    rr:sqlVersion rr:SQL2008;
    rr:tableName "sport";
  ];

  rr:subjectMap [ 
    rr:template "http://example.com/sport/{ID}";
  ]; 
	
  rr:predicateObjectMap [ 
    rr:predicate ex:id; 
    rr:objectMap [
      rml:reference "ID"
    ]
  ]; 
	
  rr:predicateObjectMap [ 
    rr:predicate ex:description; 
    rr:objectMap [
      rml:reference "Description"
    ]
  ].

<LinkMap_1_2>
  a rr:TriplesMap;
    
  rml:logicalSource [
    rml:source <#DB_source>;
    rr:sqlVersion rr:SQL2008;
    rr:tableName "student_sport";
  ];

  rr:subjectMap [ 
    rr:template "http://example.com/student/{ID_Student}";
  ]; 
	
  rr:predicateObjectMap [ 
    rr:predicate ex:plays; 
    rr:objectMap [
      rr:template "http://example.com/sport/{ID_Sport}"
    ]
  ].									

<#DB_source> a d2rq:Database;
  d2rq:jdbcDSN "CONNECTIONDSN"; # the "jbdc:mysql:// part is ignored
  d2rq:jdbcDriver "com.mysql.cj.jdbc.Driver"; # this is ignored
  d2rq:username "root";
  d2rq:password "" .