Question 1

Explain the significance of using N:M and not N:N to describe many-to-many entity relationships.

Accepted Answer

The N:M (many-to-many) relationship is n

Question 2

Pure database data are valuable, but they are not pertinent or useful in raw form.

Accepted Answer

A) True 
 B)False

Question 3

A ________ is a software program; while a ________ is a collection of tables of data, relationships, and metadata.

Accepted Answer

A)  database; DBMS 
B)  DBMS; database 
C)  spreadsheet; DBMS 
D)  database; spreadsheet 
A)  database; DBMS 
B)  DBMS; database 
C)  spreadsheet; DBMS 
D)  database; spreadsheet

Question 4

Structured Query Language is an international standard language for processing a database.

Accepted Answer

A) True 
 B)False

Question 5

A(n)________ is a self-describing collection of integrated records.

Accepted Answer

A)  identifier 
B)  key 
C)  entity 
D)  database 
A)  identifier 
B)  key 
C)  entity 
D)  database

Question 6

An important use of database application programs is to ________.

Accepted Answer

A)  control a particular computer's resources 
B)  enhance the computer's performance 
C)  generate data that describe data 
D)  enable database processing over the Internet 
A)  control a particular computer's resources 
B)  enhance the computer's performance 
C)  generate data that describe data 
D)  enable database processing over the Internet

Question 7

A database is considered self-describing because ________.

Accepted Answer

A)  all the users' data are in one place 
B)  it contains data about the data 
C)  it contains a listing of all the programs that use it 
D)  it does not allow data duplication 
A)  all the users' data are in one place 
B)  it contains data about the data 
C)  it contains a listing of all the programs that use it 
D)  it does not allow data duplication

Question 8

Databases that are organized in the form of tables and represent interconnections using foreign keys are called ________.

Accepted Answer

A)  object databases 
B)  network databases 
C)  relational databases 
D)  hierarchical databases 
A)  object databases 
B)  network databases 
C)  relational databases 
D)  hierarchical databases

Question 9

Why are database application programs needed?

Accepted Answer

Forms, reports, and queries work well fo

Question 10

What is a database management system (DBMS)? How does it differ from a database?

Accepted Answer

A database management system (DBMS) is a

Question 11

Explain the different database administration tasks associated with the adaptation of databases.

Accepted Answer

For important databases, most organizati

Question 12

A data integrity problem is created due to inconsistent data in the database.

Accepted Answer

A) True 
 B)False

Question 13

A DBMS is a software program; a database is a collection of tables of data, relationships, and metadata.

Accepted Answer

A) True 
 B)False

Question 14

Explain the differences between Enterprise DBMS and Personal DBMS.

Accepted Answer

DBMS products fall into two broad catego

Question 15

The general goal of normalization is to construct tables such that every table has a single topic or theme.

Accepted Answer

A) True 
 B)False

Question 16

With the help of a diagram, explain the difference between one-to-many and many-to-one relationships.

Accepted Answer

Consider an entity-relationship diagram

Question 17

Unified Modeling Language (UML)is the most commonly used tool for data modeling.

Accepted Answer

A) True 
 B)False

Question 18

The easiest time to change the database structure is during the data modeling stage.

Accepted Answer

A) True 
 B)False

Question 19

SQL can be used to create databases and database structures.

Accepted Answer

A) True 
 B)False

Question 20

Explain the database administration tasks associated with the development of databases.

Accepted Answer

For important databases, most organizati

Explain the significance of using N:M and not N:N to describe many-to-many entity relationships.

Pure database data are valuable, but they are not pertinent or useful in raw form.

A is a software program; while a is a collection of tables of data, relationships, and metadata.

Structured Query Language is an international standard language for processing a database.

A(n)________ is a self-describing collection of integrated records.

An important use of database application programs is to ________.

A database is considered self-describing because ________.

Databases that are organized in the form of tables and represent interconnections using foreign keys are called ________.

Why are database application programs needed?

What is a database management system (DBMS)? How does it differ from a database?

Explain the different database administration tasks associated with the adaptation of databases.

A data integrity problem is created due to inconsistent data in the database.

A DBMS is a software program; a database is a collection of tables of data, relationships, and metadata.

Explain the differences between Enterprise DBMS and Personal DBMS.

The general goal of normalization is to construct tables such that every table has a single topic or theme.

With the help of a diagram, explain the difference between one-to-many and many-to-one relationships.

Unified Modeling Language (UML)is the most commonly used tool for data modeling.

The easiest time to change the database structure is during the data modeling stage.

SQL can be used to create databases and database structures.

Explain the database administration tasks associated with the development of databases.

Introduction to MIS

Business Processes, Information Systems, and Information

Hardware, Software, and Networks

Using IS to Improve Processes

Supporting Processes with ERP Systems

Supporting the Procurement Process with SAP

Supporting the Sales Process with SAP

Collaboration Processes and Information Systems

The Impact of Web 2.0 and Social Media on Business Processes

Business Intelligence

MIS Management Processes: Process Management, Systems Development, and Security

Filters

Exam 4: Database Processing

Explain the significance of using N:M and not N:N to describe many-to-many entity relationships.

Pure database data are valuable, but they are not pertinent or useful in raw form.

A ________ is a software program; while a ________ is a collection of tables of data, relationships, and metadata.

Structured Query Language is an international standard language for processing a database.

A(n)________ is a self-describing collection of integrated records.

An important use of database application programs is to ________.

A database is considered self-describing because ________.

Databases that are organized in the form of tables and represent interconnections using foreign keys are called ________.

Why are database application programs needed?

What is a database management system (DBMS)? How does it differ from a database?

Explain the different database administration tasks associated with the adaptation of databases.

A data integrity problem is created due to inconsistent data in the database.

A DBMS is a software program; a database is a collection of tables of data, relationships, and metadata.

Explain the differences between Enterprise DBMS and Personal DBMS.

The general goal of normalization is to construct tables such that every table has a single topic or theme.

With the help of a diagram, explain the difference between one-to-many and many-to-one relationships.

Unified Modeling Language (UML)is the most commonly used tool for data modeling.

The easiest time to change the database structure is during the data modeling stage.

SQL can be used to create databases and database structures.

Explain the database administration tasks associated with the development of databases.

Introduction to MIS

Business Processes, Information Systems, and Information

Hardware, Software, and Networks

Using IS to Improve Processes

Supporting Processes with ERP Systems

Supporting the Procurement Process with SAP

Supporting the Sales Process with SAP

Collaboration Processes and Information Systems

The Impact of Web 2.0 and Social Media on Business Processes

Business Intelligence

MIS Management Processes: Process Management, Systems Development, and Security

Filters

A is a software program; while a is a collection of tables of data, relationships, and metadata.