--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/1table1compositeprimarykey3columns1row/create.sql Mon Feb 07 16:04:15 2011 +0100
@@ -0,0 +1,7 @@
+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");
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/1table1primarykey1column1row/create.sql Mon Feb 07 16:04:15 2011 +0100
@@ -0,0 +1,4 @@
+CREATE TABLE Student (
+Name varchar(50) PRIMARY KEY
+);
+INSERT INTO Student (Name) VALUES ("Venus");
--- a/1table1row/directGraph.ttl Tue Feb 01 02:10:01 2011 +0100
+++ b/1table1row/directGraph.ttl Mon Feb 07 16:04:15 2011 +0100
@@ -1,3 +1,2 @@
-@prefix ex: <http://example.com/> .
-
- _:b1 ex:name "Venus".
+_:a <Student#Name> "Venus".
+_:a a <Student> .
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/1table2columns1row/create.sql Mon Feb 07 16:04:15 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/1table2columns1row/directGraph.ttl Mon Feb 07 16:04:15 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/1table2columnsprojection/create.sql Mon Feb 07 16:04:15 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/1table2columnsprojection/directGraph.ttl Mon Feb 07 16:04:15 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/1table3columns1row/create.sql Mon Feb 07 16:04:15 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/1table3columns1row/directGraph.ttl Mon Feb 07 16:04:15 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/2duplicates0nulls/create.sql Mon Feb 07 16:04:15 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/2duplicates0nulls/directGraph.ttl Mon Feb 07 16:04:15 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/2tables1primarykey1foreingkey/create.sql Mon Feb 07 16:04:15 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");