Question 1

Within an entity-relationship diagram,a "|" represents a(n)____.

Accepted Answer

single relationship
Explanation: An E-R diagram includes five basic symbols.A "|" is used to denote single relationship.

Question 2

Repeating groups should be eliminated during database design.

Accepted Answer

A) True 
 B)False  True

Question 3

An intersection relation is also known as a(n)_____ relation.

Accepted Answer

A)  primary
B)  connection
C)  composite
D)  merged C

Question 4

Which symbol would you use in an E-R diagram to show that a student can enroll in more than one course?

Accepted Answer

A)  Double-line circle
B)  Solid arrow
C)  Double straight line
D)  Crow's foot

Question 5

Which of the following denotes a multiple relationship between entity classes in an E-R diagram?

Accepted Answer

A)  Double line
B)  Dotted line
C)  The symbol "|"
D)  Crow's foot

Question 6

_____ is a set of tools that you use to process information.

Accepted Answer

The answer of _____ is a set of tools that...

Question 7

A data dictionary consists of the primary key fields from the two intersecting relations.

Accepted Answer

A) True 
 B)False

Question 8

The _____ contains the logical structure for the information in a database.

Accepted Answer

The answer of The _____ contains the logical structure for...

Question 9

What is the first step in designing and building a database?

Accepted Answer

A)  Defining entity classes and primary keys
B)  Defining relationships among entity classes
C)  Defining information for each relation
D)  Defining the maintenance cycle for future enhancements

Question 10

Which symbol would you use in an E-R diagram to show that a student may or may not enroll in a course?

Accepted Answer

A)  Circle
B)  Square
C)  Arrow
D)  Straight,vertical line ( | )

Question 11

The complete normalization process is _____ and quite necessary for developing organization-wide databases.

Accepted Answer

The answer of The complete normalization process is _____ and...

Question 12

In an E-R diagram,crow's foot denotes a multiple relationship.

Accepted Answer

A) True 
 B)False

Question 13

A relational database uses a series of logically related _____ tables or files to store information in the form of a database.

Accepted Answer

The answer of A relational database uses a series of...

Question 14

When creating a database you don't need to know the physical location of the information you want to see or use.

Accepted Answer

A) True 
 B)False

Question 15

If you find a many-to-many relationship,which of the following is a guideline to be followed when creating an intersection relation?

Accepted Answer

A)  Create a new E-R diagram (showing no cardinality) with the original two relations in the middle and a new one (the intersection relation) in the end.
B)  Move the minimum cardinality appearing next to the left relation just to the left of the intersection relation.
C)  Move the minimum cardinality appearing next to the right relation just to the right of the intersection relation.
D)  The new minimum and maximum cardinalities for the two original relations will be one and one.

Question 16

The numerical nature of the E-R relationship is referred to as "minimum and maximum cardinality."

Accepted Answer

A) True 
 B)False

Question 17

Which of the following defines a database?

Accepted Answer

A)  A software application that works primarily with numbers and is commonly used to execute calculations
B)  A collection of information that is organized and accessed according to the logical structure of that information
C)  A three-dimensional table of information
D)  A concept in which you wish to store information and that you can identify with a unique key

Question 18

An E-R diagram includes five basic symbols.Which of the following denotes a single relationship between entity classes?

Accepted Answer

A)  A crow's foot (shown as 
B)  A "|" symbol
C)  A dotted line
D)  A circle

Question 19

Within an entity-relationship diagram,_______ is used to represent multiple relationships.

Accepted Answer

The answer of Within an entity-relationship diagram,_______ is used to...

Question 20

In an E-R diagram,O is used to denote an entity class.

Accepted Answer

A) True 
 B)False

Exam 12: Designing Databases and Entity-Relationship Diagramming

Within an entity-relationship diagram,a "|" represents a(n)____.

Repeating groups should be eliminated during database design.

An intersection relation is also known as a(n) _____ relation.

Which symbol would you use in an E-R diagram to show that a student can enroll in more than one course?

Which of the following denotes a multiple relationship between entity classes in an E-R diagram?

_____ is a set of tools that you use to process information.

A data dictionary consists of the primary key fields from the two intersecting relations.

The _____ contains the logical structure for the information in a database.

What is the first step in designing and building a database?

Which symbol would you use in an E-R diagram to show that a student may or may not enroll in a course?

The complete normalization process is _____ and quite necessary for developing organization-wide databases.

In an E-R diagram,crow's foot denotes a multiple relationship.

A relational database uses a series of logically related _____ tables or files to store information in the form of a database.

When creating a database you don't need to know the physical location of the information you want to see or use.

If you find a many-to-many relationship,which of the following is a guideline to be followed when creating an intersection relation?

The numerical nature of the E-R relationship is referred to as "minimum and maximum cardinality."

Which of the following defines a database?

An E-R diagram includes five basic symbols.Which of the following denotes a single relationship between entity classes?

Within an entity-relationship diagram,_______ is used to represent multiple relationships.

In an E-R diagram,O is used to denote an entity class.