@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 activity: <http://example.com/activity/> .
@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@base <http://example.com/base/> .
@prefix d2rq: <http://www.wiwiss.fu-berlin.de/suhl/bizer/D2RQ/0.1#> .

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


  rr:subjectMap [ rr:template "http://example.com/{Sport}" ];

  rr:predicateObjectMap [
    rr:predicate rdf:type ;
    rr:object activity:Sport ;
  ] .

<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}/{Name}" ];
	
  rr:predicateObjectMap [ 
    rr:predicate rdf:type ;
    rr:object foaf:Person ;
  ];
		
  rr:predicateObjectMap [ 
    rr:predicate ex:id ;
    rr:objectMap [ rml:reference "ID"; ]
  ];

  rr:predicateObjectMap [ 
    rr:predicate foaf:name ;
    rr:objectMap [ rml:reference "Name" ]
  ];
 
  rr:predicateObjectMap [ 
    rr:predicate ex:Sport ;
    rr:objectMap <RefObjectMap1>
  ] .

 
<RefObjectMap1>
  a rr:RefObjectMap;
  rr:parentTriplesMap <TriplesMap2> .

<#DB_source> a d2rq:Database;
  d2rq:jdbcDSN "CONNECTIONDSN";
  d2rq:jdbcDriver "org.postgresql.Driver";
  d2rq:username "postgres";
  d2rq:password "" .