Question 1

The lost update problem occurs when ________.

Accepted Answer

A)  multiple users make changes to a database 
B)  a single row holds multiple values 
C)  a user uses a personal rather than an enterprise database 
D)  a multi-user database is converted to a single-user database 
A)  multiple users make changes to a database 
B)  a single row holds multiple values 
C)  a user uses a personal rather than an enterprise database 
D)  a multi-user database is converted to a single-user database

Question 2

Explain the Entity-Relationship Data Model, using an example.

Accepted Answer

The entity-relationship (E-R) data model

Question 3

In a database, rows are also known as ________.

Accepted Answer

A)  fields 
B)  bytes 
C)  forms 
D)  records 
A)  fields 
B)  bytes 
C)  forms 
D)  records

Question 4

A foreign key must be added to at least one of the tables when using the relational model.

Accepted Answer

A) True 
 B)False

Question 5

A(n)________ is an attribute (or group of attributes)whose value is associated with one and only one entity instance.

Accepted Answer

A)  relationship 
B)  query 
C)  identifier 
D)  primary key 
A)  relationship 
B)  query 
C)  identifier 
D)  primary key

Question 6

Metadata are data that describe data.

Accepted Answer

A) True 
 B)False

Question 7

An entity is something that the users want to track, and attributes are those that describe their characteristics.

Accepted Answer

A) True 
 B)False

Question 8

The crow's-foot notation can show the maximum cardinality involved in a relationship.

Accepted Answer

A) True 
 B)False

Question 9

Database developers use the DBMS to create tables, relationships, and other structures in the database.

Accepted Answer

A) True 
 B)False

Question 10

Database management systems are mostly developed by the organizations that use them.

Accepted Answer

A) True 
 B)False

Question 11

Both the E-R data model and UML are tools used for constructing data models.

Accepted Answer

A) True 
 B)False

Question 12

Every normalized table has ________.

Accepted Answer

A)  multiple topics 
B)  data integrity problems 
C)  a single theme 
D)  duplicated data 
A)  multiple topics 
B)  data integrity problems 
C)  a single theme 
D)  duplicated data

Question 13

What are the functions of a DBMS?

Accepted Answer

1.Creating the database and its structur

Question 14

Constraints on the number of entities that can be in a relationship are called ________.

Accepted Answer

A)  normal forms 
B)  minimum cardinalities 
C)  queries 
D)  primary keys 
A)  normal forms 
B)  minimum cardinalities 
C)  queries 
D)  primary keys

Question 15

Before building a database, developers construct a logical representation of its data called a data model.

Accepted Answer

A) True 
 B)False

Question 16

If the structure of a list is complex, it is better to use a spreadsheet than a database.

Accepted Answer

A) True 
 B)False

Question 17

In a university, a single student can be associated to many classes and one class can be associated to many students. This is an example of a(n)________.

Accepted Answer

A)  1:N relationship 
B)  N:1 relationship 
C)  N:N relationship 
D)  N:M relationship 
A)  1:N relationship 
B)  N:1 relationship 
C)  N:N relationship 
D)  N:M relationship

Question 18

User requirements from a database are summarized in a data model.

Accepted Answer

A) True 
 B)False

Question 19

What is a database? Explain the contents of a database.

Accepted Answer

A database is a self-describing collecti

Question 20

Many-to-many relationships are indicated using the ________ notation.

Accepted Answer

A)  N:N 
B)  1:N 
C)  M:1 
D)  N:M 
A)  N:N 
B)  1:N 
C)  M:1 
D)  N:M

The lost update problem occurs when ________.

Explain the Entity-Relationship Data Model, using an example.

In a database, rows are also known as ________.

A foreign key must be added to at least one of the tables when using the relational model.

A(n)________ is an attribute (or group of attributes)whose value is associated with one and only one entity instance.

Metadata are data that describe data.

An entity is something that the users want to track, and attributes are those that describe their characteristics.

The crow's-foot notation can show the maximum cardinality involved in a relationship.

Database developers use the DBMS to create tables, relationships, and other structures in the database.

Database management systems are mostly developed by the organizations that use them.

Both the E-R data model and UML are tools used for constructing data models.

Every normalized table has ________.

What are the functions of a DBMS?

Constraints on the number of entities that can be in a relationship are called ________.

Before building a database, developers construct a logical representation of its data called a data model.

If the structure of a list is complex, it is better to use a spreadsheet than a database.

In a university, a single student can be associated to many classes and one class can be associated to many students. This is an example of a(n)________.

User requirements from a database are summarized in a data model.

What is a database? Explain the contents of a database.

Many-to-many relationships are indicated using the ________ notation.

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

The lost update problem occurs when ________.

Explain the Entity-Relationship Data Model, using an example.

In a database, rows are also known as ________.

A foreign key must be added to at least one of the tables when using the relational model.

A(n)________ is an attribute (or group of attributes)whose value is associated with one and only one entity instance.

Metadata are data that describe data.

An entity is something that the users want to track, and attributes are those that describe their characteristics.

The crow's-foot notation can show the maximum cardinality involved in a relationship.

Database developers use the DBMS to create tables, relationships, and other structures in the database.

Database management systems are mostly developed by the organizations that use them.

Both the E-R data model and UML are tools used for constructing data models.

Every normalized table has ________.

What are the functions of a DBMS?

Constraints on the number of entities that can be in a relationship are called ________.

Before building a database, developers construct a logical representation of its data called a data model.

If the structure of a list is complex, it is better to use a spreadsheet than a database.

In a university, a single student can be associated to many classes and one class can be associated to many students. This is an example of a(n)________.

User requirements from a database are summarized in a data model.

What is a database? Explain the contents of a database.

Many-to-many relationships are indicated using the ________ notation.

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