Question 1

When using the relational model to represent two tables, one must ________.

Accepted Answer

A)  add a foreign key to one of the tables 
B)  have more than two primary keys in the model 
C)  establish only N:M relationships between the tables 
D)  use metadata instead of foreign keys 
E)  minimize the number of columns in the second table 
A)  add a foreign key to one of the tables 
B)  have more than two primary keys in the model 
C)  establish only N:M relationships between the tables 
D)  use metadata instead of foreign keys 
E)  minimize the number of columns in the second table

Question 2

Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations.

Accepted Answer

A) True 
 B)False

Question 3

A primary key in a database is a ________.

Accepted Answer

A)  group of rows that identifies a unique table or file 
B)  column or group of columns that identifies a unique row in a table 
C)  group of fields or columns that represent metadata 
D)  group of tables or files formed to identify a unique field or row 
E)  group of records that identifies similar attribute 
A)  group of rows that identifies a unique table or file 
B)  column or group of columns that identifies a unique row in a table 
C)  group of fields or columns that represent metadata 
D)  group of tables or files formed to identify a unique field or row 
E)  group of records that identifies similar attribute

Question 4

The crow's-foot notation in an E-R diagram shows the maximum number of entities that can be involved in a relationship.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is the smallest element in a database?

Accepted Answer

A)  field 
B)  record 
C)  byte 
D)  metadata 
E)  zetta 
A)  field 
B)  record 
C)  byte 
D)  metadata 
E)  zetta

Question 6

Columns that are keys to different tables than the ones in which they reside are called ________.

Accepted Answer

A)  attributes 
B)  foreign keys 
C)  primary keys 
D)  internal records 
E)  nonlocal keys 
A)  attributes 
B)  foreign keys 
C)  primary keys 
D)  internal records 
E)  nonlocal keys

Question 7

Explain the functioning of browser applications.

Accepted Answer

Browser applications are thin-client app

Question 8

Which of the following statements correctly describes the relationship between drones and videos in Falcon Security's database?

Accepted Answer

A)  A drone takes many videos; a video is taken by one and only one drone. 
B)  A video is taken by many drones; a drone takes many videos. 
C)  A video is taken by one and only one drone; a drone takes one and only one video. 
D)  A drone takes one and only one video; a video is taken by many drones. 
E)  A video is taken by many drones. 
A)  A drone takes many videos; a video is taken by one and only one drone. 
B)  A video is taken by many drones; a drone takes many videos. 
C)  A video is taken by one and only one drone; a drone takes one and only one video. 
D)  A drone takes one and only one video; a video is taken by many drones. 
E)  A video is taken by many drones.

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

________ is the process of converting a data model into tables, relationships, and data constraints.

Accepted Answer

A)  Database design 
B)  Database querying 
C)  Data mining 
D)  Database aggregation 
E)  Database cross modeling 
A)  Database design 
B)  Database querying 
C)  Data mining 
D)  Database aggregation 
E)  Database cross modeling

Question 11

How does normalization resolve the data integrity problem?

Accepted Answer

Normalization is the process of converti

Question 12

Metadata is/are ________.

Accepted Answer

A)  codes used for server-side processing 
B)  error logs of databases 
C)  data that describes data 
D)  data that are encrypted 
E)  more important data 
A)  codes used for server-side processing 
B)  error logs of databases 
C)  data that describes data 
D)  data that are encrypted 
E)  more important data

Question 13

The rows in a database are also called ________.

Accepted Answer

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

Question 14

Define the symbols and terms used in entity-relationship (E-R) diagrams.

Accepted Answer

Database designers use diagrams called e

Question 15

In a database, when data items are inaccurate and inconsistent with one another, it leads to a(n) ________.

Accepted Answer

A)  data integrity problem 
B)  crow's-foot paradigm 
C)  adaptation conflict 
D)  security problem 
E)  data loopback problem 
A)  data integrity problem 
B)  crow's-foot paradigm 
C)  adaptation conflict 
D)  security problem 
E)  data loopback problem

