| Nächste Überarbeitung | Vorhergehende Überarbeitung |
| modul:m290:learningunits:lu02:loesungen:l01 [2024/08/13 13:51] – vdemir | modul:m290:learningunits:lu02:loesungen:l01 [2024/10/02 15:11] (aktuell) – vdemir |
|---|
| ====== LU02.A01 - Solutions to DBS, DBMS and DB ====== | ====== LU03.S01 - Answers: DBS, DBMS and DB ====== |
| | |
| ===== Answers to the control questions ===== | |
| Answer the following questions respectively state the correct solution. | |
| |
| 1. TRUE or FASLE: DBMS = DBS and DB? | 1. TRUE or FASLE: DBMS = DBS and DB? |
| * <color #ed1c24>A database system such as Oralce or MySQL consists of the data, stored in tables, and the database management system, that manages the data. </color> | * <color #ed1c24>A database system such as Oralce or MySQL consists of the data, stored in tables, and the database management system, that manages the data. </color> |
| |
| 3. What is the purpose of the DBMS? Give an example.</color> | 3. What is the purpose of the DBMS? Give an example. |
| * <color #ed1c24>The DBMS is a piece of software that manages the data. </color> | * <color #ed1c24>The DBMS is a piece of software that manages the data. </color> |
| * <color #ed1c24>It consists of pre-preogrammed functions, that help managing the data.</color> | * <color #ed1c24>It consists of pre-preogrammed functions, that help managing the data.</color> |
| |
| 4. What is stored in the DB? How it is stored? Give an example? | 4. What is stored in the DB? How it is stored? Give an example? |
| <color #ed1c24> | |
| * <color #ed1c24>In databases basicly the data is stored in tables that are linked to each other. </color> | * <color #ed1c24>In databases basicly the data is stored in tables that are linked to each other. </color> |
| * <color #ed1c24>This is done to avoid unintentional redundancies within the database.</color> | * <color #ed1c24>This is done to avoid unintentional redundancies within the database.</color> |
| * <color #ed1c24>Each table (entity type: e.g. persons) is composed of columns (attributes: e.g. name, birthdate) and rows (entities: e.g. Max Müller, 12.11.1989) | * <color #ed1c24>Each table (entity type: e.g. persons) is composed of columns (attributes: e.g. name, birthdate) and rows (entities: e.g. Max Müller, 12.11.1989)</color> |
| | |
| |
| ===== Vocabulary ===== | ===== Vocabulary ===== |
| | entity | Einheit, Wesen | | | entity | Einheit, Wesen | |
| |
| | ---- |
| |
| |
| ---- | |
| [[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 |