More databases were included
authorBoris Villazon-Terrazas <bvillazon@fi.upm.es>
Mon, 07 Feb 2011 16:04:15 +0100
changeset 4 1a2af82602e6
parent 3 f52eb3747683
child 5 f0957a893300
More databases were included
1table1compositeprimarykey3columns1row/create.sql
1table1primarykey1column1row/create.sql
1table1row/directGraph.ttl
1table2columns1row/create.sql
1table2columns1row/directGraph.ttl
1table2columnsprojection/create.sql
1table2columnsprojection/directGraph.ttl
1table3columns1row/create.sql
1table3columns1row/directGraph.ttl
2duplicates0nulls/create.sql
2duplicates0nulls/directGraph.ttl
2tables1primarykey1foreingkey/create.sql
--- /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");