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