Chapter 1

Question 1

Persistent property for database?

Answer 1

Mean that data reside on table storage. Relevance of intended operational usage: only potentially relevant data are stored
Lasts a long time (not transient)

Question 2

Interrelated property for databases?

Answer 2

Separate data units can be connected to provide a broader view
Entity: cluster of data about a topic
Relationship: connection among entities

Question 3

Shared property for databases?

Answer 3

A database can have multiple users and uses.

A database as a common information repository and information exchange platform

Question 4

What is a DBMS?

Answer 4

Collection of components that support data acquisition, storage, maintenance, and retrieval (Database Software)
Major parts: enterprise, desktop, embedded DBMS

Question 5

What is SQL?

Answer 5

An industry standard database language that includes statements for database definition, database manipulation, and database control

Question 6

Describe the difference between a procedural and a nonprocedural language. What statements belong in a procedural language but not in a nonprocedural language?

Answer 6

Non-procedural Database language such as SQL allows you to specify the parts of a database to access rather than to code a complex procedure. These languages do not include looping statements.

Question 7

Why is nonprocedural access an important feature of DBMSs?

Answer 7

Nonprocedural access allows users with limited computing skills to submit queries.
Nonprocedural access makes formand report creation possible without extensive coding.

Question 8

What is the connection between nonprocedural access and application development? Can nonprocedural access be used in application development?

Answer 8

Nonprocedural access and application development tools, though convenient and powerful, are sometimes not efficient enough or do not provide the level of control necessary for application development.

Question 9

What is the difference between a form and a report?

Answer 9

Form: formatted document for data entry and display
Report: formatted document for display

Question 10

What is a procedural language interface?

Answer 10

Procedural Language Interface is a method to combine a nonprocedural language such as SQL with a programming language such as Java

Question 11

What is a transaction?

Answer 11

A unit of work that should be processed reliably without interference from other users and without loss of data due to failures

Question 12

What features does a DBMS provide to support transaction processing?

Answer 12

DBMSs ensure that simultaneous users do not interfere with each other and failures do not cause lost work. (Database tuning)

Question 13

What is an enterprise DBMS?

Answer 13

Supporting mission critical information systems

Question 14

What is a desktop DBMS?

Answer 14

For small and end-user databases

Question 15

What is an embedded DBMS?

Answer 15

Resides in a separate system or device such PDA or web browser

Question 16

Data Independence?

Answer 16

A database should have an identity separate from the applications(computer programs, forms, and reports_ that use it. The separate identity allows the database definition to be changed without affecting related applications.

Question 17

What is the purpose of the mappings in the Three Schema Architecture? Is the user or DBMS responsible for using the mappings?

Answer 17

Mappings describe how schema at a higher level is derived from a schema at a lower level; ensure data independence

Question 18

How does the Three Schema Architecture support data independence?

Answer 18

For compartmentalizing database descriptions in order to achieve data independence

Question 19

What is the state of the cloud computing segment of the DBMS marketplace?

Answer 19

Rapidly evolving

Question 20

What is the relationship between the cloud-based database architecture and other distributed processing architectures for database computing?

Answer 20

Cloud computing provides a new approach without initial product licensing costs and no hosting requirements
Internally, the cloud can use any distributed processing approach although the internal details of the cloud are invisible to organizations using the cloud service

Question 21

What is information resources management?

Answer 21

Focuses on information technology as a tool for processing, distributing, and integrating information throughout an organization

Question 22

What is data governance?

Answer 22

The exercise of decision-making and authority for data-related matters

Question 23

Parallel DBMS

Answer 23

A DBMS capable of utilizing tightly-coupled computing resources

Question 24

Distributed data?

Answer 24

A database in which parts are located at different network sites

Question 25

Parallel DBMS

Answer 25

A DBMS capable of utilizing tightly-coupled computing resources (processors, disks, and memory)

Question 26

What are the responsibilities of data administrators versus database administrators for data governance programs?

Answer 26

Database administrators: a support position that specializes in managing individual databases and DBMS; assist both information systems professionals and functional users
Data administer: a management position that performs planning and policy settling for the data resources of an organization; a management role with responsibilities to plant the development of database and control of usage of data

Question 27

What features of NoSQL database products address the challenges of big data?

Answer 27

NoSQL does not use the traditional relational database model and SQL standard - use simplified database models, less stringent transaction processing models, and distributed processing to reduce bottlenecks for dealing with big data