Explain the difference between system analysis, system design and system construction. (Expect an essay question very similar to this one).  Also give examples of tasks performed by System Designers and System Builders.

 

A contract with management and the user community to develop or enhance an information system is know as a ____________ .( chose this cause this came up quite a bit during our db rollout)

A _________ is a small-scale, representation, or working model of the users’ requirements or proposed design for an information system.

Explain what a commercial off-the shelf system (COTS) is?

 

A _________ is an event signifying the completion of a major project deliverable.

 

 

 

Please write three of the questions that can be used to identify Business Actors.

 

Explain Normalization

 

Data Modeling is a technique for organizing and documenting a system’s DATA. It is sometimes called database modeling because it is usually implemented as a database.

True or False:

 

What defines what values an attribute can legitimately take on (Answer: Domain)

An attribute whose value can be calculated from other attributes is called (Answer: a derived attribute).

A model that shows what a system is and what it does as well as how it does it is (Answer: a physical model).  Be able to explain the difference between logical and physical models.

Be able to define a data flow diagram. (A tool that depicts the flow of data through a system and the work or processing by the system)

Define a process (Answer: work performed on, or in response to, incoming data flows or conditions).  This will be one of the choices in a multiple choice question.

A diagram that shows the system broken into its component subsystems is a________________diagram.  (Name the type of diagram)

Be able to define a decision table.

What is UML?

What are the benefits of doing Use Case modeling?

 

 

T\F Designing the system interface is a task of system design

T\F The Hypertext Markup Language (HTML) is commonly used for constructing help systems for graphical user interfaces.

 

 

 

 

 (True/False) Application architecture defines the technologies to be used by one, more or all information systems in terms of their data, processes, interfaces, and network components.

 Which of these is NOT a task for system design for in-house Development?
            A.  Design the Application Architecture?
            B.  Design the System Interface
            C.  Solicit Proposals or Quotes from Vendors
            D.  Package Design Specifications
            E.  Update the Project Plan

 What are the advantages and major disadvantages/pitfall of prototyping? 

 

Which is not one of the five layers of distributed systems architecture?
            A. Presentation
            B. Presentation Logic
            C. Data Modeling
            D. Application Logic
            E. Data Manipulation

 

_________ is a collection of similar records. (File)
_________ is the smallest unit of meaningful data to be stored in a file or database. (Field)

 

 

Question
Which type of object class provides the functionality read and write attributes to and from a database

Answer

 

A.  Entity Classes

 

B.  Interface Classes

 

C.  Control Classes

D.  Persistence Classes

 

E.  System Classes

 

What is a Smart Card?

What is MICR?

What are self-checking digits?

Question
Entities and objects differ in that:

Answer

 

A.  Objects only model data

 

B.  Entities only model methods/processes

C.  Objects model both data and methods/processes

 

D.  Entities model both data and methods/processes

 

E.  Entities and Objects are exactly the same.

 

                     
What is a Pie chart?

What is brainstorming?

What is the difference between a Transaction Processing System and a Management Information System?

What is a Policy?
What is a Procedure?

Give examples of tangible and intangible benefits

Be prepared to draw an Entity Relationship Diagram from information given on the exam.