ueCVAGsV

1PRAGMA foreign_keys=ON;
2.mode columns
3.headers on
4.nullvalue NULL
5
6DROP TABLE IF EXISTS Talk;
7DROP TABLE IF EXISTS Speaker;
8DROP TABLE IF EXISTS Topic;
9
10CREATE TABLE Speaker (
11	Id INTEGER PRIMARY KEY,
12	Name Text Not Null,
13	Institution Text Not Null,
14	Country Text Not Null);
15
16CREATE TABLE Topic (
17	Id INTEGER PRIMARY KEY,
18	Name Text NOT NULL);
19
20CREATE TABLE Talk (
21	speaker INTEGER REFERENCES Speaker,
22	topic INTEGER REFERENCES Topic,
23	Title Text NOT NULL,
24	Day Text,
25	PRIMARY KEY (speaker, topic, Title));
26
27
28INSERT INTO Speaker VALUES (1, "Jeffrey Ullman", "Stanford University", "USA");
29INSERT INTO Speaker VALUES (2, "Gabriel David", "University of Porto", "Portugal");
30INSERT INTO Speaker VALUES (3, "Bill Gates", "Gates Foundation", "USA");
31INSERT INTO Speaker VALUES (4, "Yoshua Bengio", "Université de Montréal", "Canada");
32INSERT INTO Speaker VALUES (5, "Grady Booch", "IBM Research", "USA");
33INSERT INTO Speaker VALUES (6, "Ademar Aguiar", "University of Porto", "Portugal");
34INSERT INTO Speaker VALUES (7, "Arlindo Oliveira", "IST", "Portugal");
35INSERT INTO Speaker VALUES (8, "Carles Sierra", "IIIA", "Spain");
36
37INSERT INTO Topic VALUES (1, "Intelligent Systems");
38INSERT INTO Topic VALUES (2, "Databases");
39INSERT INTO Topic VALUES (3, "Software Engineering");
40INSERT INTO Topic VALUES (4, "Computer Graphics");
41INSERT INTO Topic VALUES (5, "Programming Languages");
42INSERT INTO Topic VALUES (6, "Social Impact");
43
44INSERT INTO Talk VALUES (1, 2, "To sequel or not to sequel", "Monday");
45INSERT INTO Talk VALUES (2, 2, "The future of database systems", NULL);
46INSERT INTO Talk VALUES (3, 3, "Software Engineering at Microsoft", "Monday");
47INSERT INTO Talk VALUES (4, 1, "Deep Learning Applications", "Wednesday");
48INSERT INTO Talk VALUES (5, 3, "How to thrive in SE", "Monday");
49INSERT INTO Talk VALUES (6, 3, "Agile Software Engineering", "Tuesday");
50INSERT INTO Talk VALUES (7, 1, "Building Synthetic Brains", NULL);
51INSERT INTO Talk VALUES (8, 1, "Intelligent Agent Applications", "Monday");
52INSERT INTO Talk VALUES (3, 6, "Social Responsibility of Success", "Monday");
53INSERT INTO Talk VALUES (5, 1, "Artificial Intelligence is your friend", NULL);