modul:m290:learningunits:lu03:loesungen:l01

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen Revision Vorhergehende Überarbeitung
Nächste Überarbeitung		 Vorhergehende Überarbeitung
modul:m290:learningunits:lu03:loesungen:l01 [2024/08/23 14:43] – angelegt vdemirmodul:m290:learningunits:lu03:loesungen:l01 [2024/10/17 12:32] (aktuell) – vdemir
Zeile 1: Zeile 1:
-====== LU03.L01 - Choose data-types && ======+====== LU04.S01 - Choose data-types ======
  
 Which datatype would you use to store the following information? Give reason for your decision. Which datatype would you use to store the following information? Give reason for your decision.
Zeile 5: Zeile 5:
 1. Product-title like trousers up to 50 characters: 1. Product-title like trousers up to 50 characters:
   *<color #ed1c24>VARCHAR(50)</color>   *<color #ed1c24>VARCHAR(50)</color>
-  *<color #ed1c24>Titles can be at the most 50 characters. A fix length makes no sense in that case. </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>
  
 2. Product-description up to 255 characters: 2. Product-description up to 255 characters:
Zeile 16: Zeile 16:
  
 4. Price of each piece:  4. Price of each piece: 
-  *<color #ed1c24>FLOAT(5,2) or DECIMAL(U5,2)</color>+  *<color #ed1c24>FLOAT(6,2) or DECIMAL(6,2)</color>
   *<color #ed1c24>Prices have floating point</color>   *<color #ed1c24>Prices have floating point</color>
-  * <color #ed1c24>The length of (5,2) should be sufficient enough as trousers are usually within a price ranger of 0.99 to 999.99. </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>
  
 5. Order date:  5. Order date: 
  • modul/m290/learningunits/lu03/loesungen/l01.1724417007.txt.gz
  • Zuletzt geändert: 2024/08/23 14:43
  • von vdemir