LU04.A01 - Choose data-types

• Work type: Peer
• Means of aid: only teaching materials, no websearch, no use of ai.
• Timeframe: 10 Minutes
• Expected result: A Word/PDF file with selected data types and an explanation of why.

All computer applications manage in the background one way or another. It is therefore pivotal to store this information efficiently, which leads us to databases.

Which datatype would you use to store the following information? Give reason for your decision.

1. product-title like trousers up to 50 characters:
2. product-description up to 255 characters:
3. stock amount:
4. price of each piece:
5. order date:
6. date of delivery:
7. organic or not:
8. usage category with only one character:

Lösung

Volkan Demir