Renaming the database folders
authorBoris Villazon-Terrazas <bvillazon@fi.upm.es>
Wed, 13 Jul 2011 15:39:53 +0100
changeset 8 d41413847f4e
parent 7 95cd857c4810
child 9 8c8d201b55a1
Renaming the database folders
1table0rows/create.sql
1table0rows/directGraph.ttl
1table0rows/mapped.trig
1table0rows/r2rml.ttl
1table1compositeprimarykey3columns1row/create.sql
1table1compositeprimarykey3columns1row/directGraph.ttl
1table1primarykey1column1row/create.sql
1table1primarykey1column1row/directGraph.ttl
1table1row/create.sql
1table1row/directGraph.ttl
1table1row/mappeda.trig
1table1row/mappedb.trig
1table1row/r2rmla.ttl
1table1row/r2rmlb.ttl
1table2columns1row/create.sql
1table2columns1row/directGraph.ttl
1table2columns1row/mappeda.trig
1table2columns1row/mappedb.trig
1table2columns1row/r2rmla.ttl
1table2columns1row/r2rmlb.ttl
1table2columnsprojection/create.sql
1table2columnsprojection/directGraph.ttl
1table3columns1row/create.sql
1table3columns1row/directGraph.ttl
1table3columns1row/mappeda.trig
1table3columns1row/mappedb.trig
1table3columns1row/mappedc.trig
1table3columns1row/mappedd.trig
1table3columns1row/r2rmla.ttl
1table3columns1row/r2rmlb.ttl
1table3columns1row/r2rmlc.ttl
1table3columns1row/r2rmld.ttl
2duplicates0nulls/create.sql
2duplicates0nulls/directGraph.ttl
2tables1primarykey1foreingkey/create.sql
2tables1primarykey1foreingkey/directGraph.ttl
D000-1table0rows/create.sql
D000-1table0rows/directGraph.ttl
D000-1table0rows/mapped.trig
D000-1table0rows/r2rml.ttl
D001-1table1row/create.sql
D001-1table1row/directGraph.ttl
D001-1table1row/mappeda.trig
D001-1table1row/mappedb.trig
D001-1table1row/r2rmla.ttl
D001-1table1row/r2rmlb.ttl
D002-1table2columns1row/create.sql
D002-1table2columns1row/directGraph.ttl
D002-1table2columns1row/mappeda.trig
D002-1table2columns1row/mappedb.trig
D002-1table2columns1row/r2rmla.ttl
D002-1table2columns1row/r2rmlb.ttl
D003-1table3columns1row/create.sql
D003-1table3columns1row/directGraph.ttl
D003-1table3columns1row/mappeda.trig
D003-1table3columns1row/mappedb.trig
D003-1table3columns1row/mappedc.trig
D003-1table3columns1row/mappedd.trig
D003-1table3columns1row/r2rmla.ttl
D003-1table3columns1row/r2rmlb.ttl
D003-1table3columns1row/r2rmlc.ttl
D003-1table3columns1row/r2rmld.ttl
D004-1table2columnsprojection/create.sql
D004-1table2columnsprojection/directGraph.ttl
D005-2duplicates0nulls/create.sql
D005-2duplicates0nulls/directGraph.ttl
D009-2tables1primarykey1foreingkey/create.sql
D009-2tables1primarykey1foreingkey/directGraph.ttl
--- a/1table0rows/create.sql	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-CREATE TABLE Student (
-       Name varchar(50)
-);
--- a/1table0rows/directGraph.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,1 +0,0 @@
-# empty graph
--- a/1table0rows/mapped.trig	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,1 +0,0 @@
-# empty database
--- a/1table0rows/r2rml.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,20 +0,0 @@
-@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#> .
-@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
-
-<TriplesMap1>
-    a rr:TriplesMapClass;
-        
-    rr:tableOwner "boricles";
-    rr:tableName "Student";
-
-    rr:subjectMap [ rr:template "http://example.com/{Name}" ]; 
-	
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:predicate foaf:name ]; 
-      rr:objectMap    [ rr:column "Name" ]
-    ]
-    .
\ No newline at end of file
--- a/1table1compositeprimarykey3columns1row/create.sql	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,7 +0,0 @@
-CREATE TABLE Student (
-ID integer,
-Name varchar(50),
-Sport varchar (50),
-PRIMARY KEY (ID,Name)
-);
-INSERT INTO Student (ID, Name,Sport) VALUES(10,"Venus Williams","Tennis");
--- a/1table1compositeprimarykey3columns1row/directGraph.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,5 +0,0 @@
-<Student/ID.10_Name.Venus+Williams#_> <Student#ID> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<Student/ID.10_Name.Venus+Williams#_> <Student#Name> "Venus Williams" .
-<Student/ID.10_Name.Venus+Williams#_> <Student#Sport> "Tennis" .
-<Student/ID.10_Name.Venus+Williams#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
-
--- a/1table1primarykey1column1row/create.sql	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-CREATE TABLE Student (
-Name varchar(50) PRIMARY KEY
-);
-INSERT INTO Student (Name) VALUES ("Venus");
--- a/1table1primarykey1column1row/directGraph.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-<Student/Name.Venus#_> <Student#Name> "Venus" .
-<Student/Name.Venus#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
-
--- a/1table1row/create.sql	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-CREATE TABLE Student (
-Name varchar(50)
-);
-INSERT INTO Student (Name) VALUES ("Venus");
--- a/1table1row/directGraph.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,2 +0,0 @@
-_:a <Student#Name> "Venus".
-_:a a <Student> .
--- a/1table1row/mappeda.trig	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-@prefix foaf: <http://xmlns.com/foaf/0.1/> .
-@prefix ex: <http://example.com/> .
-
-ex:Venus foaf:name "Venus".
--- a/1table1row/mappedb.trig	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-@prefix foaf: <http://xmlns.com/foaf/0.1/> .
-@prefix ex: <http://example.com/> .
-
-_:Venus foaf:name "Venus".
--- a/1table1row/r2rmla.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,20 +0,0 @@
-@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#> .
-@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
-
-<TriplesMap1>
-    a rr:TriplesMapClass;
-    
-    rr:tableOwner "boricles";
-    rr:tableName "Student";
-
-    rr:subjectMap [ rr:template "http://example.com/{Name}" ]; 
-	
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:predicate foaf:name ]; 
-      rr:objectMap    [ rr:column "Name" ]
-    ]
-    .
\ No newline at end of file
--- a/1table1row/r2rmlb.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,20 +0,0 @@
-@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#> .
-@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
-
-<TriplesMap1>
-    a rr:TriplesMapClass;
-    
-    rr:tableOwner "boricles";
-    rr:tableName "Student";
-
-    rr:subjectMap [ rr:column "Name"; rr:termtype "BlankNode" ]; 
-	
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:predicate foaf:name ]; 
-      rr:objectMap    [ rr:column "Name" ]
-    ]
-    .
\ No newline at end of file
--- a/1table2columns1row/create.sql	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,5 +0,0 @@
-CREATE TABLE Student (
-ID integer,
-Name varchar(50)
-);
-INSERT INTO Student (ID, Name) VALUES(10,"Venus");
--- a/1table2columns1row/directGraph.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-_:a a <Student> .
-_:a <Student#id> 10 .
-_:a <Student#name> "Venus" .
--- a/1table2columns1row/mappeda.trig	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,8 +0,0 @@
-@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
-@prefix foaf: <http://xmlns.com/foaf/0.1/> .
-@prefix ex: <http://example.com/> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-
-ex:10Venus rdf:type foaf:Person;
-           ex:id "10"^^xsd:integer;
-           foaf:name "Venus".
\ No newline at end of file
--- a/1table2columns1row/mappedb.trig	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,8 +0,0 @@
-@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
-@prefix foaf: <http://xmlns.com/foaf/0.1/> .
-@prefix ex: <http://example.com/> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-
-_:Student10 rdf:type foaf:Person;
-            ex:id "10"^^xsd:integer;
-            foaf:name "Venus". 
\ No newline at end of file
--- a/1table2columns1row/r2rmla.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,27 +0,0 @@
-@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#> .
-@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
-
-<TriplesMap1>
-    a rr:TriplesMapClass;
-    
-    rr:tableOwner "boricles";
-    rr:tableName "Student";
-
-    rr:subjectMap [ rr:template "http://example.com/{ID}{Name}";
-                    rr:class foaf:Person ];
-
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:predicate ex:id ]; 
-      rr:objectMap    [ rr:column "ID"; rr:datatype xsd:integer ]
-    ];
-
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:predicate foaf:name ]; 
-      rr:objectMap    [ rr:column "Name" ]
-	]
-    .
--- a/1table2columns1row/r2rmlb.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,30 +0,0 @@
-@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#> .
-@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
-
-<TriplesMap1>
-     a rr:TriplesMapClass;
-    
-    rr:SQLQuery """
-       Select ('Student' || ID ) AS "StudentId"
-            , ID
-            , Name
-         from Student
-       """;
-
-    rr:subjectMap [ rr:column "StudentId"; rr:termtype "BlankNode"; rr:class foaf:Person ];
-
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:predicate ex:id ]; 
-      rr:objectMap    [ rr:column "ID"; rr:datatype xsd:integer ]
-    ];
-
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:predicate foaf:name ]; 
-      rr:objectMap    [ rr:column "Name" ]
-    ]
-    .
\ No newline at end of file
--- a/1table2columnsprojection/create.sql	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,5 +0,0 @@
-CREATE TABLE Student_Sport(
-      Student varchar(50),
-      Sport varchar(50)
-);
-INSERT INTO Student_Sport (Student,Sport) VALUES ("Venus", "Tennis");
--- a/1table2columnsprojection/directGraph.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-_:a a <Student_Sport> .
-_:a <Student_Sport#Student> "Venus" .
-_:a <Student_Sport#Sport> "Tennis" .
--- a/1table3columns1row/create.sql	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,6 +0,0 @@
-CREATE TABLE Student (
-ID integer,
-FirstName varchar(50),
-LastName varchar(50)
-);
-INSERT INTO Student (ID, FirstName, LastName) VALUES (10,"Venus", "Williams");
--- a/1table3columns1row/directGraph.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-_:a a <Student> .
-_:a <Student#ID> 10 .
-_:a <Student#FirstName> "Venus" .
-_:a <Student#LastName> "Williams" .
--- a/1table3columns1row/mappeda.trig	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,9 +0,0 @@
-@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
-@prefix foaf: <http://xmlns.com/foaf/0.1/> .
-@prefix ex: <http://example.com/> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-
-ex:Student10VenusWilliams rdf:type foaf:Person
-                          ex:id "10"^^xsd:integer;
-                          foaf:firstName "Venus";
-                          foaf:lastName "Williams".
\ No newline at end of file
--- a/1table3columns1row/mappedb.trig	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,8 +0,0 @@
-@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
-@prefix foaf: <http://xmlns.com/foaf/0.1/> .
-@prefix ex: <http://example.com/> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-
-ex:Student10VenusWilliams rdf:type foaf:Person
-                          ex:id "10"^^xsd:integer;
-                          foaf:name "Venus Williams". 
\ No newline at end of file
--- a/1table3columns1row/mappedc.trig	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,9 +0,0 @@
-@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
-@prefix foaf: <http://xmlns.com/foaf/0.1/> .
-@prefix ex: <http://example.com/> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-
-_:Student10VenusWilliams rdf:type foaf:Person
-                         ex:id "10"^^xsd:integer;
-                         foaf:firstName "Venus";
-                         foaf:lastName "Williams". 
\ No newline at end of file
--- a/1table3columns1row/mappedd.trig	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,8 +0,0 @@
-@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
-@prefix foaf: <http://xmlns.com/foaf/0.1/> .
-@prefix ex: <http://example.com/> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-
-_:Student10VenusWilliams rdf:type foaf:Person
-                         ex:id "10"^^xsd:integer;
-                         foaf:name "Venus Williams". 
\ No newline at end of file
--- a/1table3columns1row/r2rmla.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,33 +0,0 @@
-@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#> .
-@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
-
-<TriplesMap1>
-     a rr:TriplesMapClass;
-
-    rr:tableOwner "boricles";
-    rr:tableName "Student";
-
-    rr:subjectMap [ rr:template "http://example.com/Student{ID}{FirstName}{LastName}";
-                    rr:class foaf:Person  ];
-	
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:predicate ex:id ]; 
-      rr:objectMap    [ rr:column "ID"; rr:datatype xsd:integer ]
-    ];
-
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:predicate foaf:firstName ]; 
-      rr:objectMap    [ rr:column "FirstName" ]
-    ];
-
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:predicate foaf:lastName ]; 
-      rr:objectMap    [ rr:column "LastName" ]
-    ]
-    .
\ No newline at end of file
--- a/1table3columns1row/r2rmlb.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,32 +0,0 @@
-@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#> .
-@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
-
-<TriplesMap1>
-     a rr:TriplesMapClass;
-
-      rr:SQLQuery """
-      SELECT ID,
-             (FirstName || ' ' || LastName) AS Name,
-             FirstName,
-             LastName
-      FROM Student
-      """;
-
-    rr:subjectMap [ rr:template "http://example.com/Student{ID}{FirstName}{LastName}"; 
-                    rr:class foaf:Person ];
-	
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:predicate ex:id ]; 
-      rr:objectMap    [ rr:column "ID"; rr:datatype xsd:integer ]
-    ];
-
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:predicate foaf:name ]; 
-      rr:objectMap    [ rr:column "Name" ]
-    ]
-    .
\ No newline at end of file
--- a/1table3columns1row/r2rmlc.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,38 +0,0 @@
-@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#> .
-@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
-
-<TriplesMap1>
-     a rr:TriplesMapClass;
-
-      rr:SQLQuery """
-      SELECT ('Student' || ID || FirstName || LastName) as StudentID,
-             ID,
-             FirstName,
-             LastName
-      FROM Student
-      """;
-
-    rr:subjectMap [ rr:column "StudentID"; rr:termtype "BlankNode";
-                    rr:class foaf:Person  ];
-	
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:predicate ex:id ]; 
-      rr:objectMap    [ rr:column "ID"; rr:datatype xsd:integer ]
-    ];
-
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:predicate foaf:firstName ]; 
-      rr:objectMap    [ rr:column "FirstName" ]
-    ];
-
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:predicate foaf:lastName ]; 
-      rr:objectMap    [ rr:column "LastName" ]
-    ]
-    .
\ No newline at end of file
--- a/1table3columns1row/r2rmld.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,31 +0,0 @@
-@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#> .
-@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
-
-<TriplesMap1>
-     a rr:TriplesMapClass;
-
-      rr:SQLQuery """
-      SELECT ('Student' || ID || FirstName || LastName) as StudentID,
-             ID,
-             (FirstName || ' ' || LastName) AS Name
-      FROM Student
-      """;
-
-    rr:subjectMap [ rr:column "StudentID"; rr:termtype "BlankNode";
-                    rr:class foaf:Person  ];
-	
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:predicate ex:id ]; 
-      rr:objectMap    [ rr:column "ID"; rr:datatype xsd:integer ]
-    ];
-
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:predicate foaf:name ]; 
-      rr:objectMap    [ rr:column "Name" ]
-    ]
-    .
\ No newline at end of file
--- a/2duplicates0nulls/create.sql	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,7 +0,0 @@
-CREATE TABLE IOUs (
-      fname CHAR(20),
-      lname CHAR(20),
-      amount FLOAT);
-INSERT INTO IOUs (fname, lname, amount) VALUES ("Bob", "Smith", 30);
-INSERT INTO IOUs (fname, lname, amount) VALUES ("Sue", "Jones", 20);
-INSERT INTO IOUs (fname, lname, amount) VALUES ("Bob", "Smith", 30);
--- a/2duplicates0nulls/directGraph.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,17 +0,0 @@
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-  
-  _:a a <IOUs> .
-  _:a <IOUs#fname> "Bob" .
-  _:a <IOUs#lname> "Smith" .
-  _:a <IOUs#amount> "30"^^xsd:float .
-  
-  _:b a <IOUs> .
-  _:b <IOUs#fname> "Sue" .
-  _:b <IOUs#lname> "Jones" .
-  _:b <IOUs#amount> "20"^^xsd:float .
-  
-  _:c a <IOUs> .
-  _:c <IOUs#fname> "Bob" .
-  _:c <IOUs#lname> "Smith" .
-  _:c <IOUs#amount> "30"^^xsd:float .
-
--- a/2tables1primarykey1foreingkey/create.sql	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,17 +0,0 @@
-CREATE TABLE Student (
-ID integer,
-Name varchar(50),
-Sport integer,
-PRIMARY KEY (ID),
-FOREIGN KEY(Sport) REFERENCES Sport(ID)
-);
-
-CREATE TABLE Sport (
-ID integer,
-Name varchar (50),
-PRIMARY KEY (ID)
-);
-
-INSERT INTO Student (ID, Name, Sport) VALUES (10,"Venus Williams", 100);
-INSERT INTO Student (ID, Name, Sport) VALUES (20,"Demi Moore", NULL);
-INSERT INTO Sport (ID, Name) VALUES (100,"Tennis");
--- a/2tables1primarykey1foreingkey/directGraph.ttl	Sun Mar 13 12:13:44 2011 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,13 +0,0 @@
-<Student/ID.20#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
-<Student/ID.20#_> <Student#ID> "20"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<Student/ID.20#_> <Student#Name> "Demi Moore" .
-
-<Student/ID.10#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
-<Student/ID.10#_> <Student#ID> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<Student/ID.10#_> <Student#Name> "Venus Williams" .
-<Student/ID.10#_> <Student#Sport> <Sport/ID.100#_> .
-
-<Sport/ID.100#_> <Sport#ID> "100"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<Sport/ID.100#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Sport> .
-<Sport/ID.100#_> <Sport#Name> "Tennis" .
-
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D000-1table0rows/create.sql	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,3 @@
+CREATE TABLE Student (
+       Name varchar(50)
+);
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D000-1table0rows/directGraph.ttl	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,1 @@
+# empty graph
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D000-1table0rows/mapped.trig	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,1 @@
+# empty database
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D000-1table0rows/r2rml.ttl	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,20 @@
+@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#> .
+@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
+
+<TriplesMap1>
+    a rr:TriplesMapClass;
+        
+    rr:tableOwner "boricles";
+    rr:tableName "Student";
+
+    rr:subjectMap [ rr:template "http://example.com/{Name}" ]; 
+	
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:name ]; 
+      rr:objectMap    [ rr:column "Name" ]
+    ]
+    .
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D001-1table1row/create.sql	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,4 @@
+CREATE TABLE Student (
+Name varchar(50)
+);
+INSERT INTO Student (Name) VALUES ("Venus");
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D001-1table1row/directGraph.ttl	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,2 @@
+_:a <Student#Name> "Venus".
+_:a a <Student> .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D001-1table1row/mappeda.trig	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,4 @@
+@prefix foaf: <http://xmlns.com/foaf/0.1/> .
+@prefix ex: <http://example.com/> .
+
+ex:Venus foaf:name "Venus".
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D001-1table1row/mappedb.trig	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,4 @@
+@prefix foaf: <http://xmlns.com/foaf/0.1/> .
+@prefix ex: <http://example.com/> .
+
+_:Venus foaf:name "Venus".
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D001-1table1row/r2rmla.ttl	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,20 @@
+@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#> .
+@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
+
+<TriplesMap1>
+    a rr:TriplesMapClass;
+    
+    rr:tableOwner "boricles";
+    rr:tableName "Student";
+
+    rr:subjectMap [ rr:template "http://example.com/{Name}" ]; 
+	
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:name ]; 
+      rr:objectMap    [ rr:column "Name" ]
+    ]
+    .
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D001-1table1row/r2rmlb.ttl	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,20 @@
+@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#> .
+@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
+
+<TriplesMap1>
+    a rr:TriplesMapClass;
+    
+    rr:tableOwner "boricles";
+    rr:tableName "Student";
+
+    rr:subjectMap [ rr:column "Name"; rr:termtype "BlankNode" ]; 
+	
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:name ]; 
+      rr:objectMap    [ rr:column "Name" ]
+    ]
+    .
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D002-1table2columns1row/create.sql	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,5 @@
+CREATE TABLE Student (
+ID integer,
+Name varchar(50)
+);
+INSERT INTO Student (ID, Name) VALUES(10,"Venus");
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D002-1table2columns1row/directGraph.ttl	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,3 @@
+_:a a <Student> .
+_:a <Student#id> 10 .
+_:a <Student#name> "Venus" .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D002-1table2columns1row/mappeda.trig	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,8 @@
+@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
+@prefix foaf: <http://xmlns.com/foaf/0.1/> .
+@prefix ex: <http://example.com/> .
+@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
+
+ex:10Venus rdf:type foaf:Person;
+           ex:id "10"^^xsd:integer;
+           foaf:name "Venus".
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D002-1table2columns1row/mappedb.trig	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,8 @@
+@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
+@prefix foaf: <http://xmlns.com/foaf/0.1/> .
+@prefix ex: <http://example.com/> .
+@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
+
+_:Student10 rdf:type foaf:Person;
+            ex:id "10"^^xsd:integer;
+            foaf:name "Venus". 
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D002-1table2columns1row/r2rmla.ttl	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,27 @@
+@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#> .
+@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
+
+<TriplesMap1>
+    a rr:TriplesMapClass;
+    
+    rr:tableOwner "boricles";
+    rr:tableName "Student";
+
+    rr:subjectMap [ rr:template "http://example.com/{ID}{Name}";
+                    rr:class foaf:Person ];
+
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate ex:id ]; 
+      rr:objectMap    [ rr:column "ID"; rr:datatype xsd:integer ]
+    ];
+
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:name ]; 
+      rr:objectMap    [ rr:column "Name" ]
+	]
+    .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D002-1table2columns1row/r2rmlb.ttl	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,30 @@
+@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#> .
+@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
+
+<TriplesMap1>
+     a rr:TriplesMapClass;
+    
+    rr:SQLQuery """
+       Select ('Student' || ID ) AS "StudentId"
+            , ID
+            , Name
+         from Student
+       """;
+
+    rr:subjectMap [ rr:column "StudentId"; rr:termtype "BlankNode"; rr:class foaf:Person ];
+
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate ex:id ]; 
+      rr:objectMap    [ rr:column "ID"; rr:datatype xsd:integer ]
+    ];
+
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:name ]; 
+      rr:objectMap    [ rr:column "Name" ]
+    ]
+    .
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/create.sql	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,6 @@
+CREATE TABLE Student (
+ID integer,
+FirstName varchar(50),
+LastName varchar(50)
+);
+INSERT INTO Student (ID, FirstName, LastName) VALUES (10,"Venus", "Williams");
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/directGraph.ttl	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,4 @@
+_:a a <Student> .
+_:a <Student#ID> 10 .
+_:a <Student#FirstName> "Venus" .
+_:a <Student#LastName> "Williams" .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/mappeda.trig	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,9 @@
+@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
+@prefix foaf: <http://xmlns.com/foaf/0.1/> .
+@prefix ex: <http://example.com/> .
+@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
+
+ex:Student10VenusWilliams rdf:type foaf:Person
+                          ex:id "10"^^xsd:integer;
+                          foaf:firstName "Venus";
+                          foaf:lastName "Williams".
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/mappedb.trig	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,8 @@
+@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
+@prefix foaf: <http://xmlns.com/foaf/0.1/> .
+@prefix ex: <http://example.com/> .
+@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
+
+ex:Student10VenusWilliams rdf:type foaf:Person
+                          ex:id "10"^^xsd:integer;
+                          foaf:name "Venus Williams". 
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/mappedc.trig	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,9 @@
+@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
+@prefix foaf: <http://xmlns.com/foaf/0.1/> .
+@prefix ex: <http://example.com/> .
+@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
+
+_:Student10VenusWilliams rdf:type foaf:Person
+                         ex:id "10"^^xsd:integer;
+                         foaf:firstName "Venus";
+                         foaf:lastName "Williams". 
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/mappedd.trig	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,8 @@
+@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
+@prefix foaf: <http://xmlns.com/foaf/0.1/> .
+@prefix ex: <http://example.com/> .
+@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
+
+_:Student10VenusWilliams rdf:type foaf:Person
+                         ex:id "10"^^xsd:integer;
+                         foaf:name "Venus Williams". 
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/r2rmla.ttl	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,33 @@
+@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#> .
+@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
+
+<TriplesMap1>
+     a rr:TriplesMapClass;
+
+    rr:tableOwner "boricles";
+    rr:tableName "Student";
+
+    rr:subjectMap [ rr:template "http://example.com/Student{ID}{FirstName}{LastName}";
+                    rr:class foaf:Person  ];
+	
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate ex:id ]; 
+      rr:objectMap    [ rr:column "ID"; rr:datatype xsd:integer ]
+    ];
+
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:firstName ]; 
+      rr:objectMap    [ rr:column "FirstName" ]
+    ];
+
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:lastName ]; 
+      rr:objectMap    [ rr:column "LastName" ]
+    ]
+    .
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/r2rmlb.ttl	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,32 @@
+@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#> .
+@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
+
+<TriplesMap1>
+     a rr:TriplesMapClass;
+
+      rr:SQLQuery """
+      SELECT ID,
+             (FirstName || ' ' || LastName) AS Name,
+             FirstName,
+             LastName
+      FROM Student
+      """;
+
+    rr:subjectMap [ rr:template "http://example.com/Student{ID}{FirstName}{LastName}"; 
+                    rr:class foaf:Person ];
+	
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate ex:id ]; 
+      rr:objectMap    [ rr:column "ID"; rr:datatype xsd:integer ]
+    ];
+
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:name ]; 
+      rr:objectMap    [ rr:column "Name" ]
+    ]
+    .
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/r2rmlc.ttl	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,38 @@
+@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#> .
+@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
+
+<TriplesMap1>
+     a rr:TriplesMapClass;
+
+      rr:SQLQuery """
+      SELECT ('Student' || ID || FirstName || LastName) as StudentID,
+             ID,
+             FirstName,
+             LastName
+      FROM Student
+      """;
+
+    rr:subjectMap [ rr:column "StudentID"; rr:termtype "BlankNode";
+                    rr:class foaf:Person  ];
+	
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate ex:id ]; 
+      rr:objectMap    [ rr:column "ID"; rr:datatype xsd:integer ]
+    ];
+
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:firstName ]; 
+      rr:objectMap    [ rr:column "FirstName" ]
+    ];
+
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:lastName ]; 
+      rr:objectMap    [ rr:column "LastName" ]
+    ]
+    .
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D003-1table3columns1row/r2rmld.ttl	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,31 @@
+@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#> .
+@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
+
+<TriplesMap1>
+     a rr:TriplesMapClass;
+
+      rr:SQLQuery """
+      SELECT ('Student' || ID || FirstName || LastName) as StudentID,
+             ID,
+             (FirstName || ' ' || LastName) AS Name
+      FROM Student
+      """;
+
+    rr:subjectMap [ rr:column "StudentID"; rr:termtype "BlankNode";
+                    rr:class foaf:Person  ];
+	
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate ex:id ]; 
+      rr:objectMap    [ rr:column "ID"; rr:datatype xsd:integer ]
+    ];
+
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:name ]; 
+      rr:objectMap    [ rr:column "Name" ]
+    ]
+    .
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D004-1table2columnsprojection/create.sql	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,5 @@
+CREATE TABLE Student_Sport(
+      Student varchar(50),
+      Sport varchar(50)
+);
+INSERT INTO Student_Sport (Student,Sport) VALUES ("Venus", "Tennis");
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D004-1table2columnsprojection/directGraph.ttl	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,3 @@
+_:a a <Student_Sport> .
+_:a <Student_Sport#Student> "Venus" .
+_:a <Student_Sport#Sport> "Tennis" .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D005-2duplicates0nulls/create.sql	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,7 @@
+CREATE TABLE IOUs (
+      fname CHAR(20),
+      lname CHAR(20),
+      amount FLOAT);
+INSERT INTO IOUs (fname, lname, amount) VALUES ("Bob", "Smith", 30);
+INSERT INTO IOUs (fname, lname, amount) VALUES ("Sue", "Jones", 20);
+INSERT INTO IOUs (fname, lname, amount) VALUES ("Bob", "Smith", 30);
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D005-2duplicates0nulls/directGraph.ttl	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,17 @@
+@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
+  
+  _:a a <IOUs> .
+  _:a <IOUs#fname> "Bob" .
+  _:a <IOUs#lname> "Smith" .
+  _:a <IOUs#amount> "30"^^xsd:float .
+  
+  _:b a <IOUs> .
+  _:b <IOUs#fname> "Sue" .
+  _:b <IOUs#lname> "Jones" .
+  _:b <IOUs#amount> "20"^^xsd:float .
+  
+  _:c a <IOUs> .
+  _:c <IOUs#fname> "Bob" .
+  _:c <IOUs#lname> "Smith" .
+  _:c <IOUs#amount> "30"^^xsd:float .
+
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D009-2tables1primarykey1foreingkey/create.sql	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,17 @@
+CREATE TABLE Student (
+ID integer,
+Name varchar(50),
+Sport integer,
+PRIMARY KEY (ID),
+FOREIGN KEY(Sport) REFERENCES Sport(ID)
+);
+
+CREATE TABLE Sport (
+ID integer,
+Name varchar (50),
+PRIMARY KEY (ID)
+);
+
+INSERT INTO Student (ID, Name, Sport) VALUES (10,"Venus Williams", 100);
+INSERT INTO Student (ID, Name, Sport) VALUES (20,"Demi Moore", NULL);
+INSERT INTO Sport (ID, Name) VALUES (100,"Tennis");
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D009-2tables1primarykey1foreingkey/directGraph.ttl	Wed Jul 13 15:39:53 2011 +0100
@@ -0,0 +1,13 @@
+<Student/ID.20#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
+<Student/ID.20#_> <Student#ID> "20"^^<http://www.w3.org/2001/XMLSchema#integer> .
+<Student/ID.20#_> <Student#Name> "Demi Moore" .
+
+<Student/ID.10#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
+<Student/ID.10#_> <Student#ID> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
+<Student/ID.10#_> <Student#Name> "Venus Williams" .
+<Student/ID.10#_> <Student#Sport> <Sport/ID.100#_> .
+
+<Sport/ID.100#_> <Sport#ID> "100"^^<http://www.w3.org/2001/XMLSchema#integer> .
+<Sport/ID.100#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Sport> .
+<Sport/ID.100#_> <Sport#Name> "Tennis" .
+