Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
| Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
| en:modul:m290_guko:learningunits:lu06:aufgaben:case_gemeinden_kva [2026/09/23 17:52] – Automatic push translation gkoch | en:modul:m290_guko:learningunits:lu06:aufgaben:case_gemeinden_kva [2026/09/23 17:55] (aktuell) – gkoch | ||
|---|---|---|---|
| Zeile 9: | Zeile 9: | ||
| We would like to **record, amend and delete municipalities and waste incineration plants (KVA) in the canton of Zurich** in our database. | We would like to **record, amend and delete municipalities and waste incineration plants (KVA) in the canton of Zurich** in our database. | ||
| - | Your tables: **canton**, **KVA**, **municipality**. | + | Your tables: **kanton**, **kva**, **gemeinde**. |
| <WRAP center round tip 80%> | <WRAP center round tip 80%> | ||
| Zeile 19: | Zeile 19: | ||
| ==== 1. Insert records ==== | ==== 1. Insert records ==== | ||
| - | **kva** (columns: name, town) | + | **kva** (columns: name, ort) |
| <WRAP center box 80% round>< | <WRAP center box 80% round>< | ||
| KVA Hagenholz, Zürich | KVA Hagenholz, Zürich | ||
| Zeile 32: | Zeile 32: | ||
| </ | </ | ||
| - | **municipality** (Columns: name, population, postcode, canton_code, facility_id) | + | **gemeinde** (Columns: name, einwohnerzahl, plz, kantons_kennzeichen, anlage_id) |
| <WRAP center box 80% round>< | <WRAP center box 80% round>< | ||
| (' | (' | ||
| Zeile 41: | Zeile 41: | ||
| </ | </ | ||
| - | Adjust the ‘canton_code’ to match the value you actually created for ‘canton’ (e.g. ‘ZH’). Adjust the ‘facility_id’ to match the order in which you inserted the KVA records. | + | Adjust the ‘kantons_kennzeichen’ to match the value you actually created for ‘kanton’ (e.g. ‘ZH’). Adjust the ‘anlage_id’ to match the order in which you inserted the KVA records. |
| ==== 2. Deliberately violate the constraint ==== | ==== 2. Deliberately violate the constraint ==== | ||
| - | Try entering the same canton **a second time** (`cantons_code` is the primary key). Read the error message. | + | Try entering the same canton **a second time** (`kantons_kennzeichen` is the primary key). Read the error message. |
| ==== 3. Modify data ==== | ==== 3. Modify data ==== | ||