One solution to database exercise 1 - sem6 1998

groupperson

groupid

personid
c126
22
c126
36
c126
37
c201
10
c201
24
c201
26
c201
28
c201
33
c202
13
c202
15
c202
16
c202
4
c203
12
c203
17
c203
2
c203
23
c203
25
c203
38
c204
11
c204
29
c204
30
c204
6
c204
9
c205
18
c205
31
c205
32
c205
34
c205
39
c218
1
c218
14
c218
21
c218
3
c219
19
c219
27
c219
5
c219
7
c219
8


person

personid

fnavn
enavn
1
Alice
Andersen
10
Peter Dalsgaard
Frederiksen
11
Anette
Haarup-Jensen
12
Thomas Østergaard
Hansen
13
Heine Kjeldsen
Jensen
14
Jan Per
Jensen
15
Rasmus Lund
Jensen
16
Tom Laurits
Jepsen
17
Jakob
Kloster
18
Morten Mejlhede
Kramer
19
Jonas
Kristensen
2
Anders
Augustesen
20
Mette Østergaard
Kristiansen
21
Jesper Thorsgaard
Larsen
22
Søren Søndergaard
Larsen
23
Morten
Liingaard
24
Marlene Lindegaard
Madsen
25
Martin Vittrup
Marcussen
26
Peter
Madsen
27
Claus
Nielsen
28
Michael Yde
Nielsen
29
Thai Nan
Nguyen
3
Marianne
Bjerre
30
Thomas Ewen
Orkild
31
Jens Elbæk
Pedersen
32
Martin
Pedersen
33
Poul Linneberg
Pedersen
34
Søren Skov
Pedersen
35
Jepepe
Steensgaard
36
Troels Erhardsen
Tarpgaard
37
Jacob Brixen
Therkelsen
38
Mikael
Østergaard
39
Flemming
Jensen
4
Christian
Byrjalsen
5
Jeppe Drachmann
Christensen
6
Morten
Dalsgaard
7
Lars Raabjerg
Didriksen
8
Søren
Falkenberg
9
Thomas Louis
Flindt

projgroup

groupid

projid
date
c126
3
2-2-98
c201
2
2-2-98
c202
1
2-2-98
c203
4
2-2-98
c204
3
2-2-98
c205
3
2-2-98
c218
1
2-2-98
c219
3
2-2-98

projtype

projid

projname
date
1
adm_aalborg_kommun
1-1-98
2
kontorshus_havnefront
1-1-98
3
stibro_vdskov
1-1-998
4
havnetunnel
1-1-98

Per Christiansson 17.2.1998