Terminology

Question 1

Database

Answer 1

Provides unified logical view of the data and hides the
details of physical storage and access paths

Question 2

data independence

Answer 2

ability to change the structure of data without affecting the applications that use it

Question 3

three layers of a database

Answer 3

1. Physical
2. Conceptual
3. External

Question 4

Physical data independence

Answer 4

helps separate conceptual levels from the
internal/physical levels

you can easily
change the physical storage structures or
devices with no effect on the conceptual
schema

Question 5

Logical data independence

Answer 5

ability
to change the conceptual scheme without
changing external views and programs

ex: Add/modify/delete a new data
attribute, merging two records into one

Question 6

database system

Answer 6

organization of
components that define and regulate the collection, storage,
management, and use of data within a database environment

Question 7

Parts in a DB System (5)

Answer 7

hardware, software, people, procedures, data

Question 8

DBMS

Answer 8

Database Management System

software that helps users create, manage, and access databases

Question 9

Structural Independence

Answer 9

changes in the database structure do not affect DBMS ability to access data

Question 10

Business rules

Answer 10

brief, precise, and unambiguous description of a policy, procedure, or
principle within a specific organization/lab/research area

• what types of data are in an organization/lab/research area, and
• how the data are used

simply, the main and distinguishing
characteristics of the data as viewed by the company/users