MIS 3301 Chapters 7,8,9,10,11 Exam 3
The architectural components of any system are the network and the hardware.
False
The only skills that are applied during systems projects are functional.
False
The standard method language for accessing the data in relational database tables is: SQL - Standard Query Logic.
False
There are three advantages associated with client-server architecture.
False
When converting a logical ERD into a physical data model, you will want to specify both primary keys and international keys.
False
When drawing the human-machine boundary, all processes in the physical DFD will be automated, so only external entities will be excluded.
False
In most cases, decision support systems are best at:
Finding aggregated data
When you join two relational database tables together, frequently the primary key in one table will be a ____________ in the other table.
Foreign key
A ___________ is used when fields are numeric or contain coded data.
Format check
What is/are the disadvantage(s) associated with n-tiered architecture?
Great load on the network and when the clients capture keystrokes and the very first architecture system
Processes from logical DFDs might show up on a physical data flow diagram as:
HTML screens or Visual Basic forms
The purpose of creating physical ERDs is to:
Show implementation details and to explain more about the 'how' of the final system
Although TJ did a lot of work normalizing the database so that it is in third normal form (3NF), he may want to 'denormalize' it so that access might be faster.
True
An afferent process is an input process on a structure chart.
True
An example of a cultural requirement would be offering the system in English and Spanish.
True
Application Software Providers (ASPs) should be utilized when considering non-core programming and/custom needs.
True
This term in the computing domain which refers to the creation of devises or storage with the use of software and not hardware is:
Virtualization
There are two symbols that describe special types of control in a structure chart. They are a curved arrow and a diamond. These symbols represent _____ and _____.
loop, conditional line
A reason to use custom development is to get exactly what you want?
True
Which of the following is not a RDBMS?
NoSQL
Workarounds are:
Not supported by a vendor who supplied the software
A relational database that is used extensively in data warehousing is a multidimensional database.
True
A transaction structure in a structure chart contains a control module that calls subordinate modules and frequently occur with menus.
True
Project teams often _________ the ________ associated with creating secure, efficient client-server applications.
Underestimate; Difficulty
The fourth step in creating a Physical Data Flow Diagram is:
Update the data elements in the data flows
Outsourcing firms called _____________ supply software applications and/or software related services through the Internet.
Application Service Providers (ASPs)
This type of file records "before" and "after" images of data as the data gets altered.
Audit files
A _______________ is an outline of the steps that the users perform to accomplish some part of their work
Use Scenario
Systems that support decision making will probably:
Usually just read data - and often in ad hoc ways
The cost of development associated with Client-Based systems is:
Very High
Fixed-price contracts are considered:
Very rigid
There are many types of reports, they include:
all of these are outputs
Approximately _______ percent of men are color blind (and thus improper use of color can impair their ability to read information)
10%
There are _____ primary hardware components of a system.
3
Which is NOT true about the content awareness design principle?
A date of 8/6/09 will be understood internationally
Pseudocode is:
A detailed outline of the lines of code that need to be written
A default value is:
A value that probably occurs most frequently
Form(s) of network connection(s) in a system include:
ATM & DSL
The three types of basic processes on a process model:
Afferent, central and efferent processes
Thick clients contain:
Almost all or most of the application logic.
Many ________ tools like ERwin can help you with database size information and the calculation of volumetrics.
CASE
A ___________ is used when an extra digit is added to a coded field to make sure it the entered data is correct (like social security numbers).
Check digit check
A ___________ is used when several fields must be entered before the form can be processed.
Completeness check
Typically, the fourth step in the user interface design process is:
Creating an interface design prototype
Typically, the third step in the user interface design process is:
Design interface standards
Typically, the second step in the user interface design process is:
Develop the interface structure diagram (ISD)
The CRUD matrix shows
Exactly how data are used and created by the major processes in the system
A DSS is a design support structure and does the 'ETL' (extract, transform and load) to create data warehouses.
False
A great advantage of object oriented database management systems is their easy of learning.
False
Aesthetics refers to designing information that can be navigated in three-clicks or less.
False
An ATM dialing a network provides the IT department with a quick cash withdrawal for emergency purposes.
False
An effective process is an output process on a structure chart.
False
Because project teams rely more on packaged software, program design is no longer needed.
False
Brian wants an e-commerce system to be able to do a lot of rapid processing - like search for particular keywords in documents; return the price of an item; update quantities in the shopping cart. He is probably building an Expert System.
False
Client-based architecture is complex and there is minimal chance of network circuits being overloaded due to growing network applications.
False
Colors and patterns add pizzazz to a screen form and aid in its readability.
False
Couples in structure charts always show two modules that are executed together and are drawn with horizontal lines at the top and bottom.
False
Data marts are larger, aggregated legacy databases.
False
Experienced users prefer user interfaces with 'ease of learning' features.
False
Generally headings on a paper form should be with Arial size 24 bold; the main text should be Times New Roman size 12. Subheadings should be Tahoma size 14, bold and italic and underlined. This makes a form easier to read and to delineate sections.
False
Generally, transaction structures occur at lower levels of a structure chart.
False
If the expertise needed to build a system are not readily available that is a good reason to buy a packaged software solution
False
In the analysis phase, architecture decisions are made and written up in the 'hardware and software specifications'.
False
Informix is a pure OODBMS package.
False
Many of the data stores in the logical DFD will be changed into encrypted word processing documents when a physical DFD is developed.
False
Range checks will validate if the data is numeric with two decimal places.
False
Systems to support decision making generally need to update data frequently with a large volume of data.
False
The scalability associated with Client-Server systems is:
High
As a structure chart is constructed, it is generally best to build modules with:
High cohesion
Interface evaluations almost always ______________.
Identify improvements
Another name for custom development might be:
In-house development
The ______________ defines the basic components of the interface and how they work together to provide functionality to users.
Interface structure design
In most automated cases, data stores from logical DFDs will be converted to:
Into database files / tables
Client-server architectures tend to be:
Less expensive than client-based architectures
Which of the following is a concept not generally associated with decision support systems?
Object orientation
A use scenario is one commonly used ________________.
Path through a use case
Client-server architecture holds the client responsible for_____ and server is only responsible for _____.
Presentation Logic; Data Access Logic and Data Storage
For efficiency purposes, it is wise to___________ when there is a basic software need to be satisfied.
Purchase a packaged system
If (a) the business need is common; (b) the skills needed are not strategic; (c) the time frame is short; it might be best to:
Purchase a software package
Which of the following lists indicates the correct ordering of deliverables in a system specification document?
System Acquisition Weighted Alternative Matrix, Interface Design, Physical Data Model Data Storage Design
In the initial stage of design, what are business requirements converted into?
System Requirements
The project team is very knowledgeable about relational database management systems. In terms of feasibility, this might be best known as:
Technical feasibility ('can we build it')
When designing navigational controls, which is NOT commonly assumed?
That users have knowledge of the system and the interface
In what SDLC stage do we determine the business needs for an information systems project?
The analysis phase
Which is probably true about packaged software
The business need is common
Outsourcing is used when:
The business need is not the core to the business.
One problem with using packages software systems is:
The company has to accept the functionality that is provided with the system
An n-tiered architecture is distinguished by:
The number of specialized server computers
A CRUD matrix shows exactly how data are used and created by major processes in the system.
True
A common need to the business should be satisfied by contracting with an Application Service Provider (ASP).
True
A good indication of needing a transaction structure on a structure chart occurs when a DFD shows a single data flow entering a process that produces multiple data flows as outputs.
True
Which is NOT true of structure charts?
They show the user interface
In Use Scenario Development, the goal is:
To describe the most commonly occurring use scenarios
Because (a) preexisting code needs to be understood, organized, and pieced together; and (b) it is still common for the project team to have to write some code and adapt packages to the business environment, it is therefore good for analysts to fully understand program design.
True
CASE repository entries are updated to reflect specific technology decisions as they are made.
True
Client computers, Servers and Networks are the three primary hardware components of a system.
True
Client-server scalability is greater than server-based scalability.
True
Control couples show the passing of parameters or system related messages between modules (like 'end-of-file').
True
Data storage, Data Access Logic, Application Logic and Presentation Logic are the four basic functions of software systems.
True
During the design phase, the project team carefully considers the nonfunctional business requirements (such as performance, cultural and political aspects).
True
During the initial part of design, the project team converts the business requirements for the system into system requirements.
True
Factoring is the process of separating out a function from a module in order to create a module of its own.
True
If the density on a single page form is too high, it might not be as effective for some users as creating a two-page form.
True
Jamal is creating a user interface. He wants what he calls an 'oops' button on every screen and form (or an 'undo' button). This is a good design consideration.
True
Jasmine is an example of an object-oriented database system.
True
Jim is working from a leveled DFD and creating structure charts. He is finding that the lower levels of the DFD generally correspond to transform structures.
True
Maria is working for the Minneapolis Dance Troop (MDT) and wants a database that can support text, numbers, video, and audio. She will probably select the multidimensional database format.
True
Outsourcing requires the least in-house resources.
True
Rachel wants aggregated data like find the number of banking customers who have savings accounts over $100,000 and home mortgages with her bank. She probably wants to use a Decision Support System.
True
The cost differential between maintaining client-server applications and server-based applications will be offset with organizational experience.
True
The design phase is the time to select the specific software that will operate the hardware.
True
The first principle of designing navigational controls is to prevent users from making mistakes.
True
The score column in the Alternative Matrix represents how easily specific criteria are met by the alternative.
True
When changing from logical data models to physical data models, you will want to change the attributes of the logical ERD to fields in the physical ERD.
True
When changing logical data models to physical data models, you will want to change entities to tables or files.
True
_____ refers to how well the lines of code within each module in a structure chart relate to each other.
cohesion
Reusable modules, which are represented in the structure chart as rectangles with vertical lines on both sides, may often appear several times in a structure chart. These are called _____ modules.
library
