Midterm Preparation:

 

Expected Allocation of Multiple Choice Questions by Chapter

Chapter

Question Count

1

1

2

1

3

2

4

2

5

2

6

2

7

6

8

8

9

6
10 3

 

Review the Quiz 1 Preparation Document as well as Quiz 1

Review the questions below. 

Hint 1: In some cases, the letter of the correct answer is highlighted in bold

Hint 2: In some cases, there is a reference to a page number in the text.

 

**************Chapter 7*******************************

 

When looking for actors, which of the following questions is the best one to ask?

            A)  how often is the system backed up?

            B)   who or what provides inputs to the system?

            C)   who is responsible for the budget of the system?

            D)  who is responsible for training the users?

            E)   who is responsible for reporting to the project stakeholders?

 

 

Which of the following can a project manager use to determine the importance of use cases?

            A)  use case dependency diagram

            B)   use case glossary

            C)   use case narrative

            D)  actor glossary

            E)   context diagram

 

Which of the following would be the best use case name?

            A)  enroll in course

            B)   course enrollment

            C)   course

            D)  enrollCourse()

            E)   they are all good use case names

Which of the following best describes use cases?

            A)  they are the results of decomposing the scope of system functionality

            B)   they are represented graphically by a horizontal ellipse

            C)   each use case represents a single goal of the system

            D)  they describe user interactions with the system

            E)   all of these

A question that needs to be resolved before the use case can be finalized is called a(n):

            A)  precondition

            B)   trigger

            C)   post condition

            D)  open issue

            E)   conclusion

 

 

A constraint on the state of the system before the use case can be executed is called a(n):

            A)  precondition

            B)   trigger

            C)   post condition

            D)  open issue

            E)   conclusion

The event that initiates the execute of the use case is called a(n):

            A)  precondition

            B)   trigger

            C)   post condition

            D)  open issue

            E)   conclusion

 

List five excellent questions to ask when looking for potential actors.

 

Page: 251  

Answer:

(1) Who or what provides inputs to the system? (2) Who or what receives outputs from the system? (3) Are interfaces required to other systems? (4) Are there any events that are automatically triggered at a predetermined time? (5) Who will maintain information in the system?

 

List five excellent questions to ask when looking for potential use cases.

 

Page: 252   

Answer:

(1) What are the main tasks of the actor? (2) What information does the actor need from the system? (3) What information does the actor provide to the system? (4) Does the system need to inform the actor of any changes or events that have occurred? (5) Does the actor need to inform the system of any changes or events that have occurred?

 

 

 

 

 

 

*******************Chapter 8 *************************************

 

Which of the following is a category of entities?  (Page 271)

            A)  person

            B)   place

            C)   object

            D)  concept

            E)   all of these

 A descriptive property or characteristic of an entity is: (Page 272)

            A)  a domain

            B)   an attribute

            C)   an entity instance

            D)  an entity existence

            E)   none of these

What defines what values an attribute can legitimately take on? (Page 272)

            A)  realm

            B)   entity

            C)   relationship

            D)  domain

            E)   none of these

An attribute or group of attributes that assumes a unique value for each entity instance is (Page 273)

            A)  domain

            B)   key

            C)   default value

            D)  data type

            E)   none of these

A true entity: (Page 289)

            A)  must have only one instance

            B)   must have many possible instances

            C)   must have a recursive relationship

            D)  must have the same cardinality and degree

            E)   all of these

A technique wherein attributes that are common to several types of an entity are grouped into their own entity called a supertype is called:   (Page: 283)

            A)  normalization

            B)   generalization

            C)   concatenation

            D)  compound data type

            E)   none of these

 

A table in which rows indicate entities (and possible attributes) and the columns indicate locations, and the cells indicate the document level of access including create, read, update or delete is known as: (Page: 308)

            A)  an entity relationship table

            B)   a transitive dependency table

            C)   a data-to-location CRUD matrix

            D)  a decision table

            E)   none of these

 

 

An entity relationship diagram: (Page 271)

            A)  is used in data modeling.

            B)   depicts data in terms of entities and relationships.

            C)   identifies the cardinality of a relationship.

            D)  makes clear the degree of a relationship.

            E)   all of these

 

  133.   Every student resides in 0 or 1 dorm. This is an example of: (Page 275)

            A) domain

            B)   default

            C)   degree

            D)  cardinality

            E)   nonspecific relationship

In the relationship between cities and residents, the resident entity would be: (Page 277)

            A)  the child

            B)   the parent

            C)   nonspecific

            D)  subtype

            E)   supertype

 

Be prepared to answer questions about an Entity Relationship Diagram that will appear on the Exam.

Be prepared to make changes to an ERD that you are given in order to put in Third Normal Form (remove the problems such as repeating attributes etc.)

***************Chapter 9*******************

A model that shows what a system is and what is does is:  (Page 316)

            A)  a physical model

            B)   a logical model

            C)   a context model

            D)  both a physical and logical model

            E)   none of these

 

A tool that depicts the flow of data through a system and the work or processing performed by that system is known as: (Page 317)

            A)  entity relationship diagrams

            B)   decomposition, structure diagrams

            C)   data flow diagrams

            D)  use case diagrams

            E)   none of these

The act of breaking a system into its component subsystems, processes and subprocesses is known as: (Page 322)

            A)  generalization

            B)   normalization

            C)   composition

            D)  decomposition

            E)   none of these

A set of related and ongoing activities in a business is known as: (Page 324)

            A)  a function

            B)   a database

            C)   a system

            D)  an event

            E)   none of these

A language and syntax, based on the relative strengths of structured programming and natural English used to specify the underlying logic of a process is known as: (Page 355)

            A)  pseudo code

            B)   Structured English

            C)   flow charts

            D)  decision tables

            E)   none of these


Explain the difference between Logical Models and Physical Models. (Page 316)

Explain the difference between a Data Flow Diagram and a flow chart.

What is the purpose of a Decision Table?

What is Structured English? When would you use it?

Explain the relationship between Decomposition Diagrams and Data Flow Diagrams.
Chapter 10*****************************************

What is the major difference between an Entity Type and an Object Class (or in more common language, what is the major difference between an Entity and an Object)?

In the following 3 questions, convince me that you understand the concepts. Use examples if you can. (Encapsulation, Polymorphism and/or Inheritance MIGHT be covered by me asking you to interpret diagrams that you would be given during the test.)

Explain Encapsulation.
Explain Polymorphism.
Explain Inheritance