Sys Analysis practice Test

Testing to assure that data is of proper type is the purpose of the:

class or composition validation test

A file folder containing orders would be represented on a data-flow diagram as a:

data store

The major deliverables associated with the human interface design stage are:

design specifications

A formal method for designing and representing human-computer dialogues using box and line diagrams is referred to as:

dialogue diagramming

If OrderNumber serves as the primary key in the ORDER relation and also appears as a nonkey attribute in the INVOICE relation, then OrderNumber is said to be a:

foreign key

A particular relationship between two attributes best defines:

functional dependency

The primary deliverable from logical database design is:

normalized relations

A common mistake using highlighting includes:

overusing highlighting elements

A foreign key in a relation that references the primary key values of that same relation is referred to as a:

recursive foreign key.

Another name for unary relationship is a:

recursive relationship

Given a FACULTY relation that includes both faculty and faculty sponsors attributes from the same data, this would be considered a:

recursive relationship

The integrity constraint that species that the value (or existence) of an attribute in one relation depends on the value (or existence) of the same attribute in another relation is called

referential integrity

The integrity constraint that specifies that the value (or existence) of an attribute in one relation depends on the value (or existence) of the same attribute in another relation is called:

referential integrity

A named two-dimensional table of data is a(n)

relation

Each regular entity type in an E-R diagram is transformed into a:

relation

A data model that represents data in the form of tables or relations is called a(n):

relational database model

"Please wait while I open the file" is an example of:

status information

Human interface design is performed during

systems design

Each of the following are true statements EXCEPT:

systems inputs and outputs are proceeded during the systems implementation and operation phase of the systems development life cycle.

When transforming an E-R diagram into normalized relations, the identifier of the entity type becomes ___________________

the primary key of the corresponding relation.

For any relation R, if, for every valid instance of A, that value of A uniquely determines the value of B:

then B is said to be functionally dependent on A

Entering invalid data into a field describes:

transcripting

The dependence of nonprimary key attributes on other nonprimary key attributes best describes a:

transitive dependency

Combining all normalized user views into one consolidated logical database model refers to:

view integration

An entity whose primary key depends on the primary key of another entity is called a:

weak entity

Identify four sources of data errors.

APPENDING TRUNCATING TRANSCRIPTING TRANSPOSING

Which of the following is an example of a form?

Automized teller machine transaction layout

Which of the following is a guideline for designing forms and reports?

Balance the layout

The analysis technique that finds the amount of time required for the cumulative cash flow from a project to equal its initial and ongoing investment is referred to as:

Break-even analysis (BEA)

Identify two types of maintenance.

Corrective Maintenance Preventive Maintenance

What is meant by DFD completeness? What is meant by DFD consistency?

DFD completeness is the extent to which all necessary components of a data flow diagram have been included and fully described. DFD consistency is the extent to which information contained on one level of a set of nested data flow diagrams is also included on other levels.

Which of the following is NOT a rule for structuring data entry fields?

Data entries should not be justified.

Which of the following properties of a relation states that an entry at the intersection of each row and column is single-valued?

Entries in cells are simple.

A boundary is the point of contact where a system meets its environment or where subsystem meet each other. (True/False)

False

A business rule is an integrity constraint specifying that the value of an attribute in one relation depends on the value of the same attribute in another relation. (T/F)

False

A key can be redundant

False

A null value is used to represent the zero digit in a relation (T/F)

False

A relation is said to be in second normal form when there are no transitive dependencies. (T/F)

False

An interface separates a system from other systems.(True/False)

False

Assume shipment data are entered into a logbook once shipments are received at the company's warehouse; the logbook is represented on a data-flow diagram as a sink. (True/False)

False

Conceptual modeling is performed during systems design. (T/F)

False

Display sequence refers to the way a user can move from one display to another. (T/F)

False

Each entity type in an ER Diagram becomes an attribute (T/F)

False

Integration testing brings together all of the programs that a system comprises for testing purposes.(True/False)

False

Logic modeling graphically represents the processes that capture, manipulate store, and distribute data between a system and its environment and among components within a system. (True/False)

False

Processes, rather than data, are the most complex aspects of many modern information systems. (True/False)

False

The purpose of the testing and usability assessment section of a form design specification is to explain to those who will actually develop the final form why this form exists and how it will be used. (True/False)

False

Transitive attributes are attributes that determine other attributes (T/F)

False

Two different names used for the same attribute is called a homonym (T/F)

False

When modeling a many-to-many unary relationship, the primary key of the relation representing the relationship is always singular (T/F)

False

When structuring data entry fields, always have the user enter the current date. (T/F)

False

Briefly define and compare Gantt and Network diagrams.

Gantt charts are a bar chart that are the visual representation of the project schedule in a graphical representation and Network diagrams are the flow diagram view of the project schedule.

Traditional methods of collecting systems requirements include:

Interviews

A data-flow diagram that represents a system's major processes, data flows, and stores at a high level of detail refers to a:

Level-0 diagram

An attribute that can have more than one value for each entity instance is referred to as:

Multivalued attribute

Identify and briefly describe the four major SDLC phases.

Plannning is the first phase where project goals are set. Second is the Analysis phases where a business or organization needs are analyzed, and requirements are set. Design phase is third where the actual system is created and tested based on the requirements gathered from the second phase. And the fourth phase is the Implementation phase where the completed system is rolled out into service.

