Database and Information Systems Overview

A collection of flashcards covering key concepts from database processing and information systems.

What is a database?

A set of logically related data stored in a shared repository.

What does DBMS stand for?

Database Management System.

What is a database?

A set of logically related data stored in a shared repository.

What does DBMS stand for?

Database Management System.

What are primary keys?

Columns that identify a unique row in a table.

What is a foreign key?

When a primary key exists in another table and is not unique to that table.

What does SQL stand for?

Structured Query Language.

What are the four main operations of a DBMS?

Read, Insert, Modify, Delete.

What is a business process?

A network of activities that generate value by transforming inputs into outputs.

What do information silos create?

Problems such as data duplication, inconsistency, and disjointed processes.

What is Business Process Reengineering?

Altering and designing business processes to take advantage of new information systems.

What is Enterprise Resource Planning (ERP)?

A suite of applications, a database, and a set of inherent processes for consolidating business operations.

What are the challenges when implementing enterprise systems?

Collective management, requirement gaps, transition problems, employee resistance, and new technology.

What is the Systems Development Life Cycle (SDLC)?

The process of creating and maintaining information systems.

What is a safeguard in information systems security?

Measures taken to block threats from obtaining an asset.

What is a vulnerability?

An opportunity for threats to gain access to individual or organizational assets.

What is a major source of threats in information systems?

Human error, computer crime, and natural disasters.

What type of security loss involves unauthorized data disclosure?

Pretexting, phishing, and spoofing.

What is the goal of information systems security?

To find an appropriate trade-off between the risk of loss and the cost of implementing safeguards.