Question 1

Users are the final judges as to what data the database should contain and how the records in that database should be related to one another.

Accepted Answer

A) True 
 B)False

Question 2

A database must have only one application, though the application can have one or more users.

Accepted Answer

A) True 
 B)False

Question 3

Describe a DBMS and its functions.List some of the popular DBMS softwares.

Accepted Answer

A database management system (DBMS)is a

Question 4

Identify the first step in transforming a data model into a relational database design.

Accepted Answer

A) representing the data relationships 
B) normalizing the data and files 
C) creating foreign keys 
D) creating a table for each entity 
A) representing the data relationships 
B) normalizing the data and files 
C) creating foreign keys 
D) creating a table for each entity

Question 5

The rows in a database are called ________.

Accepted Answer

A) records 
B) tables 
C) files 
D) fields 
A) records 
B) tables 
C) files 
D) fields

Question 6

One of the functions of a DBMS is to provide tools to assist in the administration of the database.

Accepted Answer

A) True 
 B)False

Question 7

Every table in a normalized database has ________.

Accepted Answer

A) duplicated data model 
B) single theme 
C) maximum cardinality 
D) specialized query format 
A) duplicated data model 
B) single theme 
C) maximum cardinality 
D) specialized query format

Question 8

The tables that appear in a database are known as ________.

Accepted Answer

A) records 
B) files 
C) fields 
D) applications 
A) records 
B) files 
C) fields 
D) applications

Question 9

What are the steps involved in transforming a data model into a relational database design?

Accepted Answer

First, the database designer creates a t

Question 10

Identify the type of task that a database administrator is performing when validating the data model to be used in a database management system.

Accepted Answer

A) development 
B) adaptation 
C) recovery 
D) operation 
A) development 
B) adaptation 
C) recovery 
D) operation

Question 11

The purpose of a database is to keep track of things that involve a single theme.

Accepted Answer

A) True 
 B)False

Question 12

In an E-R diagram, a(n)________ on a line means that at least one entity of that type is required.

Accepted Answer

A) small oval 
B) vertical bar 
C) arrow 
D) triangular block 
A) small oval 
B) vertical bar 
C) arrow 
D) triangular block

Question 13

The accuracy of a database design is independent of the corresponding data model.

Accepted Answer

A) True 
 B)False

Question 14

DBMS is used to set up security systems involving user accounts, passwords, permissions, and limits for processing the database.

Accepted Answer

A) True 
 B)False

Question 15

One of the developmental tasks of a database administrator is to create a system to record and manage the resolution of problems.

Accepted Answer

A) True 
 B)False

Question 16

Explain the role of users in the database development process.

Accepted Answer

A database is a model of how the users v

Question 17

How does normalization resolve the data integrity problem?

Accepted Answer

Database design is the process of conver

Question 18

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year.After accessing the DBMS, she should type the keyword into a ________ form to obtain the information that she wants.

Accepted Answer

A) report 
B) reference 
C) data entry 
D) query 
A) report 
B) reference 
C) data entry 
D) query

Question 19

A crow's foot notation would indicate the minimum cardinality of a relationship.

Accepted Answer

A) True 
 B)False

Question 20

Explain the different types of DBMS products.

Accepted Answer

DBMS products fall into two broad catego

Users are the final judges as to what data the database should contain and how the records in that database should be related to one another.

A database must have only one application, though the application can have one or more users.

Describe a DBMS and its functions.List some of the popular DBMS softwares.

Identify the first step in transforming a data model into a relational database design.

The rows in a database are called ________.

One of the functions of a DBMS is to provide tools to assist in the administration of the database.

Every table in a normalized database has ________.

The tables that appear in a database are known as ________.

What are the steps involved in transforming a data model into a relational database design?

Identify the type of task that a database administrator is performing when validating the data model to be used in a database management system.

The purpose of a database is to keep track of things that involve a single theme.

In an E-R diagram, a(n)________ on a line means that at least one entity of that type is required.

The accuracy of a database design is independent of the corresponding data model.

DBMS is used to set up security systems involving user accounts, passwords, permissions, and limits for processing the database.

One of the developmental tasks of a database administrator is to create a system to record and manage the resolution of problems.

Explain the role of users in the database development process.

How does normalization resolve the data integrity problem?

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year.After accessing the DBMS, she should type the keyword into a ________ form to obtain the information that she wants.

A crow's foot notation would indicate the minimum cardinality of a relationship.

Explain the different types of DBMS products.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Data Communication and the Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Development Processes

Information Systems Management

Information Security Management

The International Dimension

Filters

Exam 5: Database Processing

Users are the final judges as to what data the database should contain and how the records in that database should be related to one another.

A database must have only one application, though the application can have one or more users.

Describe a DBMS and its functions.List some of the popular DBMS softwares.

Identify the first step in transforming a data model into a relational database design.

The rows in a database are called ________.

One of the functions of a DBMS is to provide tools to assist in the administration of the database.

Every table in a normalized database has ________.

The tables that appear in a database are known as ________.

What are the steps involved in transforming a data model into a relational database design?

Identify the type of task that a database administrator is performing when validating the data model to be used in a database management system.

The purpose of a database is to keep track of things that involve a single theme.

In an E-R diagram, a(n)________ on a line means that at least one entity of that type is required.

The accuracy of a database design is independent of the corresponding data model.

DBMS is used to set up security systems involving user accounts, passwords, permissions, and limits for processing the database.

One of the developmental tasks of a database administrator is to create a system to record and manage the resolution of problems.

Explain the role of users in the database development process.

How does normalization resolve the data integrity problem?

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year.After accessing the DBMS, she should type the keyword into a ________ form to obtain the information that she wants.

A crow's foot notation would indicate the minimum cardinality of a relationship.

Explain the different types of DBMS products.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Data Communication and the Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Development Processes

Information Systems Management

Information Security Management

The International Dimension

Filters