Chapter 1

Question 1

Analytical Database

Answer 1

Collects and presents analytical information in support of analytical tasks

Question 2

Database

Answer 2

Structured collection of related data stored on a computer medium

Question 3

Database Management System (DBMS)

Answer 3

Software used for:

• creation of databases
• insertion, storage, retrieval, update, and deletion of the data in the database
• maintenance of databases.

Question 4

Database Metadata

Answer 4

Represents the structure of the database

• database content that is not the data itself (data about the data)
• contains:
  
  • Names of data structures
  • Data types
  • Data descriptions
  • Other information describing the characteristics of the data

Question 5

Database Modeling

Answer 5

Creation of the database model that is implementable by the DBMS software

• Logical database modeling follows conceptual database modeling

Question 6

Direct Interaction

Answer 6

End-user communicating with the database directly through DBMS

Question 7

Indirect Interaction

Answer 7

End-user communicating with the database through front-end applications

Question 8

End-Users (business-users)

Answer 8

Users using a database system to support their tasks and processes

Question 9

Front-End Applications

Answer 9

Provide a mechanism for easy interaction between the users and the DBMS

Question 10

Metadata

Answer 10

Provide a mechanism for easy interaction between the users and the DBMS

Question 11

Requirements Collection, Definition, and Visualization

Answer 11

results in the requirements specifying which data the future database system will hold and in what fashion, and what the capabilities and functionalities of the database system will be

• the collected requirements should be clearly defined and stated in a written document, and then visualized