Question 1

In a relational database, each entity is described by

Accepted Answer

A)  characters. 
B)  data. 
C)  bytes. 
D)  attributes. 
E)  records. 
A)  characters. 
B)  data. 
C)  bytes. 
D)  attributes. 
E)  records.

Question 2

If a student is allowed to have multiple majors and advisers are assigned to multiple students, these would be examples of ________ relationships.

Accepted Answer

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

Question 3

________ is the process of converting poorly-structured tables into two or more well-structured tables.

Accepted Answer

A)  Application development 
B)  Normalization 
C)  Structuring 
D)  Clarification 
E)  Conversion 
A)  Application development 
B)  Normalization 
C)  Structuring 
D)  Clarification 
E)  Conversion

Question 4

In order to represent a(n) ________ type of relationship, a third table is created using the keys from the two entities being related.

Accepted Answer

The answer of In order to represent a(n) ________ type...

Question 5

Once the entities have been defined, the data model can be implemented directly on the DBMS.

Accepted Answer

A) True 
 B)False

Question 6

A physical representation of a database is called a data model.

Accepted Answer

A) True 
 B)False

Question 7

When you place data into a database, you need to place (the) ________ records first.

Accepted Answer

A)  first 
B)  foreign key 
C)  primary key 
D)  any 
E)  indexed 
A)  first 
B)  foreign key 
C)  primary key 
D)  any 
E)  indexed

Question 8

A person, place, or object would be represented in a database application as a(n)

Accepted Answer

A)  entity. 
B)  record. 
C)  table. 
D)  class. 
E)  object. 
A)  entity. 
B)  record. 
C)  table. 
D)  class. 
E)  object.

Question 9

Each entity should have one unique identifier.

Accepted Answer

A) True 
 B)False

Question 10

One difficulty with designing database is the ________ number of possibilities of what to include.

Accepted Answer

A)  small 
B)  minimal 
C)  large 
D)  fixed 
E)  known 
A)  small 
B)  minimal 
C)  large 
D)  fixed 
E)  known

Question 11

E-R diagrams are too cumbersome for use in database design discussions.

Accepted Answer

A) True 
 B)False

Question 12

A(n) ________ data model captures the entities and their relationships in a database application.

Accepted Answer

A)  workflow 
B)  O-O 
C)  Semantic object 
D)  E-R 
E)  flowchart 
A)  workflow 
B)  O-O 
C)  Semantic object 
D)  E-R 
E)  flowchart

Question 13

Entities have ________ that describes characteristics of the entity.

Accepted Answer

A)  relations 
B)  properties 
C)  attributes 
D)  names 
E)  files 
A)  relations 
B)  properties 
C)  attributes 
D)  names 
E)  files

Question 14

Tables are transformed into ________ to remove duplicate data and other problems.

Accepted Answer

A)  regular design 
B)  normalized design 
C)  regular form 
D)  normal form 
E)  relational form 
A)  regular design 
B)  normalized design 
C)  regular form 
D)  normal form 
E)  relational form

Question 15

Normalization is a trade-off between the elimination of data duplication and processing speed.

Accepted Answer

A) True 
 B)False

Question 16

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

The answer of When a table contains inaccurate data for...

Question 17

Entities have ________ with one another.

Accepted Answer

The answer of Entities have ________ with one another....

Question 18

"Name" would be a good identifier for a customer entity in a database application.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A)  inaccurate data. 
B)  entity integrity. 
C)  data repetition. 
D)  normalization. 
E)  data integrity. 
A)  inaccurate data. 
B)  entity integrity. 
C)  data repetition. 
D)  normalization. 
E)  data integrity.

Question 20

A 1:N relationship relates ________ record(s) to ________ record(s) in a database.

Accepted Answer

A)  many, one 
B)  one, three 
C)  one, one 
D)  many, many 
E)  one, many 
A)  many, one 
B)  one, three 
C)  one, one 
D)  many, many 
E)  one, many

In a relational database, each entity is described by

If a student is allowed to have multiple majors and advisers are assigned to multiple students, these would be examples of ________ relationships.

________ is the process of converting poorly-structured tables into two or more well-structured tables.

In order to represent a(n) ________ type of relationship, a third table is created using the keys from the two entities being related.

Once the entities have been defined, the data model can be implemented directly on the DBMS.

A physical representation of a database is called a data model.

When you place data into a database, you need to place (the) ________ records first.

A person, place, or object would be represented in a database application as a(n)

Each entity should have one unique identifier.

One difficulty with designing database is the ________ number of possibilities of what to include.

E-R diagrams are too cumbersome for use in database design discussions.

A(n) ________ data model captures the entities and their relationships in a database application.

Entities have ________ that describes characteristics of the entity.

Tables are transformed into ________ to remove duplicate data and other problems.

Normalization is a trade-off between the elimination of data duplication and processing speed.

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

Entities have ________ with one another.

"Name" would be a good identifier for a customer entity in a database application.

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

A 1:N relationship relates record(s) to record(s) in a database.

Information Systems and You

Business Processes and Decision Making

Application Extension-Introduction to Business Process Modeling With Microsoft Visio

Productivity, Innovation, and Strategy

Application Extension-Introduction to Microsoft Excel 2013

Hardware and Software

Database and Content Management

Extension-Using Microsoft Access 2013

Networks and Collaboration

Competitive Advantage and Business Processes

Decision Making and Business Intelligence

E-commerce, Social Networking, and Web 20

Acquiring Information Systems Through Projects

Application Extension-Introduction to Microsoft Project

Structure, Governance, and Ethics

Managing Information Security and Privacy

Filters

Exam 9: Extension-Database Design

In a relational database, each entity is described by

If a student is allowed to have multiple majors and advisers are assigned to multiple students, these would be examples of ________ relationships.

________ is the process of converting poorly-structured tables into two or more well-structured tables.

In order to represent a(n) ________ type of relationship, a third table is created using the keys from the two entities being related.

Once the entities have been defined, the data model can be implemented directly on the DBMS.

A physical representation of a database is called a data model.

When you place data into a database, you need to place (the) ________ records first.

A person, place, or object would be represented in a database application as a(n)

Each entity should have one unique identifier.

One difficulty with designing database is the ________ number of possibilities of what to include.

E-R diagrams are too cumbersome for use in database design discussions.

A(n) ________ data model captures the entities and their relationships in a database application.

Entities have ________ that describes characteristics of the entity.

Tables are transformed into ________ to remove duplicate data and other problems.

Normalization is a trade-off between the elimination of data duplication and processing speed.

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

Entities have ________ with one another.

"Name" would be a good identifier for a customer entity in a database application.

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

A 1:N relationship relates ________ record(s) to ________ record(s) in a database.

Information Systems and You

Business Processes and Decision Making

Application Extension-Introduction to Business Process Modeling With Microsoft Visio

Productivity, Innovation, and Strategy

Application Extension-Introduction to Microsoft Excel 2013

Hardware and Software

Database and Content Management

Extension-Using Microsoft Access 2013

Networks and Collaboration

Competitive Advantage and Business Processes

Decision Making and Business Intelligence

E-commerce, Social Networking, and Web 20

Acquiring Information Systems Through Projects

Application Extension-Introduction to Microsoft Project

Structure, Governance, and Ethics

Managing Information Security and Privacy

Filters

A 1:N relationship relates record(s) to record(s) in a database.