Which is the primary key(s) in the following STUDENT_GRADE( StudentID , CourseID , Grade)?

StudentID, CourseID

In which SDLC phase will the analyst study the organization's current procedures and the information's systems used to preform tasks?

System Analysis

Which of the following is NOT a true statement regarding a relation?

The columns may not be interchanged or stored any sequence.

Briefly identify four types of installation.

The four types of installations are direct, parallel, single location, and phased.

Which of the following properties should be satisfied when the identifier of the entity type becomes the primary key of the corresponding relation?

The value of the key must uniquely identify every row in the relation.

A binary 1 to many relationship in an ER Diagram is represented by adding the primary key of the entity on one side of the relationship as a foreign key to the entity on the many side. (T/F)

True

A data-flow diagram (DFD) is a graphical tool that allows analysts to illustrate the flow of data in an information system. (True/False)

True

A relation is in second normal form if every nonprimary key attribute is functionally dependent on the whole primary key (T/F)

True

Color, intensity, and size differences are methods of highlighting

True

Critical path scheduling is a scheduling technique whose order and duration of a sequence of task activities directly affect the completion date of a project. (True/False)

True

Data-flow diagrams evolve from the more general to the more detailed as current and replacement systems are better understood. (True/False)

True

Economic feasibility is a process of identifying benefits and costs associated with a development project. (True/False)

True

For a binary one-to-one relationship between two entities, A and B, the primary key of A becomes a foreign key in B and the primary key in B becomes a foreign key in A. (T/F)

True

Good interface design provides a consistent way for moving the cursor to different places on the form, editing characters and fields, moving among form displays, and obtaining help (T/F)

True

Good interface design provides a consistent way for moving the cursor to different places on the form, editing characters and fields, moving among form displays, and obtaining help.(True/False)

True

If an activity's optimistic time is 3 months, its realistic time is 5 months, and its pessimistic time is 10 months, then its estimated time would be 5.5 months. (True/False)

True

If for every valid value of A the value of B is determined by the value of A, then B is functionally dependent on A. (T/F)

True

In the systems development life cycle, it is possible to complete some activities in one phase in parallel with some activities of another phase.(True/False)

True

Indexes should be used generously for databases intended primarily to support data retrievals. (T/F)

True

Joint application design and prototyping can help keep the analysis effort at a minimum yet still effective. (True/False)

True

Modularity divides a system into chunks or modules of a relatively uniform size. (True/False)

True

Often, the initial prototypes of forms and reports are mock screens that are not working modules or systems. (T/F)

True

Outsourcing refers to turning over responsibility of some or all of an organization's information systems applications and operations to an outside firm.(True/False)

True

Referential integrity specifies that the value of an attribute of one relation depends on the existence of the same attribute in another relation. (True/False)

True

Site preparation is an example of a one-time cost. (True/False)

True

System documentation is the detailed information about a system's design specifications, its internal workings, and its functionality. (True/False)

True

The data on all data forms and reports must consist of data elements in data stores and on the E-R data model for the application or else be computed from these data elements. (True/False)

True

The end user is not the person in the organization most involved in the systems analysis and design process. (True/False)

True

The goal of operational feasibility is to understand the degree to which a proposed system will likely solve the business problems or take advantage of opportunities.(True/False)

True

The major outcomes and deliverables from project initiation and planning are the Baseline Project Plan and the Project Scope Statement. (True/False)

True

The primary deliverable for the conceptual data-modeling step within the analysis phase is an entity-relationship diagram.(True/False)

True

The project manager is responsible for initiating, planning, executing, and closing down the project. (True/False)

True

The purpose of the conceptual data model is to show as many rules about the meaning and interrelationships among data as possible.(True/False)

True

The size validation tests tests for too few or too many characters. (T/F)

True

The time value of money (TVM) compares present cash outlays to future expected returns.(True/False)

True

When choosing off-the-shelf software, cost, functionality, response time, and ease of installation are several of the common criteria that should be considered. (True/False)

True

When two relations, A and B, have a many-to-many relationship, we create a separate relation, C, to represent this. (T/F)

True

Written or other visual information about an application system, how it works, and how to use it best defines:

User documentation

For a binary many-to-many relationship existing between entity types A and B

a separate relation C is created; the primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship.

Critical path refers to:

a sequence of task activities whose order and durations directly affect the completion date of a project.

A binary one-to-many relationship in an E-R diagram is best represented by:

adding the primary key attribute (or attributes) of the entity on the one side of the relationship as a foreign key in the relation that is on the many side of the relationship

For a binary one-to-one relationship between two entities A and B, the relationship is represented by:

adding the primary key of A as a foreign key of B.

Assume the structure of a relation is Employee (EmpID, Name, Dept, Salary). The number of attributes for this relation would:

be four

Given the relation EMPLOYEE( ID# , LastName, ProjectID, ProjectName) and ProjectID can determine ProjectName, but not last name, the relation violates:

3 normal form

. Discuss unary, binary, and ternary relationships.

: A unary relationship is when both participants in the relationship are in the same entity. A binary relationship is when two entities participate with each other. A ternary relationship is when three entities share the same relationship