CS401A's Prelims: Info Management Module 01

Question 1

Database Systems

• Raw facts, or facts that have not yet been processed to reveal their meaning to the end user.

Answer 1

Data

Question 2

Database Systems

— The result of processing raw data to reveal its meaning.

Answer 2

Information

Question 3

Database Systems

consists of transformed data and facilities decision making.

Answer 3

Information

Question 4

Database Systems

is a shared, integrated computer structure

Answer 4

Database

Question 5

Database Systems

Database is a shared, integrated computer structure that houses a collection of the following:

Answer 5

• End-user data…
• Metadata, …

Question 6

Database Systems

— that is, raw facts of interest to the end user.

Answer 6

End-user data

Question 7

Database Systems

or data about data,

Answer 7

• Metadata,

Question 8

Database Systems

through which the end-user data is integrated and managed.

(Coronel and Morris, 2017, p. 6).

Answer 8

• Metadata,

Question 9

Database Systems

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

Answer 9

DBMS (Coronel and Morris, 2017)
A Database Management System (DBMS)

Question 10

Database Systems

Roles and Advantages of
serves as the intermediary between the user and the database.

Answer 10

DBMS (Coronel and Morris, 2017)
The DBMS

Question 11

Database Systems

Roles and Advantages of
The database structure itself is stored as a collection of files, and the only way to access the data in those files is through the

Answer 11

DBMS (Coronel and Morris, 2017)
DBMS.

Question 12

Database Systems

Advantages of
- The DBMS serves as the intermediary between the user and the database.

Answer 12

Roles and Advantages of DBMS (Coronel and Morris, 2017)
DBMS:
* Improved data sharing

Question 13

Database Systems

Advantages of
- The database structure itself is stored as a collection of files, and the only way to access the data in those files is through the DBMS.

Answer 13

Roles and Advantages of DBMS (Coronel and Morris, 2017)
DBMS:
* Improved data sharing

Question 14

Database Systems

Advantages of
- The more users access the data, the greater the risks of data security breaches.

Answer 14

Roles and Advantages of DBMS (Coronel and Morris, 2017)
DBMS:
* Improved data security

Question 15

Database Systems

Advantages of
A DBMS provides a framework for better enforcement of data privacy and security policies.

Answer 15

Roles and Advantages of DBMS (Coronel and Morris, 2017)
DBMS:
* Improved data security

Question 16

Database Systems

Advantages of
Corporations invest considerable amounts of time, effort, and money to ensure that corporate data is used properly.

Answer 16

Roles and Advantages of DBMS (Coronel and Morris, 2017)
DBMS:
* Improved data security

Question 17

Database Systems

Advantages of
- Wider access to well-managed data promotes an integrated view of the organization’s
operations and a clearer view of the big picture.

Answer 17

Roles and Advantages of DBMS (Coronel and Morris, 2017)
DBMS:
* Better data integration

Question 18

Database Systems

Advantages of
- Data inconsistency exists when different versions of the same data appear in different places.

Answer 18

Roles and Advantages of DBMS (Coronel and Morris, 2017)
DBMS:
* Minimized data inconsistency

Question 19

Database Systems

Advantages of
- The DBMS makes it possible to produce quick answers to ad hoc queries.

Answer 19

Roles and Advantages of DBMS (Coronel and Morris, 2017)
DBMS:
* Improved data access

Question 20

Database Systems

Advantages of
From a database perspective,
is a specific request issued to the DBMS for data manipulation

Answer 20

Roles and Advantages of DBMS (Coronel and Morris, 2017)
DBMS:
* Improved data access
a query

Question 21

Database Systems

Advantages of
- Better-managed data and improved data access make it possible to generate better-
quality information, on which better decisions are based.

Answer 21

Roles and Advantages of DBMS (Coronel and Morris, 2017)
DBMS:
* Improved decision making

Question 22

Database Systems

Advantages of
- The availability of data, combined with the tools that transform data into usable information, empowers end users to make quick, informed decisions that can make the difference between success and failure in the global economy.

Answer 22

Roles and Advantages of DBMS (Coronel and Morris, 2017)
DBMS:
* * Increased end-user productivity

Question 23

Database Systems

Types of
can be used to build many different types of databases.

Answer 23

Databases
Database Management System (DBMS)

Question 24

Database Systems

Types of
The number of \_\_\_\_\_ determines whether the \_\_\_\_\_\_\_\_ is classified as a single \_\_\_\_ or multi\_\_\_\_.

Answer 24

