aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--opdracht-2/img_erd.svg3
-rw-r--r--opdracht-2/img_strokendiagram.svg3
-rw-r--r--opdracht-2/imgs.drawio1
-rw-r--r--opdracht-2/opdracht-2.m475
-rw-r--r--opdracht-2/q6.sql3
-rw-r--r--opdracht-2/q8.sql1
-rw-r--r--opdracht-2/t10.sql1
-rw-r--r--opdracht-2/t11.sql7
-rw-r--r--opdracht-2/t4.sql1
-rw-r--r--opdracht-2/t5.sql1
-rw-r--r--opdracht-2/t6.sql10
-rw-r--r--opdracht-2/t7.sql10
-rw-r--r--opdracht-2/t8.sql1
-rw-r--r--opdracht-2/t9.sql1
14 files changed, 68 insertions, 50 deletions
diff --git a/opdracht-2/img_erd.svg b/opdracht-2/img_erd.svg
new file mode 100644
index 0000000..e32382a
--- /dev/null
+++ b/opdracht-2/img_erd.svg
@@ -0,0 +1,3 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
+<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" version="1.1" width="502px" height="32px" viewBox="-0.5 -0.5 502 32"><defs><style type="text/css">@import url(https://fonts.googleapis.com/css?family=Permanent+Marker);&#xa;</style></defs><g><rect x="0" y="0" width="70" height="30" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 15px; margin-left: 1px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Klant</div></div></div></foreignObject><text x="35" y="19" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Klant</text></switch></g><rect x="210" y="0" width="70" height="30" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 15px; margin-left: 211px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Order</div></div></div></foreignObject><text x="245" y="19" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Order</text></switch></g><rect x="430" y="0" width="70" height="30" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 15px; margin-left: 431px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Product</div></div></div></foreignObject><text x="465" y="19" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Product</text></switch></g><path d="M 360 0 L 400 15 L 360 30 L 320 15 Z" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 78px; height: 1px; padding-top: 15px; margin-left: 321px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">bevat</div></div></div></foreignObject><text x="360" y="19" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">bevat</text></switch></g><path d="M 140 0 L 180 15 L 140 30 L 100 15 Z" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 78px; height: 1px; padding-top: 15px; margin-left: 101px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">plaatst</div></div></div></foreignObject><text x="140" y="19" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">plaatst</text></switch></g><path d="M 180 15 L 210 15 L 180 15 L 210 15" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><ellipse cx="198" cy="15" rx="3" ry="3" fill="#ffffff" stroke="rgb(0, 0, 0)" pointer-events="all"/><path d="M 210 11 L 202 15 L 210 19" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 100 15 L 70 15 L 100 15 L 70 15" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 74 11 L 74 19 M 78 11 L 78 19" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 320 15 L 290 15 L 310 15 L 280 15" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><ellipse cx="292" cy="15" rx="3" ry="3" fill="#ffffff" stroke="rgb(0, 0, 0)" pointer-events="all"/><path d="M 280 19 L 288 15 L 280 11" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 400 15 L 430 15 L 400 15 L 430 15" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 422 19 L 422 11 M 430 11 L 422 15 L 430 19" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/></g><switch><g requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"/><a transform="translate(0,-5)" xlink:href="https://www.diagrams.net/doc/faq/svg-export-text-problems" target="_blank"><text text-anchor="middle" font-size="10px" x="50%" y="100%">Text is not SVG - cannot display</text></a></switch></svg> \ No newline at end of file
diff --git a/opdracht-2/img_strokendiagram.svg b/opdracht-2/img_strokendiagram.svg
new file mode 100644
index 0000000..001c551
--- /dev/null
+++ b/opdracht-2/img_strokendiagram.svg
@@ -0,0 +1,3 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
+<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" version="1.1" width="649px" height="282px" viewBox="-0.5 -0.5 649 282"><defs/><g><rect x="148" y="20" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 30px; margin-left: 149px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">ID</div></div></div></foreignObject><text x="183" y="34" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">ID</text></switch></g><rect x="218" y="20" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 30px; margin-left: 219px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Naam</div></div></div></foreignObject><text x="253" y="34" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Naam</text></switch></g><rect x="288" y="20" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 30px; margin-left: 289px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Postcode</div></div></div></foreignObject><text x="323" y="34" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Postcode</text></switch></g><rect x="358" y="20" width="90" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 88px; height: 1px; padding-top: 30px; margin-left: 359px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Huisnummer</div></div></div></foreignObject><text x="403" y="34" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Huisnummer</text></switch></g><rect x="448" y="20" width="110" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 108px; height: 1px; padding-top: 30px; margin-left: 449px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Telefoonnummer</div></div></div></foreignObject><text x="503" y="34" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Telefoonnummer</text></switch></g><rect x="558" y="20" width="90" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 88px; height: 1px; padding-top: 30px; margin-left: 559px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Woonplaats</div></div></div></foreignObject><text x="603" y="34" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Woonplaats</text></switch></g><rect x="78" y="100" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 110px; margin-left: 79px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">ID</div></div></div></foreignObject><text x="113" y="114" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">ID</text></switch></g><path d="M 183 100 L 183 46.37" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 183 41.12 L 186.5 48.12 L 183 46.37 L 179.5 48.12 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><rect x="148" y="100" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 110px; margin-left: 149px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">KlantID</div></div></div></foreignObject><text x="183" y="114" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">KlantID</text></switch></g><rect x="218" y="100" width="90" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 88px; height: 1px; padding-top: 110px; margin-left: 219px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Besteldatum</div></div></div></foreignObject><text x="263" y="114" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Besteldatum</text></switch></g><rect x="568" y="0" width="80" height="20" fill="none" stroke="none" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-end; width: 78px; height: 1px; padding-top: 10px; margin-left: 568px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: right;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Klant</div></div></div></foreignObject><text x="646" y="14" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="end">Klant</text></switch></g><rect x="308" y="100" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 110px; margin-left: 309px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Status</div></div></div></foreignObject><text x="343" y="114" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Status</text></switch></g><rect x="378" y="100" width="90" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 88px; height: 1px; padding-top: 110px; margin-left: 379px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Leverdatum</div></div></div></foreignObject><text x="423" y="114" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Leverdatum</text></switch></g><rect x="388" y="80" width="80" height="20" fill="none" stroke="none" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-end; width: 78px; height: 1px; padding-top: 90px; margin-left: 388px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: right;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Order</div></div></div></foreignObject><text x="466" y="94" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="end">Order</text></switch></g><rect x="148" y="180" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 190px; margin-left: 149px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">ID</div></div></div></foreignObject><text x="183" y="194" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">ID</text></switch></g><rect x="218" y="180" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 190px; margin-left: 219px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Naam</div></div></div></foreignObject><text x="253" y="194" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Naam</text></switch></g><rect x="288" y="180" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 190px; margin-left: 289px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Eenheid</div></div></div></foreignObject><text x="323" y="194" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Eenheid</text></switch></g><rect x="358" y="180" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 190px; margin-left: 359px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Prijs</div></div></div></foreignObject><text x="393" y="194" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Prijs</text></switch></g><rect x="428" y="180" width="90" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 88px; height: 1px; padding-top: 190px; margin-left: 429px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Beschrijving</div></div></div></foreignObject><text x="473" y="194" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Beschrijving</text></switch></g><rect x="508" y="160" width="80" height="20" fill="none" stroke="none" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-end; width: 78px; height: 1px; padding-top: 170px; margin-left: 508px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: right;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Product</div></div></div></foreignObject><text x="586" y="174" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="end">Product</text></switch></g><rect x="518" y="180" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 190px; margin-left: 519px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Voorraad</div></div></div></foreignObject><text x="553" y="194" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Voorraad</text></switch></g><rect x="8" y="260" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 270px; margin-left: 9px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">ID</div></div></div></foreignObject><text x="43" y="274" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">ID</text></switch></g><path d="M 113 260 L 113 126.37" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 113 121.12 L 116.5 128.12 L 113 126.37 L 109.5 128.12 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><rect x="78" y="260" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 270px; margin-left: 79px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">OrderID</div></div></div></foreignObject><text x="113" y="274" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">OrderID</text></switch></g><path d="M 183 260 L 183 206.37" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 183 201.12 L 186.5 208.12 L 183 206.37 L 179.5 208.12 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><rect x="148" y="260" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 270px; margin-left: 149px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">ProductID</div></div></div></foreignObject><text x="183" y="274" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">ProductID</text></switch></g><rect x="218" y="260" width="100" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 98px; height: 1px; padding-top: 270px; margin-left: 219px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Aantal</div></div></div></foreignObject><text x="268" y="274" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Aantal</text></switch></g><rect x="238" y="240" width="80" height="20" fill="none" stroke="none" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-end; width: 78px; height: 1px; padding-top: 250px; margin-left: 238px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: right;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">OrderProduct</div></div></div></foreignObject><text x="316" y="254" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="end">OrderProduct</text></switch></g><path d="M 154.37 10 L 211.63 10" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 149.12 10 L 156.12 6.5 L 154.37 10 L 156.12 13.5 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 216.88 10 L 209.88 13.5 L 211.63 10 L 209.88 6.5 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 1px; height: 1px; padding-top: 10px; margin-left: 184px;"><div data-drawio-colors="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); border-color: #FFFFFF; " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 11px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; background-color: rgb(255, 255, 255); border: 1px solid rgb(255, 255, 255); white-space: nowrap;">p</div></div></div></foreignObject><text x="184" y="14" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="11px" text-anchor="middle">p</text></switch></g><path d="M 84.37 89.64 L 141.63 89.64" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 79.12 89.64 L 86.12 86.14 L 84.37 89.64 L 86.12 93.14 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 146.88 89.64 L 139.88 93.14 L 141.63 89.64 L 139.88 86.14 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 1px; height: 1px; padding-top: 90px; margin-left: 114px;"><div data-drawio-colors="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); border-color: #FFFFFF; " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 11px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; background-color: rgb(255, 255, 255); border: 1px solid rgb(255, 255, 255); white-space: nowrap;">p</div></div></div></foreignObject><text x="114" y="93" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="11px" text-anchor="middle">p</text></switch></g><path d="M 154.37 169.64 L 211.63 169.64" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 149.12 169.64 L 156.12 166.14 L 154.37 169.64 L 156.12 173.14 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 216.88 169.64 L 209.88 173.14 L 211.63 169.64 L 209.88 166.14 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 1px; height: 1px; padding-top: 170px; margin-left: 184px;"><div data-drawio-colors="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); border-color: #FFFFFF; " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 11px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; background-color: rgb(255, 255, 255); border: 1px solid rgb(255, 255, 255); white-space: nowrap;">p</div></div></div></foreignObject><text x="184" y="173" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="11px" text-anchor="middle">p</text></switch></g><path d="M 14.37 249.64 L 71.63 249.64" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 9.12 249.64 L 16.12 246.14 L 14.37 249.64 L 16.12 253.14 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 76.88 249.64 L 69.88 253.14 L 71.63 249.64 L 69.88 246.14 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 1px; height: 1px; padding-top: 250px; margin-left: 44px;"><div data-drawio-colors="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); border-color: #FFFFFF; " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 11px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; background-color: rgb(255, 255, 255); border: 1px solid rgb(255, 255, 255); white-space: nowrap;">p</div></div></div></foreignObject><text x="44" y="253" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="11px" text-anchor="middle">p</text></switch></g><path d="M 84.37 249.9 L 211.63 249.9" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 79.12 249.9 L 86.12 246.4 L 84.37 249.9 L 86.12 253.4 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 216.88 249.9 L 209.88 253.4 L 211.63 249.9 L 209.88 246.4 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 1px; height: 1px; padding-top: 250px; margin-left: 148px;"><div data-drawio-colors="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); border-color: #FFFFFF; " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 11px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; background-color: rgb(255, 255, 255); border: 1px solid rgb(255, 255, 255); white-space: nowrap;">a</div></div></div></foreignObject><text x="148" y="254" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="11px" text-anchor="middle">a</text></switch></g><path d="M 224.37 169.79 L 281.63 169.98" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 219.12 169.77 L 226.13 166.3 L 224.37 169.79 L 226.11 173.3 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 286.88 170 L 279.87 173.47 L 281.63 169.98 L 279.89 166.47 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 1px; height: 1px; padding-top: 170px; margin-left: 254px;"><div data-drawio-colors="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); border-color: #FFFFFF; " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 11px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; background-color: rgb(255, 255, 255); border: 1px solid rgb(255, 255, 255); white-space: nowrap;">a</div></div></div></foreignObject><text x="254" y="174" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="11px" text-anchor="middle">a</text></switch></g></g><switch><g requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"/><a transform="translate(0,-5)" xlink:href="https://www.diagrams.net/doc/faq/svg-export-text-problems" target="_blank"><text text-anchor="middle" font-size="10px" x="50%" y="100%">Text is not SVG - cannot display</text></a></switch></svg> \ No newline at end of file
diff --git a/opdracht-2/imgs.drawio b/opdracht-2/imgs.drawio
new file mode 100644
index 0000000..3d95ee8
--- /dev/null
+++ b/opdracht-2/imgs.drawio
@@ -0,0 +1 @@
+<mxfile host="app.diagrams.net" modified="2022-10-05T10:18:41.264Z" agent="5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36" etag="iL_3d-T9ILfUpQtpVPgu" version="17.4.4" type="device" pages="2"><diagram id="R2lEEEUBdFMjLlhIrx00" name="ERD">3VhtT9swEP41+UjVxHSUj/SNTVNXBJNW9s3E18TCyRXXpQm/fnbjvDWwMrY1UKmqfI/vzvZzT3JWHDKMkktJl+EUGQjH67LEISPH8z6du/rfAGkGkD7JgEBylkFuCdzwJ7Bg16JrzmBVc1SIQvFlHfQxjsFXNYxKiZu62wJFfdUlDaAB3PhUNNEfnKkwQ/u9bol/Bh6E+cpu185ENHe2wCqkDDc1CBI1wVjZLV6BjGgMsdIzUyrvQTq9caiUOemF4030b2G8OwFiIIAu+arjY6Rhf6VdJgsacWForiQa2ER6OTJ2yFAiqmwUJUMQplR5GbI9TV6YLXiQJu8rAi7v8Od89i2ePszuHwbIvvhMndgsj1SsLb9fBTX73BKk0px1ieuYgcnUdchgE3IFN0vqm9mNlpnGQhUJbbl6aHOCVJC8uFm3oEArFTACJVPtsilremaLElbKSSxGbYmCIrI8uR7Yw/8BEV6DiJlkWZ3aIcIGFM9dW8SQBjFXEtnab1EjNuCUtExNr0HNHTzSZ4gJMbpbrw5CCvGapPQPScppg5SloFSt2qWl6AJt0XLWoKXBBzDd6Kypj8VVeg2CKo7xuJwZmI5ju7Lr1XmCmF2YDqvN8fUTSPyOUxqn2cyEi9yv/qDqpWQ6rxq3xuj0cnOUVCdHaW4lXM3zlfW4EqWtMsgYeYztsqzR4nfqqHnBtfRhv84UlQGofS/23/aZQhtVIRSg3Nbgsb7h5+Rh17hCvr0w5MI7t3nSuujyDNk5bVC1e+/k8XbynHg7iTIiGom2Yi3O/Xb99g+tX31hYrMYXpar+za5dt+3XPdfi/6rXIub8F/KlXjtyvX8/b9uP5Z+ex/jdXss+s1v/YcTMMZQ6PcoLgivVSw5jgsCcet5ev9KsNosP1Jk7uWHJTL+BQ==</diagram><diagram id="zBtBVbs9YWVG884YRixd" name="Strokendiagram">7Vtbd6M2EP41ftw95ubLY+wk3Z6mbdrspfuogAzaCuQj5NjeX18BwhhGsd0kBiXEDznWWBrQN/PNjAYycObx5heOltHvLMB0YA+DzcC5HNj21LLk30ywLQTe0CsEISdBIbIqwR35iZVwqKQrEuC0NlEwRgVZ1oU+SxLsi5oMcc7W9WkLRutXXaIQA8GdjyiUfiOBiArpxBtW8k+YhFF5ZWuofolROVkJ0ggFbL0ncq4GzpwzJopv8WaOaYZdiUux7vqRX3c3xnEiTlnw1Q3XH/DNF3S9+fxl/lcwW1v3H5SWB0RXasO/XqrbFdsSA85WSYAzNcOBM1tHROC7JfKzX9fS6FIWiZjKkSW/KoWYC7x59E6t3f6l32AWY8G3ckq5oERX+UyJ4LoywFiJoj3sy2lImTzcKa5QkV8UMP8DJBuA9AdCcecw7TZsCEwOgOmWpcKXEaF7qKZmQeUCqD6tSJqs4hjzzsFyRkfBmrYJlgfA+owpXjAZ8c0AzD0eryyrTcRGALFvEq0lRUiknaPlGeZeYxNT4KSO0a6q6Cy2jwAkOJCFkhoyLiIWsgTRq0o6q4NWzblhbKmg+oGF2KqqD60EqwOJN0T8ky3/6KnRd6Us+3652R9sy0Ei97u3KBt+L/Vlg2pZPirXFfvLNnXYZBIDtuI+PgDWpJgnEA+xOFZ8QRfgmCJBHur38eIWnQC3/42iRBjg+83yr3PnnwKoZjgVmAZIrMwrA3VwtRpQLVjd5K4FkJJ7FnU4UsHZv3jOKONSkrAkCyMLQmlDhCgJEznkxXZmGYBEHtoulDwmQZCHIB38dQO9REYbQ8QnrSIOS6Q7IZ2z+2TvWIZx2YK10Q2WWzSDy84Jeb9dLsPq6E8eaGrut8Jlp3FSnHRNbZinTUzRGpjapTXM0Ub2aDoHqlS8B9QVTuSlg+6xmpqGFeyO3nLyw4CsOjINKRsgJUtkP5JoPZAk7Bww1zkOWKt51dY0SzkLVv4brpKbpeCo49Rqw3PKV8Y4R6j7WOgZlzfgEcOEOqTRStS4VLttMg9A8t4me9Sl1FHsaJ9srPeBdvpkNjww5icgA7x/Ypr3u+/ef7r3j0/0/uIE2Jn7wwaAKlQMIAB4UaBrBtjwtH6BEoFo51CBlwU0UO26Te1EC3gSzQPrW6+DbbdhCbfjOtiBFIdxPAkusrep5MinKE2Jn+OPuIDiPQvpwDsePSF0e9B4GmhK2ckhUV3hlpHsscTjD57qGoqYrhZVoAM98IlMXU8R8oGe3Hi7TT/DnrAXttQm5ht0j2ndYCVVfGkRzA9xheOU/ET3ub7MuMtsO/kGvdnAu5QSmqmXGV1yuiTkwHau80/mPZJnJAn/VmY8yC71dp+63GAH8L7rHPDtZyTPhoXLKWyxSPFZrOfCsNhPNjaq28n048h9Gh+bvNaoOjMlXdhJ7C0l3aHeqwympP1OSX2CHD2dlCBJanSdm5WwCdtfVtqvjpWwfdtTVjbPE08nZbOjpFF1bk7CPnN/Oem+Ok7CZmk/Oakh0vRl8qRG1bkpCfsDqLeUHL06SsKWZD8pqSs4x+Nh9XlqIdt8bWXcbrvHhe2e/tLzuc9KXpCeclj9c2cxvfoPWefqPw==</diagram></mxfile> \ No newline at end of file
diff --git a/opdracht-2/opdracht-2.m4 b/opdracht-2/opdracht-2.m4
index e733be3..eebbed3 100644
--- a/opdracht-2/opdracht-2.m4
+++ b/opdracht-2/opdracht-2.m4
@@ -8,62 +8,37 @@ q_with_test(2)
## Opdracht 3
-> Voordat je bovenstaande gaat doen (als het goed is zou je deze conclusie zelf
-> ook al hebben getrokken, ga je eerst je ontwerp aanpassen.
-> - Pas het ontwerp: ERD en strokendiagram aan.
-
-## Opdracht 4
-
-> Maak een query van de tabel product waarbij alle kolomkoppen een logische
-> 'Aliasnaam' krijgen.
-
-## Opdracht 5
-
-> Maak een query waarbij de volgende output verschijnt:
-> - 'De klant' <Naam> ' woont in de plaats:' <plaats>
-
-## Opdracht 6
-
-> Maak voor een willekeurige klant een query aan die de totaalprijs laat zien van
-> het aantal producten wat binnen 1 order is besteld in Euro's. Waarbij minimaal
-> de volgende producten/aantallen voorkomen in de order:
-> product 1, 3 stuks
-> product 2, 5 stuks
-> product 3, 2 stuks
-> Tip: zet de rekensom in de formule van de query.
-
-## Opdracht 7
-
-> Rond de uitkomst van de hiervoor gemaakte query af op hele Euro's.
-
-## Opdracht 8
-
-> Maak een query die van de orderlijst uitsluitend de orders laat zien die de
-> status 'nog te leveren' hebben.
-
-## Opdracht 9
-
-> Maak een query die alle klantgegevens laat zien voor alle orders die status
-> 'nog te leveren' hebben.
-
-## Opdracht 10
-
-> Maak een query waarbij alle artikelprijzen met 10% worden verhoogd.
-> In de query toon je de oorspronkelijke prijs en de nieuwe prijs.
-> (de nieuwe prijs wordt alleen getoond, niet opgeslagen in de database).
-
-## Opdracht 11
-
-> Wat is het verschil tussen een join en een union, toon dit aan middels een
-> sprekend voorbeeld?
+<div align="center">
+ <img src="img_erd.svg"/><br/>
+ <i>ERD</i>
+</div>
+
+<div align="center">
+ <img src="img_strokendiagram.svg"/><br/>
+ <i>Strokendiagram</i>
+</div>
+
+q_with_output(4)
+q_with_output(5)
+q_with_test(6)
+q_with_output(7)
+q_with_test(8)
+q_with_output(9)
+q_with_output(10)
+q_with_output(11)
+
+Een union voegt de *rijen* van twee `select` statements samen, terwijl een join
+tabel*kolommen* samenvoegt met behulp van overeenkomende waardes.
## Opdracht 12
-> Wat doet de 'group by' functie?
+`group by` haalt rijen weg afhankelijk van welke rijen de zelfde waardes hebben
+in de doorgegeven kolommen.
## Opdracht 13
-> Wat is het effect van 'having'?
+`having` werkt het zelfde als `where`, maar `where` filtert vòòr `group by`,
+terwijl `having` ná `group by` filtert.
## Opdracht 14
diff --git a/opdracht-2/q6.sql b/opdracht-2/q6.sql
new file mode 100644
index 0000000..397f403
--- /dev/null
+++ b/opdracht-2/q6.sql
@@ -0,0 +1,3 @@
+update OrderProduct set Aantal = 3 where ProductID = 1;
+insert into OrderProduct (OrderID, ProductID, Aantal) values (1, 2, 5);
+insert into OrderProduct (OrderID, ProductID, Aantal) values (1, 3, 2);
diff --git a/opdracht-2/q8.sql b/opdracht-2/q8.sql
new file mode 100644
index 0000000..e0d4855
--- /dev/null
+++ b/opdracht-2/q8.sql
@@ -0,0 +1 @@
+update `Order` set Status = "Nog te leveren" where ID = 1;
diff --git a/opdracht-2/t10.sql b/opdracht-2/t10.sql
new file mode 100644
index 0000000..1fef2e5
--- /dev/null
+++ b/opdracht-2/t10.sql
@@ -0,0 +1 @@
+select Prijs, round(Prijs * 1.10, 2) as NieuwePrijs from Product;
diff --git a/opdracht-2/t11.sql b/opdracht-2/t11.sql
new file mode 100644
index 0000000..aa17c5a
--- /dev/null
+++ b/opdracht-2/t11.sql
@@ -0,0 +1,7 @@
+-- laat twee ongerelateerde tabellen onder elkaar zien
+-- (werkt want aantal kolommen komt overeen)
+select * from Klant union select * from Product;
+
+-- laat twee gerelateerde tabellen naast elkaar zien
+-- (voegt kolommen toe)
+select * from Klant left join `Order` on `Order`.KlantID = Klant.ID;
diff --git a/opdracht-2/t4.sql b/opdracht-2/t4.sql
new file mode 100644
index 0000000..a04cef1
--- /dev/null
+++ b/opdracht-2/t4.sql
@@ -0,0 +1 @@
+select * from Product;
diff --git a/opdracht-2/t5.sql b/opdracht-2/t5.sql
new file mode 100644
index 0000000..b5a02c4
--- /dev/null
+++ b/opdracht-2/t5.sql
@@ -0,0 +1 @@
+select concat("De klant ", Naam, " woont in de plaats ", Woonplaats) as "Een query waarbij de volgende output verschijnt" from Klant;
diff --git a/opdracht-2/t6.sql b/opdracht-2/t6.sql
new file mode 100644
index 0000000..83eddf5
--- /dev/null
+++ b/opdracht-2/t6.sql
@@ -0,0 +1,10 @@
+select
+ `Order`.ID as OrderID,
+ concat("product ", Product.ID, ", ", OrderProduct.Aantal, " stuks") as OrderInhoud,
+ round(Product.Prijs * OrderProduct.Aantal, 2) as Subtotaal
+from OrderProduct
+ left join `Order` on `Order`.ID = OrderProduct.OrderID
+ left join Klant on Klant.ID = `Order`.KlantID
+ left join Product on Product.ID = OrderProduct.ProductID
+where Klant.ID = 1
+group by OrderProduct.ProductID, `Order`.ID;
diff --git a/opdracht-2/t7.sql b/opdracht-2/t7.sql
new file mode 100644
index 0000000..a804a10
--- /dev/null
+++ b/opdracht-2/t7.sql
@@ -0,0 +1,10 @@
+select
+ `Order`.ID as OrderID,
+ concat("product ", Product.ID, ", ", OrderProduct.Aantal, " stuks") as OrderInhoud,
+ round(Product.Prijs * OrderProduct.Aantal) as Subtotaal
+from OrderProduct
+ left join `Order` on `Order`.ID = OrderProduct.OrderID
+ left join Klant on Klant.ID = `Order`.KlantID
+ left join Product on Product.ID = OrderProduct.ProductID
+where Klant.ID = 1
+group by OrderProduct.ProductID, `Order`.ID;
diff --git a/opdracht-2/t8.sql b/opdracht-2/t8.sql
new file mode 100644
index 0000000..0281e6e
--- /dev/null
+++ b/opdracht-2/t8.sql
@@ -0,0 +1 @@
+select * from `Order` where Status = "Nog te leveren";
diff --git a/opdracht-2/t9.sql b/opdracht-2/t9.sql
new file mode 100644
index 0000000..8307a0b
--- /dev/null
+++ b/opdracht-2/t9.sql
@@ -0,0 +1 @@
+select Klant.* from `Order` left join Klant on Klant.ID = `Order`.KlantID where `Order`.Status = "Nog te leveren";