Question 1

What are the different types of relationships represented in a data model? How are these captured by the use of keys.

Accepted Answer

There are four different types of relationships that have to be modeled in a data model; a 1:1, 1:M, M:1 and the most complex, N:M (many- to- many). In a 1:M and M:1 type of relationship, the foreign key is stored on the "many" side. In a 1:1 relationship, it can be stored on either side of the relationship. If the designer feels that the relationship may eventually change to a 1:M type, then the key should be stored on the potential "many" side. In a N:M type of relationship, a new intersection table is created using the identifier from each of the linked tables to form a new "composite" key.

Question 2

When a table contains inaccurate data for the same data elements in a table, it is said that the data in the table lacks __________.

Accepted Answer

integrity

Question 3

In a relational database, a collection of related records is a(n):

Accepted Answer

A)  file. 
B)  application. 
C)  table. 
D)  kilobyte. 
E)  field. 
A)  file. 
B)  application. 
C)  table. 
D)  kilobyte. 
E)  field. C

Question 4

MySQL Server is an open- source DBMS package so it is free for most database applications.

Accepted Answer

A) True 
 B)False

Question 5

A new information system enables user to perform in new ways, which leads to further changes in the system __________that the users couldn't visualize before.

Accepted Answer

A)  indexes 
B)  queries 
C)  reports 
D)  forms 
E)  requirements 
A)  indexes 
B)  queries 
C)  reports 
D)  forms 
E)  requirements

Question 6

Database practitioners classify tables into various ___________ depending on the type of data integrity problems to which they might be subject.

Accepted Answer

A)  normal forms 
B)  types 
C)  layers 
D)  categories 
E)  strata 
A)  normal forms 
B)  types 
C)  layers 
D)  categories 
E)  strata

Question 7

Changing the data entry form is the biggest challenge in creating and managing databases and database applications.

Accepted Answer

A) True 
 B)False

Question 8

SQL stands for "Standard Query Language".

Accepted Answer

A) True 
 B)False

Question 9

The name of the field and the data type and width are an example of metadata.

Accepted Answer

A) True 
 B)False

Question 10

Normalization is a process that helps ensure that the tables from the database design process are well structured.

Accepted Answer

A) True 
 B)False

Question 11

The database steering committee should consist of IT and IS people.

Accepted Answer

A) True 
 B)False

Question 12

_____________is the most popular diagramming tool for database applications.

Accepted Answer

A)  Workflow 
B)  E- R 
C)  UML 
D)  O- O 
A)  Workflow 
B)  E- R 
C)  UML 
D)  O- O

Question 13

Some important system________ that will be needed are only discovered after a period of use.

Accepted Answer

The answer of Some important system________ that will be needed...

Question 14

A bit is a character of data.

Accepted Answer

A) True 
 B)False

Question 15

__________is used to indicate a many- to- many relationship.

Accepted Answer

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

Question 16

Keys of a different table than the one in which they reside are called __________.

Accepted Answer

The answer of Keys of a different table than the...

Question 17

What are the different keys used for in relational databases? How do they maintain the integrity of the information in the database applications?

Accepted Answer

The primary key is also known as the ide

Question 18

A(n) _________ is a characteristic of an entity.

Accepted Answer

The answer of A(n) _________ is a characteristic of an...

Question 19

Every normalized table has:

Accepted Answer

A)  multiple topics.. 
B)  data integrity problems. 
C)  a single theme. 
D)  duplicated data. 
E)  none of the above. 
A)  multiple topics.. 
B)  data integrity problems. 
C)  a single theme. 
D)  duplicated data. 
E)  none of the above.

Question 20

If the same data element is stored differently in another table, this is said to be an issue of:

Accepted Answer

A)  entity integrity. 
B)  inaccurate data. 
C)  data integrity. 
D)  data redundancy. 
A)  entity integrity. 
B)  inaccurate data. 
C)  data integrity. 
D)  data redundancy.

What are the different types of relationships represented in a data model? How are these captured by the use of keys.

When a table contains inaccurate data for the same data elements in a table, it is said that the data in the table lacks __________.

In a relational database, a collection of related records is a(n):

MySQL Server is an open- source DBMS package so it is free for most database applications.

A new information system enables user to perform in new ways, which leads to further changes in the system __________that the users couldn't visualize before.

Database practitioners classify tables into various ___________ depending on the type of data integrity problems to which they might be subject.

Changing the data entry form is the biggest challenge in creating and managing databases and database applications.

SQL stands for "Standard Query Language".

The name of the field and the data type and width are an example of metadata.

Normalization is a process that helps ensure that the tables from the database design process are well structured.

The database steering committee should consist of IT and IS people.

_____________is the most popular diagramming tool for database applications.

Some important system________ that will be needed are only discovered after a period of use.

A bit is a character of data.

__________is used to indicate a many- to- many relationship.

Keys of a different table than the one in which they reside are called __________.

What are the different keys used for in relational databases? How do they maintain the integrity of the information in the database applications?

A(n) _________ is a characteristic of an entity.

Every normalized table has:

If the same data element is stored differently in another table, this is said to be an issue of:

Mis and You

Information Systems for Collaboration

Is for Competitive Advantage

Hardware and Software

Data Communications

Information Systems Within the Organization

E-Commerce and Supply Chain Systems

Business Intelligence Systems

Systems Development

Information Systems Management

Information Security Management

How the Internet Works

Filters

Exam 5: Database Processing

What are the different types of relationships represented in a data model? How are these captured by the use of keys.

When a table contains inaccurate data for the same data elements in a table, it is said that the data in the table lacks __________.

In a relational database, a collection of related records is a(n):

MySQL Server is an open- source DBMS package so it is free for most database applications.

A new information system enables user to perform in new ways, which leads to further changes in the system __________that the users couldn't visualize before.

Database practitioners classify tables into various ___________ depending on the type of data integrity problems to which they might be subject.

Changing the data entry form is the biggest challenge in creating and managing databases and database applications.

SQL stands for "Standard Query Language".

The name of the field and the data type and width are an example of metadata.

Normalization is a process that helps ensure that the tables from the database design process are well structured.

The database steering committee should consist of IT and IS people.

_____________is the most popular diagramming tool for database applications.

Some important system________ that will be needed are only discovered after a period of use.

A bit is a character of data.

__________is used to indicate a many- to- many relationship.

Keys of a different table than the one in which they reside are called __________.

What are the different keys used for in relational databases? How do they maintain the integrity of the information in the database applications?

A(n) _________ is a characteristic of an entity.

Every normalized table has:

If the same data element is stored differently in another table, this is said to be an issue of:

Mis and You

Information Systems for Collaboration

Is for Competitive Advantage

Hardware and Software

Data Communications

Information Systems Within the Organization

E-Commerce and Supply Chain Systems

Business Intelligence Systems

Systems Development

Information Systems Management

Information Security Management

How the Internet Works

Filters