Leson 1 Flashcards

(32 cards)

1
Q

Is a shared, integrated computer structure that houses a collection of the end-user data and metadata

A

Database

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

Is a systematic collection of data which support electronic storage and manipulation of data.

A

Database

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

Is a collection of programs that manages the database structure and controls access to the data stored in the database.

A

Database Management System

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

Serves as the intermediary between the user and the database.

A

DBMS

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

Advantages of DBMS

Improved _______ sharing
Improved _______ security
Better data _______
Minimized data _______
Improved data _______
Improved decision _______
Increased end-user _______

A

Advantages of DBMS

Improved data sharing
Improved data security
Better data integration
Minimized data inconsistency
Improved data access
Improved decision making
Increased end-user productivity

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

A type of database that supports only one user at a time. In other words, if user A is using the database, users B and C must wait until user A is done.

A

Single-user Database

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

A single-user database that runs on a personal computer is called a

A

Desktop Database

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

A type of database that supports multiple users at the same time.

A

Multiuser Database

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

– A type of database that supports a relatively small number (usually fewer than 50) of users or a specific department within an organization.

A

Workgroup Database

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

A type of database that is used by the entire organization and supports many user (more than 50, usually hundreds) across many departments.

A

Enterprise Database

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

A type of database that supports data located at a single site

A

Centralized Database

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

A type of database that supports data distributed across several different sites.

A

Distributed Database

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

A database that is created and maintained using cloud services, such as Microsoft Azure or Amazon AWS.

A

Cloud Database

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

A database that contains a wide variety of data used in multiple disciplines.

A

General-purpose Database

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

A type of database that contains data focused on specific subject area.

A

Discipline-specific Database

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

A type of database designed primarily to support a company’s day-to-day operations.

A

Operational Database

17
Q

A type of database focused primarily on storing historical data and business metrics used for tactical or strategic decision making.

A

Analytical Database

18
Q

refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data. A database that meets all user requirements does not just happen; its structure must be designed carefully.

A

Database Design

19
Q

Problems associated with File Systems:

Lengthy _______ times
Difficulty of getting quick _______
Complex system _______
Lack of _______ and limited _______ sharing
Extensive _______

A

Problems associated with File Systems:

Lengthy development times
Difficulty of getting quick answers
Complex system administration
Lack of security and limited data sharing
Extensive programming

20
Q

– is a data abnormality in which inconsistent changes have been made to a database. It develops when not all the required changes in the redundant data are made successfully.

A

Data Anomalies

21
Q

File System Data Processing Issue

Structural ___________
Structural ____________
_______ Dependence
_______ Independence
Data ____________
Data _________

A

File System Data Processing Issue

Structural Dependence
Structural Independence
Data Dependence
Data Independence
Data Redundancy
Data Anomalies

22
Q

Uncontrolled data redundancy sets the stage for the following:

Poor data _______
Data _______
Data-entry _______
Data _______ problems

A

Uncontrolled data redundancy sets the stage for the following:

Poor data security
Data inconsistency
Data-entry errors
Data integrity problems

23
Q

A data characteristic in which a change in the database schema affects data access, thus requiring changes in all access programs.

A

Structural Dependence

24
Q

A data characteristic in which changes in the database schema do not affect data access.

A

Structural Independence

25
A data condition in which data representation and manipulation are dependent on the physical data storage characteristics.
Data Dependence
26
A condition in which data access is unaffected by changes in the physical data storage characteristics.
Data Independence –
27
It exists when the same data is stored unnecessarily at different places. The file system’s structure makes it difficult to combine data from multiple sources, and its lack of security renders the file system vulnerable to security breaches.
Data Redundancy
28
having multiple copies of data increase the chances for a copy of the data to be susceptible to unauthorized access.
Poor data security
29
exists when different and conflicting versions for the same data appear in different places.
Data inconsistency
30
is the overall accuracy, completeness, and consistency of data.
Data integrity
31
are most likely to occur when complex entries are made in several different files or recur frequently in one or more files.
Data-entry errors
32
Data anomalies in database can happen in the following:
Updating Inserting Deleting