Question 1

A data dictionary contains:
A)an external listing of relations and the fields stored in each.
B)the logical structure for the information in a database.
C)the definitions associated with database management systems.
D)a listing of business rules and the data these rules create.

Accepted Answer

The data dictionary contains the logical structure for the information in a database.

Question 2

If a student's ID was also present in a relation that stored enrollment information,this field in the enrollment relation would be called a(n)_____ key.
A)intersecting
B)composite
C)merged
D)foreign

Accepted Answer

A foreign key is a primary key of one file (relation)that appears in another file (relation).

Question 3

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

Accepted Answer

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

Question 4

An intersection relation is also known as a(n)_____ relation.
A)primary
B)connection
C)composite
D)merged

Accepted Answer

An intersection relation is sometimes called a composite relation.

Question 5

A foreign key is a:
A)primary key of one relation that appears in another relation.
B)primary key that contains a needed translation of the primary key from the same relation.
C)field that reformats the primary key so that it can be used in another application.
D)field that contains a primary key from an external database.

Accepted Answer

A foreign key is a primary key of one file (relation)that appears in another file (relation).

Question 6

An intersection relation consists of:
A)summary information.
B)primary keys for all entity classes in the relational database.
C)primary key fields from the intersecting relations.
D)definitions for the intersecting relations.

Accepted Answer

An intersection relation will have a composite primary key that consists of the primary key fields from the two intersecting relations.

Question 7

_____ is the process of assuring that a relational database structure can be implemented as a series of two-dimensional relations or tables.
A)Normalization
B)Standardization
C)Planning
D)Cross-functional modeling

Accepted Answer

Normalization is a process of assuring that a relational database structure can be implemented as a series of two-dimensional relations.

Question 8

A composite primary key is:
A)a merged field containing the primary key and descriptive information.
B)a key in the intersecting relation that contains the primary keys from the two intersecting relations.
C)a field composed of information from multiple sources.
D)a unique field that can be used throughout the organization to identify an entity.

Accepted Answer

A composite primary key is a key that consists of the primary key fields from the two intersecting relations.

Question 9

If you find a many-to-many relationship,which of the following is a guideline to be followed when creating an intersection relation?
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.

Accepted Answer

As a general rule,the new minimum and maximum cardinalities for the two original relations will be one and one.

Question 10

If you were looking at an E-R diagram,how would you be able to identify a many-to-many relationship between two entities?
A)There would be multiple entities sharing the same name.
B)There would be a crow's foot on each end of the relationship between the two entities.
C)There would be a double-edged arrow pointing to the many side of the relationship.
D)There would be a double line linking the two entities together.

Accepted Answer

The first rule of normalization states that no repeating groups or many-to-many relationships can exist among the entity classes.You can find these many-to-many relationships by simply looking at your E-R diagram and note any relationships that have a crow's foot on each end.

Question 11

When defining information (fields)for a relation,you should ensure that:
A)the information for this relation cannot be derived from other information.
B)the information for this relation can be found in other relations.
C)the information can be identified by the primary key and by other fields in the relation.
D)the information can be identified by the foreign key in this relation.

Accepted Answer

Your goal when defining information (fields)for a relation is to make sure that the information in each relation is indeed in the correct relation and that the information cannot be derived from other information-the second and third rules of normalization.

Question 12

A database management system is:
A)a complete set of relations,their links,and the data stored in the database.
B)an application that allows you to specify the logical structure for a database and access the information within it.
C)a logical structure for the information within the database.
D)a data dictionary for a specific relational database.

Accepted Answer

A database management system (DBMS)helps you specify the logical organization for a database and access and use the information within the database.

Question 13

Which of the following denotes a multiple relationship between entity classes in an E-R diagram?
A)Double line
B)Dotted line
C)The symbol "|"
D)Crow's foot

Accepted Answer

A crow's foot (shown as <)is used to denote a multiple relationship in an E-R diagram.

Question 14

An E-R diagram includes five basic symbols.Which one denotes an optional relationship between entity classes?
A)Dotted line
B)Circle
C)Triangle
D)Straight,vertical symbol ( | )

Accepted Answer

In an E-R diagram,an "O" is used to denote a zero or optional relationship.

Question 15

Which symbol would you use in an E-R diagram to show that a student can enroll in more than one course?
A)Double-line circle
B)Solid arrow
C)Double straight line
D)Crow's foot

Accepted Answer

A crow's foot (shown as <)is used to denote a multiple relationship in an E-R diagram.

Question 16

Which of the following is not one of the rules of normalization?
A)Assure that the operating version of your relational database is consistent throughout the organization
B)Eliminate repeating groups or many-to-many relationships
C)Assure that each field in a relation depends only on the primary key for that relation
D)Remove all derived fields from the relations

Accepted Answer

The three rules of normalization:1.Eliminate repeating groups or many-to-many relationships.2.Assure that each field in a relation depends only on the primary key for that relation.3.Remove all derived fields from the relations.

Question 17

A database is a collection of information that you organize and access according to the logical structure of that information.

Accepted Answer

A database is a collection of information that you organize and access according to the logical structure of that information.

Question 18

Which symbol would you use in an E-R diagram to show that a student may or may not enroll in a course?
A)Circle
B)Square
C)Arrow
D)Straight,vertical line ( | )

Accepted Answer

In an E-R diagram,an "O" is used to denote a zero or optional relationship.

Question 19

The primary key fields from the two original relations become foreign keys in the intersection relation.When combined,the two foreign keys make up the _____ for the intersection relation.
A)merged key
B)composite primary key
C)combined key
D)intersecting key

Accepted Answer

When combined,the two foreign keys make up the composite primary key for the intersection relation.

Question 20

An intersection relation is:
A)a temporary relation that pulls information from other linked relations.
B)a relation that holds aggregate or summary information.
C)a relation you create to eliminate a many-to-many relationship.
D)a relation that identifies and stores the primary key for all entity classes.

Accepted Answer

An intersection relation is a relation you create to eliminate a many-to-many relationship.

Quiz 12: Designing Databases and Entity-Relationship Diagramming

A data dictionary contains:

If a student's ID was also present in a relation that stored enrollment information,this field in the enrollment relation would be called a(n) _____ key.

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

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

A foreign key is a:

An intersection relation consists of:

_____ is the process of assuring that a relational database structure can be implemented as a series of two-dimensional relations or tables.

A composite primary key is:

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

If you were looking at an E-R diagram,how would you be able to identify a many-to-many relationship between two entities?

When defining information (fields) for a relation,you should ensure that:

A database management system is:

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

An E-R diagram includes five basic symbols.Which one denotes an optional relationship between entity classes?

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 is not one of the rules of normalization?

A database is a collection of information that you organize and access according to the logical structure of that information.

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

The primary key fields from the two original relations become foreign keys in the intersection relation.When combined,the two foreign keys make up the _____ for the intersection relation.

An intersection relation is: