Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu03:loesungen:l01 [2024/08/16 11:28] – gelöscht vdemir
+++ modul:m290:learningunits:lu03:loesungen:l01 [2024/10/17 12:32] (aktuell) – vdemir
@@ Zeile 1: / Zeile 1: @@
+====== LU04.S01 - Choose data-types ======
+Which datatype would you use to store the following information? Give reason for your decision.
+. Product-title like trousers up to 50 characters:
+  *<color #ed1c24>VARCHAR(50)</color>
+  *<color #ed1c24>Titles can be at the most 50 characters. A fix length like a simple CHAR(50) makes no sense in that case. </color>
+. Product-description up to 255 characters:
+  *<color #ed1c24>VARCHAR(255)</color>
+  *<color #ed1c24>The description can be 255 characters, but can also be shorter. A fix length does not make sense in that case. </color>
+. Stock amount:
+  *<color #ed1c24>INT or INTEGER</color>
+  *<color #ed1c24>Floating point type is not suitable as pieces are always counted in whole numbers.  </color>
+. Price of each piece:
+  *<color #ed1c24>FLOAT(6,2) or DECIMAL(6,2)</color>
+  *<color #ed1c24>Prices have floating point</color>
+  * <color #ed1c24>The length of (6,2) should be sufficient enough as trousers are usually within a price ranger of 0.99 to 9999.99. </color>
+. Order date:
+  *<color #ed1c24>DATE or DATETIME</color>
+  *<color #ed1c24>The type depends on whether we want to safe only the date, but also the time. </color>
+  *<color #ed1c24>Usually in such cases to store only the order-date is enough.</color>
+. Date of delivery:
+  *<color #ed1c24>DATETIME or TIMESTAMP</color>
+  *<color #ed1c24>Regarding delivery quality the criteria punctuality might be one key element. Therefore the storage of the delivery-time is compulsory.</color>
+. organic or not:
+  *<color #ed1c24>BOOLEAN</color>
+  *<color #ed1c24>As there a only two possibilites to store a boolean data-type is the correct data-type. </color>
+. Usage category with only one character:
+  * <color #ed1c24>CHAR</color>
+  * <color #ed1c24>As long as there is only one character to be stored the CHAR-type will work. </color>
+  * <color #ed1c24>Technically the CHAR-types allows all letters, digits (as letters) and special characters.</color>
+===== Vocabulary =====
+^ English ^ German ^
+| to give reason for | begründen |
+| at the most | höchstens |
+| stock amount | Lagermenge |
+| to float | fliessen |
+| sufficient | ausreichend |
+| regarding | bezüglich |
+| might be | möglicherweise |
+| technically | im Prinzip, eigentlich |
+----
+[[https://creativecommons.org/licenses/by-nc-sa/4.0/|{{https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png}}]] Volkan Demir