The Database Environment

Question 1

What ANSI-SPARC Architecture shows a view of the entire database?

Answer 1

Conceptual view

Question 2

What is the principle behind the ANSI-SPARC architecture?

Answer 2

Encapsulation

Question 3

Identify the users in the development portion of the database environment?

Answer 3

System analyst, database architect, application developer

Question 4

Identify the users in the deployment portion of the database environment.

Answer 4

System administrator, database adminstrator

Question 5

Give at least 1 con of using the DBMS

Answer 5

Cost, frequent updates & maintenance, requires database administrators

Question 6

What are the 3 sections in the external view of the ANSI-SPARC architecture?

Answer 6

Registrar, Department chair, Faculty

Question 7

This users job is to identify requirements as the basis of the database system

Answer 7

System analyst

Question 8

This users job is to design the database structure

Answer 8

Database architect/designer

Question 9

This users job is to program the applications use & functionality

Answer 9

Application developer

Question 10

The users job is to manage the database & other database infrastructures

Answer 10

System administrator

Question 11

This users job is to manage the database management system & the database itself

Answer 11

Database administrator

Question 12

This solution was built to solve the file-dependency problem experienced with file-based systems

Answer 12

ANSI-SPARC Architecture

Question 13

What does the internal view of the database show?

Answer 13

The internal view of the entire database

Question 14

This is where the registrar view, department chair view, and faculty view can be seen.

Answer 14

External view