Databases
The number of users determines whether the database is classified as a \_\_\_\_\_\_ \_\_\_\_ or \_\_\_\_\_\_\_\_\_.

Question 25

# **Database Systems** Types of Databases:

Answer 25

**Types of Databases** * **Single-user database** * **Desktop database** * **Multiuser database** * **Workgroup database** * **Enterprise database** * **Centralized database** * **Distributed database** * **Cloud database** * **General-purpose database** * **Discipline-specific database** * **Operational database** * **Analytical database**

Question 26

# **Database Systems** — A type of database that supports only one user at a time.

Answer 26

**Types of Databases** * **Single-user database**

Question 27

# **Database Systems** — Single user database that runs on personal computer.

Answer 27

**Types of Databases** * **Desktop database**

Question 28

# **Database Systems** — A type of database that supports multiple users at the same time.

Answer 28

**Types of Databases** * **Multiuser database**

Question 29

# **Database Systems** — A type of database that supports a relatively small number of users or a specific department within an organization.

Answer 29

**Types of Databases** * **Workgroup database**

Question 30

# **Database Systems** — A type of database that is used by the entire organization and supports many users across many departments.

Answer 30

**Types of Databases** * **Enterprise database**

Question 31

# **Database Systems** — A type of database that supports data located at a single site.

Answer 31

**Types of Databases** * **Centralized database**

Question 32

# **Database Systems** — A type of database that supports data distributed across several different sites.

Answer 32

**Types of Databases** * **Distributed database**

Question 33

# **Database Systems** — A database that is created and maintained using cloud services, such as Microsoft Azure or Amazon AWS.

Answer 33

**Types of Databases** * **Cloud database**

Question 34

# **Database Systems** — A database that contains a wide variety of data used in multiple disciplines.

Answer 34

**Types of Databases** * **General-purpose database**

Question 35

# **Database Systems** — A type of database that contains data focused on specific subject areas.

Answer 35

**Types of Databases** * **Discipline-specific database**

Question 36

# **Database Systems** — A type of database designed primarily to support a company's day-to-day operations.

Answer 36

**Types of Databases** * **Operational database**

Question 37

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

Answer 37

**Types of Databases** * **Analytical database**

Question 38

# **Database Systems** refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data.

Answer 38

**Importance of Database Design** **Database Design**

Question 39

# **Database Systems** A database that meets all user requirements does not just happen; its structure must be designed carefully.

Answer 39

**Importance of Database Design** **Database Design**

Question 40

# **Database Systems** **Importance of Database Design** Oftentimes the database design does not get the attention it deserves. This can occur for numerous reasons such as:

Answer 40

* Insufficient specifications and/or poor logical data modeling * Not enough time in the development schedule * Too many changes occuring throughout the development cycle * Database design assigned to, or performed by novices

Question 41

# **Database Systems** **Importance of Database Design** The first step in constructing a physical database should be transforming the logical design using best practices. The transformation consists of the following:

Answer 41

* Transforming entities into tables * Transforming attributes into columns * Transforming domains into data types and constraints * Transforming relationships into primary and foreign keys

Question 42

# **Database Systems** **Importance of Database Design** TRUE || FALSE The first step in constructing a physical database should be skipping the logical design and directly integrating the database structure.

Answer 42

FALSE First step should be transforming logical design using best practices.

Question 43

# **Database Systems** **File System Data Processing Issue (Coronel and Morris, 2017)** TRUE || FALSE Understanding the shortcomings of the file system enables you to understand the development of modern databases.

Answer 43

TRUE

Question 44

# **Database Systems** **File System Data Processing Issue (Coronel and Morris, 2017)** TRUE || FALSE The file system method of organizing and managing data was a flawless improvement over the manual system, and the file system served as useful purpose in data management for over two (2) decades.

Answer 44

FALSE The system was an improvement. Nonetheless, many flaws became evident.

Question 45

# **Database Systems** **File System Data Processing Issue (Coronel and Morris, 2017)** The following problems associated with file systems, whether created by Data Processing (DP) specialist or through a series of spreadsheets, severly challenge the types of information that can be created from the data as well as the accuracy of the information:

Answer 45

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

Question 46

# **Database Systems** **File System Data Processing Issue (Coronel and Morris, 2017)** — The first and most glaring problem with the file system approach is that even the simplest data-retrieval task requires extensive programming.

Answer 46

* **Lengthy development times**

Question 47

# **Database Systems** **File System Data Processing Issue (Coronel and Morris, 2017)** With the older file systems, programmers had to specify what must be done and how to do it.

Answer 47

