modul:m290:learningunits:lu04:aufgaben:a01

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Nächste Überarbeitung		 Vorhergehende Überarbeitung
modul:m290:learningunits:lu04:aufgaben:a01 [2024/08/30 13:40] – angelegt vdemirmodul:m290:learningunits:lu04:aufgaben:a01 [2024/10/17 12:35] (aktuell) – vdemir
Zeile 1: Zeile 1:
-====== LU04.A01 - SQL : DQL commands======+====== LU06.A01 - SQL-DQL: Select from one table ======
  
 ===== Requirements  ===== ===== Requirements  =====
   * Work type: individual   * Work type: individual
-  * Means of aid: only teaching materials, no websearch, no use of ai. +  * Timeframe: 15 Minutes 
-  * Timeframe: 5 Minutes +  * Means of aid:  
-  * Expected result: Word/PDF file with the answers of the control questions+      * only teaching materials, no websearch, no use of ai. 
 +      * [[https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_columns | W3Schools | SQL Editor]] 
 +  * Expected result: Semsntically and syntactically correct SQL statements according to the requirements of the case studies. 
  
-===== Introduction  ===== +===== Case studies / Assignments ===== 
-You have learnt some details about databases, such as the terms DBS, DBMS and DB. Please answer the following control questions, which are supposed to help you understand the subject matter.+Go to the W3-Schools SQL Editore and develop DQL commands to the following requirements
  
-===== Control questions ===== +===== Assignments =====
-Answer the following questions respectively state the correct solution.+
  
-  - TRUE or FASLE: DBMS = DBS and DB? +  * a) Create a address-list of the customers with the columns in this order: CustomerName, Adress, PostalCode, Country, ordered by the the Country ascending. 
-  - TRUE or FASLE: DBS =  DBMS and DB! +  * b) Generate a list with ProductNames, Price and SupplierIDs within a price range of 20 and 45, sorted the Price and SupplierID, both ascending. 
-  - What is the purpose of the DBMS? Give an example? +  * c) Find all employees who graduated from a university. The relevant information is hidden in the table Employees, within the colums Notes.
-  - What is stored in the DB? How it is stored? +
  
 ===== Solution ===== ===== Solution =====
-[[modul:m290:learningunits:lu02:loesungen:l01|Lösung]]+[[modul:m290:learningunits:lu04:loesungen:l01|Lösung]]
  
  
Zeile 25: Zeile 25:
 ^ English ^ German ^  ^ English ^ German ^ 
 | respectively | beziehungsweise| | respectively | beziehungsweise|
 +| assignment | Auftrag |
  
  
 ---- ----
 [[https://creativecommons.org/licenses/by-nc-sa/4.0/|{{https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png}}]] Volkan Demir [[https://creativecommons.org/licenses/by-nc-sa/4.0/|{{https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png}}]] Volkan Demir
  • modul/m290/learningunits/lu04/aufgaben/a01.1725018044.txt.gz
  • Zuletzt geändert: 2024/08/30 13:40
  • von vdemir