-- Beispieldaten für Blatt 4, Aufgabe 3

group: Aufgabe 4.3 


Visitor = {
 V_ID:number, LastName:string, HomeCity:string
 100, "Meier", "Wiesbaden"
 101, "Gruber", Berlin
 102, "Müller", "Frankfurt"
 103, "Huber", "München"
 104, "Hansen", Mainz
 105, "Krämer", Mainz
}


Location = {
 PlaceName:string, Country:string, MainAttraction:string
 "Nordisland Vulkanpark", "Island", "Vulkan"
 "Paris", "Frankreich", "Eiffelturm"
 "Berlin", "Deutschland", "Brandenburger Tor"
 "München", "Deutschland", Oktoberfest
 "Neapel", "Italien", "Vulkan"
 Rom, Italien, Colosseum
 "Yellowstone Park", USA, Vulkan
 "New York", USA, "Empire State Building"
}

Visited = {
 V_ID:number, PlaceName:string, Year:number
 100, "Paris", 2005
 100, "Berlin", 2006
 100, "München", 2007
 100, "Neapel", 2008
 100, "Rom", 2009
 100, "New York", 2010
 100, "Yellowstone Park", 2010
 100, "Paris", 2014
 100, "Nordisland Vulkanpark", 2017
 100, "Yellowstone Park", 2019
 101, "Berlin", 2002
 101, "Paris", 2004
 101, "Paris", 2005
 101, "Paris", 2006
 102, "Neapel", 2018
 102, "Berlin", 2005
 103, Paris, 2005
 103, Rom, 2018
 103, "New York", 2019
 104, "New York", 2017
 105, "New York", 2019
}