Intro

Question 1

is the concept of how information relates to other
pieces of information, and how information should be
grouped.

Answer 1

Schema

Question 2

is the concept of the actual information users want to
store in the database. You can only store data in structures
which the schema provides, so we must ensure that the
schema is correct.

Answer 2

Data

Question 3

The main schema “container” concept is called

Answer 3

Table

Question 4

The architecture for DBMSs is divided into three general
levels:

Answer 4

1. external
2. conceptual
3. internal

Question 5

) is responsible for overall
control of the database system. Responsibilities include:
„ deciding the information content of the database, i.e.
identifying the entities of interest to the enterprise and the
information to be recorded about those entities. This is
defined by writing the conceptual schema using the DDL
„ deciding the storage structure and access strategy, i.e. how
the data is to be represented by writing the storage
structure definition. The associated internal/conceptual
schema must also be specified using the DDL

Answer 5

database administrator (DBA)