BSOA 3D -Midterm Exam

A framework for organizing and defining the structure of data.

• data model

• data structure

• Logical schema

• Data dictionary

A description of a particular collection of data, using the a given data model.

• Data model

• schema

• Logical data independence

• Physical data independence

Ability to change the logical structure of data without affecting the external schema.

• Data abstraction

• Data independence

• Physical data model

• Logical data independence

Protection from changes in logical structure of data

• Data abstraction

• Data independence

• Physical data model

• Logical data independence

Responsible to handles security and authorization

• Database administrator

• Database End users

• DB application programmers

• DBMS vendors

Responsible to handles security and authorization

• Database administrator

• Database End users

• DB application programmers

• DBMS vendors

Define and implement database schemas based on system requirements.

• Database administrator

• Database End users

• DB application programmers

• DBMS vendors

An rganization that develops and provides database management systems (DBMS) — the software used to store, organize, and manage data.

• Database administrator

• Database End users

• DB application programmers

• DBMS vendors

a person who uses the data stored in a database to perform specific tasks or make decisions, but does not necessarily design or manage the database system itself.

• Database administrator

• Database End users

• DB application programmers

• DBMS vendors

Used to interact with the database (create, read, update, delete data).

• Software

• Data

• Procedure

• Database Access Language