Data Management Flashcards

1
Q

General approaches to data management

A

Flat-file approach

Database approach

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Problems in a flat-file environment

A
Data redundancy (data storage, data updating, currency of information)
Task-data dependency
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Database approach

A

Centralizes data into a common database that is shared by other users

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Elements of a database environment

A
  1. Database management systems
  2. Users
  3. Database administrator
  4. Physical database
  5. Database Management Systems Models
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Features of DBMS

A

Program development
Backup and recovery
Database usage reporting
Database access

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Three Software Modules for Database Access

A

Data definition language
Data manipulation language
Query language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Three Views of Data Definition Language

A

Internal view
Conceptual view
External view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Functions of a Database Administrator

A
Database planning
Database design
Database implementation
Operations and maintenance
Database growth and change
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Two Fundamental Components of the Data Structure

A

Data Organization

Data Access Methods

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Data Attribute/Field

A

Single item of data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Entity

A

Database representation of an individual resource, event, or agent about which we choose to collect data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Record Type

A

Data attributes that logically define an entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Database

A

Set of record types

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Associations

A

Relationship of record types

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Three Types of Associations

A

One-to-One
One-to-Many
Many-to-Many

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Three Common DBMS Models

A

Hierarchical
Network
Relational

17
Q

Two Kinds of Databases

A

Centralized

Decentralized

18
Q

Two Kinds of Distributed Databases

A

Partitioned

Replicated

19
Q

Factors Considered in Solving a Deadlock

A

Resources invested in the transaction
Transaction’s stage of completion
Number of deadlocks associated with the transaction

20
Q

Database Concurrence

A

Presence of complete and accurate data at all user sites

21
Q

Categories of Controls Over Data Management Systems

A

Access controls

Backup controls

22
Q

Risks of Access Controls

A

Corruption of data
Theft of data
Misuse of data
Destruction of data

23
Q

Examples of Access Controls

A
User views
Database authorization table (or Access control list)
User defined procedures
Data encryption
Biometric devices
Inference control
24
Q

Backup and Recovery Features in A Database Environment

A

Database backup
Transaction log
Checkpoints
Recovery module