Question 1

Which of the following is true about an entity class?

Accepted Answer

A) It is a field or class of fields that uniquely identifies information about an entity. 
B) It is an occurrence of an entity class. 
C) It represents a group or class of information that sits separately from other information in the database. 
D) It typically consists of people,places,or things that you wish to store information about in the database. 
A) It is a field or class of fields that uniquely identifies information about an entity. 
B) It is an occurrence of an entity class. 
C) It represents a group or class of information that sits separately from other information in the database. 
D) It typically consists of people,places,or things that you wish to store information about in the database.

Question 2

Relational databases are similar to spreadsheets in that:

Accepted Answer

A) you maintain information in two-dimensional files. 
B) you maintain information in three-dimensional files. 
C) you compress information in order to store them. 
D) you create primary keys for each entity class. 
A) you maintain information in two-dimensional files. 
B) you maintain information in three-dimensional files. 
C) you compress information in order to store them. 
D) you create primary keys for each entity class.

Question 3

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.

Accepted Answer

A) intersecting 
B) composite 
C) merged 
D) foreign 
A) intersecting 
B) composite 
C) merged 
D) foreign

Question 4

A(n)_____ is a concept about which you wish to store information and that you can identify with a unique key.

Accepted Answer

entity class
Explanation: An e

Question 5

Which of the following characterizes a relational database?

Accepted Answer

A) A three-dimensional table or file of information 
B) An object-oriented storage and data management system 
C) A series of related worksheets populated with information 
D) A logically related two-dimensional table or file of information 
A) A three-dimensional table or file of information 
B) An object-oriented storage and data management system 
C) A series of related worksheets populated with information 
D) A logically related two-dimensional table or file of information

Question 6

An entity class is a table which stores similar information and can be identified with a common key.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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.

Accepted Answer

A) merged key 
B) composite primary key 
C) combined key 
D) intersecting key 
A) merged key 
B) composite primary key 
C) combined key 
D) intersecting key

Question 9

Once you've implemented your database,you can neither change nor add information.

Accepted Answer

A) True 
 B)False

Question 10

A foreign key is a:

Accepted Answer

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. 
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.

Question 11

Normalization involves assuring that each field within a relation depends only on the _____ for that relation.

Accepted Answer

primary key
Explanation: Norma

Question 12

A(n)_____ is a primary key of one relation that appears in another relation.

Accepted Answer

foreign key
Explanation: A for

Question 13

What is an instance?

Accepted Answer

A) It is a key that uniquely identifies a person,place,or thing. 
B) It is a group of related information about an entity. 
C) It is a record or row in a relation. 
D) It is an occurrence of an entity class that can be identified by a primary key. 
A) It is a key that uniquely identifies a person,place,or thing. 
B) It is a group of related information about an entity. 
C) It is a record or row in a relation. 
D) It is an occurrence of an entity class that can be identified by a primary key.

Question 14

Within an entity-relationship diagram,the _______ symbol represents an entity class.

Accepted Answer

rectangle
Explanation: An E-R

Question 15

Which symbol would you use in an E-R diagram to show that a course is taught by only one teacher?

Accepted Answer

A) Straight,vertical line ( | ) 
B) Crow's foot 
C) Solid arrow 
D) Circle 
A) Straight,vertical line ( | ) 
B) Crow's foot 
C) Solid arrow 
D) Circle

Question 16

To develop the numerical relationships or cardinality among entity classes,you must clearly understand the business environment and its business rules.

Accepted Answer

A) True 
 B)False

Question 17

_____ are statements concerning the information you need to work with and the relationships within the information.

Accepted Answer

Business rules
Explanation: Bu

Question 18

In an E-R diagram,a rectangle denotes a relationship.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is a graphic method of representing entity classes and their relationships?

Accepted Answer

A) Database model 
B) Flowchart 
C) Pie chart 
D) E-R diagram 
A) Database model 
B) Flowchart 
C) Pie chart 
D) E-R diagram

Question 20

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

Accepted Answer

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. 
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.

Exam 12: Designing Databases and Entity-Relationship Diagramming

Which of the following is true about an entity class?

Relational databases are similar to spreadsheets in that:

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(n)_____ is a concept about which you wish to store information and that you can identify with a unique key.

Which of the following characterizes a relational database?

An entity class is a table which stores similar information and can be identified with a common key.

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

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.

Once you've implemented your database,you can neither change nor add information.

A foreign key is a:

Normalization involves assuring that each field within a relation depends only on the _____ for that relation.

A(n)_____ is a primary key of one relation that appears in another relation.

What is an instance?

Within an entity-relationship diagram,the _______ symbol represents an entity class.

Which symbol would you use in an E-R diagram to show that a course is taught by only one teacher?

To develop the numerical relationships or cardinality among entity classes,you must clearly understand the business environment and its business rules.

_____ are statements concerning the information you need to work with and the relationships within the information.

In an E-R diagram,a rectangle denotes a relationship.

Which of the following is a graphic method of representing entity classes and their relationships?

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

The Information Age in Which You Live: Changing the Face of Business

Major Business Initiatives: Gaining Competitive Advantage With It

Databases and Data Warehouses: Supporting the Analytics-Driven Organization

Analytics, Decision Support, and Artificial Intelligence: Brain-Power for Your Business

Electronic Commerce: Strategies for the New Economy

Systems Development: Phases, Tools, and Techniques

Infrastructure, Cloud Computing, Metrics, and Business Continuity Planning: Building and Sustaining the Dynamic Enterprise

Protecting People and Information: Threats and Safeguards

Emerging Trends and Technologies: Business, People, and Technology Tomorrow

Computer Hardware and Software

The World Wide Web and the Internet

Decision Analysis With Spreadsheet Software

Network Basics

Building a Web Page With Html

Object-Oriented Technologies

Computer Crime and Digital Forensics

Building an E-Portfolio

Implementing a Database With Microsoft Access

Careers in Business

Building Web Sites With Front-page

Programming in Excel With VBA

Filters