* **Lengthy development times**

Question 48

# **Database Systems** **File System Data Processing Issue (Coronel and Morris, 2017)** — The need to write programs to produce even the simplest reports makes ad hoc queries impossible.

Answer 48

* **Difficulty of getting quick answers**

Question 49

# **Database Systems** **File System Data Processing Issue (Coronel and Morris, 2017)** — System administration becomes more difficult as the number of files in the system expands.

Answer 49

* **Complex system administration**

Question 50

# **Database Systems** **File System Data Processing Issue (Coronel and Morris, 2017)** Even a simple file system with a few files requires creating and maintaining several file management programs.

Answer 50

* **Complex system administration**

Question 51

# **Database Systems** **File System Data Processing Issue (Coronel and Morris, 2017)** — Another fault of a file system data repository is a `____ __ ________` and `_______ ____ _______`. Data sharing and security are closely related.

Answer 51

* **Lack of security and limited data sharing** — Another `_____` of a `____ ______ ____ __________` is a lack of security and limited data sharing. `____ _______` and `________` are closely related.

Question 52

# **Database Systems** **File System Data Processing Issue (Coronel and Morris, 2017)** Sharing data among multiple geographically dispersed users introduces a log of security risks.

Answer 52

* **Lack of security and limited data sharing**

Question 53

# **Database Systems** **File System Data Processing Issue (Coronel and Morris, 2017)** — Making changes to an existing file structure can be difficult in a file system environment.

Answer 53

* **Extensive programming**

Question 54

# **Database Systems** **File System Data Processing Issue (Coronel and Morris, 2017)** — A data characteristic in which a change in the database schema affects data access, thus requiring changes in all access programs.

Answer 54

**Structural dependence**

Question 55

# **Database Systems** **File System Data Processing Issue (Coronel and Morris, 2017)** — A data characteristic in which changes in the database schema do not affect data access.

Answer 55

**Structural independence**

Question 56

# **Database Systems** **File System Data Processing Issue (Coronel and Morris, 2017)** — A data condition in which data representation and manipulation are dependent on the physical data storage characteristics.

Answer 56

**Data dependence**

Question 57

# **Database Systems** **File System Data Processing Issue (Coronel and Morris, 2017)** — A condition in which data access is unaffected by changes in the physical data storage characteristics.

Answer 57

**Data independence**

Question 58

# **Database Systems** **File System Data Processing Issue (Coronel and Morris, 2017)** — It exists when the same data is stored unnecessarily at different places.

Answer 58

**Data redundancy**

Question 59

# **Database Systems** **File System Data Processing Issue (Coronel and Morris, 2017)** Uncontrolled data redundancy sets the stage for the following:

Answer 59

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

Question 60

# **Database Systems** Uncontrolled data redundancy sets the stage for the following: — Having multiple copies of data increases the chances for a copy of the data to be susceptible to unauthorized access.

Answer 60

**File System Data Processing Issue (Coronel and Morris, 2017)** * **Poor data security**

Question 61

# **Database Systems** Uncontrolled data redundancy sets the stage for the following: exists when different and conflicting versions for the same data appear in different places.

Answer 61

**File System Data Processing Issue (Coronel and Morris, 2017)** — Data inconsistency

Question 62

# **Database Systems** Uncontrolled data redundancy sets the stage for the following: are more likely to occur when complex entries are made in several different files or recur frequently in one or more files.

Answer 62

**File System Data Processing Issue (Coronel and Morris, 2017)** — Data-entry errors

Question 63

# **Database Systems** Occurs when there is inconsistent data is stored. ## Footnote For example, entering a nonexistent sales agent's name and phone number into a Customer file can mislead customers and cause errors in the system.

Answer 63

**File System Data Processing Issue (Coronel and Morris, 2017)** * **Data integrity problems**

Question 64

# **Database Systems** Occurs when there is inconsistent data is stored. — It is possible to enter a nonexistent sales agent's name and phone number into the Customer file, but customers are not likely to be impressed if the insurance agency supplies the name and phone number of an agent who does not exist.

Answer 64

**File System Data Processing Issue (Coronel and Morris, 2017)** Data integrity problems

Question 65

# **Database Systems** in which inconsistent change have been made to a database.

Answer 65

**File System Data Processing Issue (Coronel and Morris, 2017)** **Data Anomalies** * A data abnormality

Question 66

# **Database Systems** develops when not all of the required changes in the redundant data are made successfully.

Answer 66

**File System Data Processing Issue (Coronel and Morris, 2017)** **Data Anomalies** A data anomaly