LU02.L01 - Answers: DBS, DBMS and DB

1. TRUE or FASLE: DBMS = DBS and DB?

• FALSE, the second equation is correctc: DBS = DBMS and DB!

2. TRUE or FASLE: DBS = DBMS and DB!

• TRUE.
• A database system such as Oralce or MySQL consists of the data, stored in tables, and the database management system, that manages the data.

3. What is the purpose of the DBMS? Give an example.</color>

• The DBMS is a piece of software that manages the data.
• It consists of pre-preogrammed functions, that help managing the data.
• Without the DBMS companies such as Zalando or Digitech would no be able to store goods or deliver them to their customers.

4. What is stored in the DB? How it is stored? Give an example?

• In databases basicly the data is stored in tables that are linked to each other.
• This is done to avoid unintentional redundancies within the database.
• 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)

5. Which of the following SQL subtypes does not exist? Explain the meaning of the other terms.

1. DCL = Data Control Language
2. DML = Data Manipulation Language
3. DXL
4. DDL = Data Definition Language
5. DQL = Data Query Language

Volkan Demir