[SA] Information Management - The Database Environment and Development Process

Question Type: Short Answer

An organized collection of logically related data.

Database

Question Type: Short Answer

Are stored representations of meaningful objects and events.

Data

Question Type: Short Answer

Examples of these type of data are numbers, textures, and dates.

Structured Data

Question Type: Short Answer

Examples of these type of data are images, video, and documents.

Unstructured Data

Question Type: Short Answer

Are data process to increase knowledge in the person using the data.

Information

Question Type: Short Answer

These are data that describes the properties and context of user data.

Metadata

Question Type: Short Answer

A disadvantage of file processing wherein all programs maintain metadata for each file they use.

Program-Data Dependence

Question Type: Short Answer

A disadvantage of file processing wherein different systems/programs have separate copies of the same data.

Duplication of Data

Question Type: Short Answer

A disadvantage of file processing wherein there is no centralized control of data.

Limited Data Sharing

Question Type: Short Answer

A disadvantage of file processing wherein programmers must design their own file formats.

Length Development Times

Question Type: Short Answer

A disadvantage of file processing wherein it uses 80% of the information systems budget.

Excessive Program Maintenance

Question Type: Short Answer

What does DBMS stand for?

Database Management System

Question Type: Short Answer

A software system that is used to create, maintain, and provide controlled access to user databases.

Database Management System

Question Type: Short Answer

An element of data models wherein it captures nature and relationship of data.

Graphical System

Question Type: Short Answer

An element of data models wherein it encompasses high-level entities and relationships for the organization.

Enterprise Data model

Question Type: Short Answer

An element of data models wherein it provides a more detailed view, matching data structure in database or data warehouse.

Project Data Model

Question Type: Short Answer

A noun form describing a person, place, object, event, or concept, composed of attributes.

Entities

Question Type: Short Answer

An element of the database approach that exists between entities and is often one-to-many or many-to-many.

Relationships

Question Type: Short Answer

An element of the database approach involving tables representing entities and primary/foreign keys representing relationships.

Relational Databases

Question Type: Short Answer

Is computer-aided software engieering.

CASE Tools

Question Type: Short Answer

What does CASE in CASE tools refer to?

Computer-aided Software Engineering

Question Type: Short Answer

A centralized storehouse of metadata.

Repository

Question Type: Short Answer

A software for managing the database.

Database Management System

Question Type: Short Answer

The storehouse of the data.

Database

Question Type: Short Answer

These are software that use data.

Application Programs

Question Type: Short Answer

These are text and graphical displays to users.

User Interface

Question Type: Short Answer

These are personnel responsible for maintaining the database.

Data/Database Administrators

Question Type: Short Answer

These are personnel responsible for designing databases and software.

System Developers

Question Type: Short Answer

These are people who use the applications and databases.

End Users

Question Type: Short Answer

What does SDLC stand for?

System Development life Cycle

Question Type: Short Answer

What does RAD stand for?

Rapid Application Development

Question Type: Short Answer

A planned undertaking of related activities to reach an objective that has a beginning and an end.

Project

Question Type: Short Answer

What does ERP stand for?

Enterprise Resource Planning