1  drop table if exists participation;
 2  drop table if exists student;
 3  drop table if exists activity;
 4  
 5  create table student(name text, studid integer primary key);
 6  create table activity(indeks integer primary key, ects integer, name text, program text);
 7  create table participation (
 8                                 studid integer references student(studid),
 9                                 indeks integer references activity(indeks)
10  );
11  
12  insert into activity values(11,5,'BK1 Empirical Data','NatBach');
13  insert into activity values(12,5,'BK2 Experimental Methods','NatBach');
14  insert into activity values(13,5,'BK3 Theory of Natural Science','NatBach');
15  insert into activity values(14,5,'Logic and Discrete Mathematics','NatBach');
16  insert into activity values(15,5,'Functional Biology – Zoology','NatBach');
17  insert into activity values(16,5,'Linear Algebra','NatBach');
18  insert into activity values(17,5,'Organic Chemistry','NatBach');
19  insert into activity values(18,5,'Biological Chemistry','NatBach');
20  insert into activity values(19,5,'Statistical Models','NatBach');
21  insert into activity values(20,5,'Functional Programming and Language Implementations','NatBach');
22  insert into activity values(21,5,'Classical Mechanics','NatBach');
23  insert into activity values(22,5,'Environmental Science','NatBach');
24  insert into activity values(23,5,'Cell Biology','NatBach');
25  insert into activity values(24,5,'Functional biology – Botany','NatBach');
26  insert into activity values(25,5,'Supplementary Physics','NatBach');
27  insert into activity values(26,5,'Calculus','NatBach');
28  insert into activity values(27,5,'The Chemical Reaction','NatBach');
29  insert into activity values(28,5,'Scientific Computing','NatBach');
30  insert into activity values(29,5,'Energy and Climate Changes','NatBach');
31  insert into activity values(30,5,'BP1 NatBach','NatBach');
32  insert into activity values(31,5,'BP2 NatBach','NatBach');
33  insert into activity values(32,5,'BP3 NatBach','NatBach');
34  insert into activity values(33,5,'Bachelorproject NatBach','NatBach');
35  insert into activity values(34,5,'Design og Konstruktion I+Workshop','HumTek');
36  insert into activity values(35,5,'Subjektivitet, Teknologi og Samfund I','HumTek');
37  insert into activity values(36,5,'Teknologiske systemer og artefakter I','HumTek');
38  insert into activity values(37,5,'Videnskabsteori','HumTek');
39  insert into activity values(38,5,'Design og Konstruktion II+Workshop','HumTek');
40  insert into activity values(39,5,'Subjektivitet, Teknologi og Samfund II','HumTek');
41  insert into activity values(40,5,'Bæredygtige teknologier','HumTek');
42  insert into activity values(41,5,'Kunstig intelligens','HumTek');
43  insert into activity values(42,5,'Medier og teknologi - datavisualisering','HumTek');
44  insert into activity values(43,5,'Teknologiske Systemer og Artefakter II - Sundhedsteknologi','HumTek');
45  insert into activity values(44,5,'Den (in)humane storby','HumTek');
46  insert into activity values(45,5,'Interactive Design in the Field','HumTek');
47  insert into activity values(46,5,'Organisation og ledelse af designprocesser','HumTek');
48  insert into activity values(47,5,'BP1 HumTek','HumTek');
49  insert into activity values(48,5,'BP2 HumTek','HumTek');
50  insert into activity values(49,5,'BP3 HumTek','HumTek');
51  insert into activity values(50,5,'Bachelorproject HumTek','HumTek');
52  insert into activity values(51,5,'Essential Computing','Computer Science');
53  insert into activity values(52,10,'Software Development','Computer Science');
54  insert into activity values(53,5,'Interactive Digital Systems','Computer Science');
55  insert into activity values(54,5,'Subject module project in Computer Science','Computer Science');
56  insert into activity values(55,5,'Organisatorisk forandring og IT','Informatik');
57  insert into activity values(56,10,'BANDIT','Informatik');
58  insert into activity values(57,5,'Web baserede IT-Systemer','Informatik');
59  insert into activity values(58,5,'Subject module project in Informatik','Informatik');
60  insert into activity values(59,5,'Essential Astrology','Astrology');
61  insert into activity values(60,5,'Venus studies','Astrology');
62  insert into activity values(61,5,'Mars studies','Astrology');
63  insert into activity values(62,5,'Ascendant calculations','Astrology');
64  insert into activity values(63,5,'Subject module project in Astrology','Astrology');
65  
66  insert into student values ('Ian', 123);