Question 16

The data integrity problem occurs only if data are duplicated.

Accepted Answer

A) True 
 B)False

Question 17

The accuracy of a database design is not dependent on the corresponding data model.

Accepted Answer

A) True 
 B)False

Question 18

Relational databases represent relationships using ________.

Accepted Answer

A)  foreign keys 
B)  file systems 
C)  metadata 
D)  primary keys 
E)  trees 
A)  foreign keys 
B)  file systems 
C)  metadata 
D)  primary keys 
E)  trees

Question 19

Browser-based applications ________.

Accepted Answer

A)  need to be preinstalled on the users' computers 
B)  run within a corporate network that is protected from the Internet 
C)  eliminate the need to check for data consistency 
D)  are more vulnerable to security threats than are traditional applications 
E)  do not need to be encrypted 
A)  need to be preinstalled on the users' computers 
B)  run within a corporate network that is protected from the Internet 
C)  eliminate the need to check for data consistency 
D)  are more vulnerable to security threats than are traditional applications 
E)  do not need to be encrypted

Question 20

________ in an E-R diagram refer to the least number of entities required in a relationship.

Accepted Answer

A)  Minimum candidate keys 
B)  Primary keys 
C)  Foreign keys 
D)  Minimum cardinalities 
E)  Chernozem cardinalities 
A)  Minimum candidate keys 
B)  Primary keys 
C)  Foreign keys 
D)  Minimum cardinalities 
E)  Chernozem cardinalities

When using the relational model to represent two tables, one must ________.

Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations.

A primary key in a database is a ________.

The crow's-foot notation in an E-R diagram shows the maximum number of entities that can be involved in a relationship.

Which of the following is the smallest element in a database?

Columns that are keys to different tables than the ones in which they reside are called ________.

Explain the functioning of browser applications.

Which of the following statements correctly describes the relationship between drones and videos in Falcon Security's database?

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

________ is the process of converting a data model into tables, relationships, and data constraints.

How does normalization resolve the data integrity problem?

Metadata is/are ________.

The rows in a database are also called ________.

Define the symbols and terms used in entity-relationship (E-R) diagrams.

In a database, when data items are inaccurate and inconsistent with one another, it leads to a(n) ________.

The data integrity problem occurs only if data are duplicated.

The accuracy of a database design is not dependent on the corresponding data model.

Relational databases represent relationships using ________.

Browser-based applications ________.

________ in an E-R diagram refer to the least number of entities required in a relationship.

The Importance of Mis

Collaboration Information Systems

Strategy and Information Systems

Hardware, Software, and Mobile Systems

The Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Filters

Exam 5: Database Processing

When using the relational model to represent two tables, one must ________.

Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations.

A primary key in a database is a ________.

The crow's-foot notation in an E-R diagram shows the maximum number of entities that can be involved in a relationship.

Which of the following is the smallest element in a database?

Columns that are keys to different tables than the ones in which they reside are called ________.

Explain the functioning of browser applications.

Which of the following statements correctly describes the relationship between drones and videos in Falcon Security's database?

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

________ is the process of converting a data model into tables, relationships, and data constraints.

How does normalization resolve the data integrity problem?

Metadata is/are ________.

The rows in a database are also called ________.

Define the symbols and terms used in entity-relationship (E-R) diagrams.

In a database, when data items are inaccurate and inconsistent with one another, it leads to a(n) ________.

The data integrity problem occurs only if data are duplicated.

The accuracy of a database design is not dependent on the corresponding data model.

Relational databases represent relationships using ________.

Browser-based applications ________.

________ in an E-R diagram refer to the least number of entities required in a relationship.

The Importance of Mis

Collaboration Information Systems

Strategy and Information Systems

Hardware, Software, and Mobile Systems

The Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Filters