drop table if exists participation;
drop table if exists student;
drop table if exists activity;

create table student(name text, studid integer primary key);
create table activity(indeks integer primary key, ects integer, name text, program text);
create table participation (
                               studid integer references student(studid),
                               indeks integer references activity(indeks)
);

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

insert into student values ('Ian', 123);