SYSTEMS ANALYSIS & DESIGN Chapter 9
Gartner, Inc. predicts that by 2015 SaaS revenue will grow to ____.
$22.1 billion
Evaluate the alternatives
- Existing users - Application testing - Benchmarking
Microsoft's ____ is one of the major Web-based development environments.
.NET
Computing Devices
1. server 2. personal computing devices or clients (desktops, laptops tablets)
Text box
A box that accepts text from a keyboard or speech input
C) data store
A computer-based file containing employee information is represented on a data flow diagram as a: A) data flow B) source C) data store D) process
Data Structures
A framework for organizing, storing and managing data. Consists of files or tables that interact in different ways
Simple Message
A message that transfers control from the sender to the recipient without describing the details of the communication.
Entity
A person, place, thing or event for which data is collected and maintained
Data flow diagram (DFD)
A picture of the movement of data between external entities and the processes and data stores within a system.
Binary relationship
A relationship between instances of two entity types. This is the most common type of relationship encountered in data modeling.
Homonym
A single attribute name that is used for two or more different attributes.
Field
A single characteristic or fact about an entity, also called an attribute.
Synchronous message
A type of message in which the caller has to wait for the receiving object to finish executing the called operation before it can resume execution itself.
eBay employs the ___ auction mechanism. A. Forward B. Reverse C. Dutch D. Proprietary eBay
A. Forward
Web-based Application
An application that uses a browser for the user interface.
Optional attribute
An attribute that may not have a value for every entity instance.
Multivalued attribute
An attribute that may take on more than one value for each entity instance.
False
Application software that usually executes with a browser is often just called an "App".
Both the sellers and buyers are business organizations. *Represents the vast majority of e-commerce
B2B
Outsourcing a basic business process is often called ____.
BPO
A) decouples the processe
By placing a data store between two processes, this: A) decouples the processes B) enables store and forward capabilities C) enhances the flow of data between the processes D) structures the processes
derivation codes
Combine data from different item attributes, or characteristics
Software requirements specification
Contains the requirements for the new system, describes the alternatives that were considered and makes a specific recommendation to management
Data administrator
DA. The person in charge of the structure and integrity of the data
A practice of registrants using the five-day "grace period" at the beginning of a domain registration to profit from pay-per-click advertising.
Domain Tasting
What are some common ways to evaluate the alternatives?
Existing Users Application testing Benchmarking
Cybersquatting refers to the tampering of existing Web sites and selling unrelated products. True False
False
Object-oriented systems can send messages to a legacy system through the use of a package wrapper.
False
C) balancing
If a data flow appears on the context diagram and is also represented at level-0, this would be referred to as: A) leveling B) flow conservation C) balancing D) matching
C) complete
If your DFD contains data flows that do not lead anywhere, it is not: A) gap proof B) a primitive diagram C) complete D) consistent
True
In a client/server configuration, it is possible for a single software component to be both client and server.
Domain Layer
In a three-layer architecture, another name for the business logic layer is what?
What are some common financial analysis tools?
Payback analysis Return on investment Net present value
Summary reports
Reports that summarize detail or recap periodic activity
Storyboarding
Sequence of sketches of the display screen during a dialogue
What are the benefits of user applications?
Simple low-cost solutions
____ reduces the customer's need for software maintenance, operation, and support.
Software as a Service
Disjoint rule
Specifies that if an entity instance of the supertype is a member of one subtype, it cannot simultaneously be a member of any other subtype.
True
The Internet can be thought of as the network of networks.
Logical design
The definition of an information system's functions and features, and the relationships among its components
Primitive DFD
The lowest level of decomposition for a DFD
Primitive DFD
The lowest level of decomposition for a DFD.
D) primitive diagram
The lowest level of decomposition for a data flow diagram is called the: A) context diagram B) level-0 diagram C) level-1 diagram D) primitive diagram
Parent process
The process on Diagram 0.
Activation
The time period during which an object performs an operation.
Net Present Value (NPV)
The total value of the benefits minus the total value of the costs, with both costs and benefits adjusted to reflect the point in time at which they occur
Net present value (NPV)
The total value of the benefits minus the total value of the costs, with both the costs and benefits being adjusted to reflect the point in time at which they occur
Preconditions
Things that must be true before a use case can start.
Payback Analysis
To determine how long it takes an information system to pay for itself through reduced costs and increased benefits
Affordance
When the appearance of a specific control suggest it's functions
The set of world wide resources that are available over the Internet.
When you use the term "Web", what is the correct definition?
D) All of the above.
Which of the following is a true statement regarding sources/sinks? A) Sources/sinks are always outside the information system and define the boundaries of the system. B) Data must originate outside a system from one or more sources. C) The system must produce information to one or more sinks. D) All of the above.
B) A data flow can go directly back to the same process it leaves.
Which of the following is not a true statement regarding data flows? A) A fork in a data flow means that exactly the same data goes from a common location to two or more different processes, data stores, or sources/sinks. B) A data flow can go directly back to the same process it leaves. C) A data flow has a noun phrase label. D) A data flow has only one direction of flow between symbols.
Www
World Wide Web. An interconnected set a resources accessed via the Internet
physical design
a plan for the actual implementation of the system
fixed fee model
a service model that charges a set fee based on a specified level of service and user support
subscription model
a service model that charges a variable fee for an application based on the number of users or workstations that have access to the application
logical record
a set of field values that describes a single person, place, thing, or event
first normal form
a table is in _____ ______ ____ if it does not contain a repeating group
evaluation model
a technique that uses a common yardstick to measure and compare vendor ratings
counterbalancing
a technique used to control for sequencing effects
list box
a text box that contains a list of predefined data values
cloud computing
an online software and data environment in which applications and services are accessed and used through an internet connection rather than on a local computer
managed hosting
an operation is managed by the outside firm, or host. another term for internet business service
retrospective verbal report
an oral report in which the participant retrospectively recalls aspects of the experiment
Context diagram
an overview of an organizational system that shows the system boundaries, external entities that interact with the system, and the major information flows between the entities and the system.
metaphors
analogies between features of the user interface and aspects of physical reality that users are familiar with
In the accompanying figure, any field that could serve as a primary key is called a ____.
candidate key
child diagram
cannot produce output or receive input that the parent process does not also produce or receive.
category codes
codes that identify a group of related items
database manipulation language
controls database operations, including storing, retrieving, updating, and deleting data
java database connectivity
enables java applications to exchange data with any database that uses SQL statements and is JDBC- compliant
deception
giving the participant a bogus rationale for the experiment
system interfaces
inputs or outputs that require minimal human intervention
derived element
it must be created by a process and should be output from at least one process into which it is not input. . Elements that are not keyed but are rather the result of a calculation or logical operation are called
An IBS solution is attractive to customers because...
it offers online data center support, mainframe computing power for mission-critical functions, and universal access via the Internet
double-blind placebo method
neither the experimenter nor the research participant is aware of the treatment condition administered to the participant
Any field that is not a primary key or a candidate key is called a ____ key.
nonkey
Cloud Computing
replacing computing with services provided over the internet
external outputs
reports or other outputs produced for use by people outside the organization
internal outputs
reports or other outputs produced for use within the organization
detailed reports
reports that contain specific information on business transactions
exception reports
reports that provide details or summary information about transactions or operating results that fall outside a predefined normal range of values
summary reports
reports that summarize detail or recap periodic activity
executive reports
reports used by highlevel managers to assess overall organizational health and performance
Internet Protocol (IP)
routing protocol in charge of forwarding packets on the internet
storyboarding
sequence of sketches of the display screen during a dialog
randomized counterbalancing
sequence order is randomly determined for each individual
A firm that offers outsourcing solutions is called a ____ provider.
service
Some ____ providers concentrate on specific software applications; others offer resources like order processing and customer billing.
service
When companies acquire Web-based software as a(n) ____, they can limit in-house involvement to a minimum.
service
internet business services
services that provide web based support for transactions such as order processing, billing, and crm
check boxes
similar to radio buttons, but the user can select multiple items within the group
Local area network (LAN)
small network for single site
assistive technologies
software (such as text-to-speech and voice-recognition utilities) that adapts user interfaces to the special needs of persons with disabilities
Web service
software function or related set of functions that can be executed via Web standards
middleware
software that connects dissimilar applications and enables them to communicate and exchange data
middleware
software that integrates different applications and allows them to exchange data and interpret client requests in HTML form; then translate the requests into commands that the database can execute
Open Source Software (OSS)
software that is free and where anyone can look at and potentially modify the code
software package
software that is purchased or leased from another firm
application software
software that performs user or business-specific tasks and is typically constructed as an app or Web-based application.
system software
software, such as operating systems and Web server software, that works behind the scenes to support application software and control or interact with hardware or software resources
audit fields
special fields within data records to provide additional control or security information
make or buy
the choice between developing in house software and purchasing software often is called a make or buy, or build or buy, decision
logical design
the definition of an information system's functions and features, and the relationships among its components
matching variable
the extraneous variable used in matching
economy of scale
the inherent efficiency of high-volume processing on larger computers is called
data layer
the part of a three-layer architecture that interacts with the data
What is a fixed fee model?
uses a set fee based on a specified level of service and user support
Hybrid TCP / IP-OSI Architecture
- Layer 5 : Application (HTTP) - Layer 4 : Transport (TCP) - Layer 3 : Internet (IP) - Layer 2 : Data Link - Layer 1 : Physical
Connections Architecture
- Layer 5 : How two applications work with each other - Layer 4 : End-to-End communications between the two end hosts - Layer 3 : Route through a routed network (internet) - Layer 2 : Data Link through a single switched network - Layer 1 : Physical link between adjacent devices
Two Major Protocols
1. Ethernet 2. Tranmission Control Protocol / Internet Protocol
Internet Protocol Suite consists of :
1. Transmission Control Protocol (TCP) 2. Internet Protocol (IP)
Level-n diagram
A DFD that is the result of n nested decompositions from a process on a level-0 diagram
data structure
A ____ _________ Consists of files or tables that interact in various ways
Form
A business document that contains some predefined data and may include some areas where additional data are to be filled in. An instance of a form is typically based on one database record.
Service desk
A centralized resource started by IT professionals that provides users with the support they need to do their jobs. Also called a help desk
Build or buy
A choice between developing in-house software and purchasing software
Data type
A coding scheme recognized by system software for representing organizational data.
Heterogeneous Distributed Database
A database distributed across multiple locations with different DBMSs and with local access allowed without global schema coordination
Network diagram
A diagram that shows how hardware components are interconnected with devices and cabling is called a what?
What is a request for proposal?
A document that describes the company, lists the IT services needed or products needed, and specifies the features required
Value-Added Reseller (VAR)
A firm that enhances a commercial package by adding custom features and configuring it for a particular industry
Evaluation and selection team
A group of people involved in selecting hardware and software. The group includes systems analysts and users. A team approach ensures that critical factors are not overlooked and that a sound choice is made
Decision table
A matrix representation of the logic of a decision, which specifies the possible conditions for the decision and the resulting actions.
False
A network diagram and a location diagram show basically the same information but in a different format.
C) verb phrase label
A process has a: A) pronoun label B) adjective label C) verb phrase label D) noun phrase label
Third Normal Form (3NF)
A restriction that a table is in 2NF and that no non-key attribute is functionally dependent on any other non-key attribute
Subscription model (outsourcing)
A variable fee based on the number of users or workstations that have access to the application
Triggering operation (trigger)
An assertion or rule that governs the validity of data manipulation operations such as insert, update, and delete; also called a trigger.
Relationship
An association between the instance of one or more entity types that is of interest to the organization.
Candidate Key
An attribute or set of attributes that are unique identifiers and could serve as the primary key
Derived attribute
An attribute whose value can be computed from related attribute values.
Database (DB)
An integrated collection of stored data that is centrally managed and controlled
Functional decomposition
An iterative process of breaking the description of a system down into finer and finer detail, which creates a set of charts in which one process on a given chart is explained in greater detail on another chart.
Functional decomposition
An iterative process of breaking the description of a system down into finer and finer detail, which creates a set of charts is explained in greater detail on another chart
Forum
An online discussion on a particular topic, where people meet, offer support, and exchange ideas
The sellers are organizations and the buyers are individuals
B2C
Software vendors
Companies that develop software for sale
Metadata
Data about data, also called schema data
significant digit codes
Distinguish items by using a series of subgroups of digits Postal codes are significant digit codes
Trigger
Event that initiates a use case.
In order to be considered as an e-commerce Web site, the site must sell some tangible good. True False
False
The stock market is the only area of business that has experienced fraud on the Internet. True False
False
B) violation of consistency
Having a level-1 diagram with no level-0 diagram is an example of a: A) violation of completeness B) violation of consistency C) gap D) structuring violation
Human-Computer interaction
Hci. A field of study concerned with the efficiency and effectiveness of user interfaces via computer systems, human-oriented input and output technology, and psychological aspects of the user interface.
A) indifferent condition
In a decision table, a condition whose value does not affect which actions are taken for two or more rules is referred to as a(n): A) indifferent condition B) static condition C) fixed condition D) flexible condition
Indifferent condition
In a decision table, a condition whose value does not affect which actions are taken for two or more rules.
Gateway
In business modelling, a decision point.
C) process
In the Gane and Sarson model, a rectangle with rounded corners on a data flow diagram represents a: A) data store B) data flow C) process D) source/sink
What are two major web-based development environments?
Microsoft's .net IBM's WebSphere
In what type of e-commerce business model do customers decide how much they want to pay
Name-your-own-price
Row (Tuple) (Record)
One horizontal group of data attribute values in a table
Partitioning
Processes are put together and automated if analysis dictates they do so. Manual processes are put together, and automated processes can also be paired with each other.
Which one in the following is NOT a factor for selecting a design strategy?
Software quality
Child Diagram
The diagram that results from exploding the process on Diagram 0 (called the parent process).
DFD completeness
The extent to which all necessary components of a DFD have been included and fully described.
Offshore outsourcing, or global outsourcing, refers to what?
The practice of shifting IT development, support, and operations to other countries
Denormalization
The process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields.
entity-relationship diagram
a model that shows the logical relationships and interaction among system entities
concurrent verbal report
a participant's oral report of the experiment, which is obtained as the experiment is being performed
return on investment
a percentage rate that measures profitability by comparing the total net benefits received from a project to the total costs
Hypertext Markup Language (HTML)
a protocol that defines the structure and content of a Web page
forum
an online discussion on a particular topic
HTML (hypertext markup language)
protocol for the structure of content of a web page
An advantage of purchasing packaged software is that the organization can _____.
save money on the purchase
base element
that is initially keyed into the system, such as a customer name, address, or city and must be stored in files
XML (extensible markup language)
an extension of HTML that enables defining semantics of tags
data store
are created for each different data entity being stored
Exchanges have many
buyers and sellers
Some industry leaders predict that ____ computing will offer an overall online software and data environment supported by supercomputer technology.
cloud
abbreviation codes
codes that are alphabetic abreviations (MIA for Miami)
action codes
codes that indicate what action is to be taken with an associated item
cipher codes
codes that use a keyword to encode a number
When a primary key combines two or more fields, it is called a ____ key.
composite
statistical control
control of measured extraneous variables during data analysis
randomization
control technique that equates groups of participants by ensuring every member an equal chance of being assigned to any group
The ___ layer addresses the issues involving the persistence of the objects contained in the system.
data management
Which one in the following is NOT a layer of a software architecture.
data structure
Sampling error
error between a sample statistic and it's coresspnding population paramiter
field (attribute)
is a single characteristic or fact about an entity
Domain name service
is hierarchical system of name-servers that maps host-domain name combinations to IP addresses
During the systems design phase, ____ fields are used to organize, access, and maintain data structures
key
Internet Backbone
made of fiber optic lines, is very fast
unicode
more recent coding standard that uses two bytes per character rather than one. Supports virtually all languages and has become a global standard
To avoid the classic design mistake of "feature creep," the analyst should ___.
move proposed changes into future versions
An electronic mall represents ____________.
multiple stores
Data Flow Diagrams
Graphically characterize data processes and flows in a business system. Depicts: - System inputs - Processes - Outputs
A gift card is a(n) ____________.
stored value money card
A data ____, which is a framework for organizing and storing data, consists of one or more files or tables.
structure
When determining outsourcing fees, a ____ has a variable fee based on the number of users or workstations that have access to the application.
subscription model
user interfaces
system interfaces that directly involve a system user
experimenter effects
the biasing influence that can be exerted by the experimenter
Rules
the part of a decision table that specifies which actions are to be followed for a given set of conditions
normalization
the process of creating table designs by assigning specific fields or attributes to each table in the database
Gap analysis
the process of discovering discrepancies between two or more sets of DFD's or discrepancies within a single DFD.
C) process modeling
Graphically representing the functions, or processes, which capture, manipulate, store, and distribute data between a system and its environment and between components within a system refers to: A) data modeling B) flow charting C) process modeling D) transition modeling
In what type of e-commerce business model do small buyers aggregate demand to get a large volume; then the group conducts tendering or negotiates a lower price
Group purchasing
C) numbering
Guidelines for drawing DFDs include the following except for: A) completeness B) consistency C) numbering considerations D) timing considerations
Human-interface objects
HIOs. Icons and other objects on a screen that can be manipulated by the user and cause some action to occur
Hypertext markup language
HTML. A protocol that defines the structure and content of a web page
cardinality notation
uses special symbols to represent the relationship
matching
using any of a variety of techniques for equating participants on one or more variables
affordance
when the appearance of a specific control suggests its function
Hypertext transfer protocol
HTTP. A protocol that defines the format and content of requests for web documents and related data communication
Internet backbone Network
High capacity and high speed computer network that carries large amounts of internet traffic across regions, countries, and continents
Some firms offer ____, which provide powerful Web-based support for transactions such as order processing, billing, and customer relationship management.
IBS
What should be done during the evaluate the information systems requirements step?
Identify key features Consider network and related issues Estimate volume and future growth Specify hardware, software, or personnel constraints Prepare a request for proposal or quotation
B) the number of rules is reduced by condensing Rules 2, 4, and 6 into one rule
If Rules 2, 4, and 6 are indifferent conditions, then: A) Rules 2, 4, and 6 are eliminated from the matrix B) the number of rules is reduced by condensing Rules 2, 4, and 6 into one rule C) Rules 2, 4, and 6 will result in at least two additional rules being included in the matrix D) Rules 2, 4, and 6 have no impact on the interpretation of the matrix
A) appear on the context diagram
If an input from a source appears at level-0, it must: A) appear on the context diagram B) be connected to a data flow C) be connected to a sink D) be connected to a data store
Use case
In UML, a sequence of transactions in a system; the purpose is to produce something of value to an actor in the system; focuses on what the system does rather than on how it does it. The use case model is based on the interactions and relationships of individual use cases. In a use case, an actor using the system initiates an event that begins a related series of interactions in the system.
False
In a client/server configuration the term "server" refers to the central computer equipment that houses the core resources.
B) gateway
In business process modeling, a decision point is called a(n): A) activity B) gateway C) terminal D) loop
A) swimlane
In business process modeling, a way to encapsulate a process is called a(n): A) swimlane B) fastlane C) lane D) none of the above
Event
In business process modelling, a trigger that initiates the start of a process.
Pool
In business process modelling, a way to encapsulate a process that has two or more participants.
Swimlane
In business process modelling, a way to visually encapsulate a process.
Activity
In business process modelling, an action that must take place for a process to be completed.
Flow
In business process modelling, it shows the sequence of action in a process.
A) data store
In the Gane and Sarson model, a rectangle that is missing its right vertical sides on a data flow diagram represents a: A) data store B) data flow C) process D) source/sink
The company's IT department makes, builds, and develops _______________ A ____________ is obtained from a vendor or application service provider
In-house software Software package
User interface
Includes screens, commands, controls, and features that enable users to interact more effectively with an application
What is user interface?
Includes screens, commands, controls, and features that enable users to interact more effectively with the application
A logical data flow diagram:
Is a model of how the business operates.
What are the seven steps for a cost-benefit checklist?
List each strategy being considered Identify costs and benefits for each Consider future growth Include support costs for hardware and software Analyze various software licensing options, including fixed fees and formulas Apply the financial analysis tools to each alternative Study results and prepare report
A ___________ defines what must take place, not how it will be accomplished A ____________ is like a set of blueprints for the actual construction of a building
Logical Physical
Why do companies purchase software?
Lower Costs Requires less time to implement Proven reliability and performance benchmarks Requires less technical development staff Future upgrades are provided by the vendor Input from other companies
Continuity
Maintaining a certain level of consistency over time across multiple releases
The choice between developing versus purchasing software is often called what?
Make or buy, build or buy, decision
Benchmark
Measures the time a package takes to process a certain number of transactions.
What type of e-commerce business model allows only members to use the services provided
Membership
Document metaphor
Metaphor in which data is visually represented as paper pages or forms
Direct manipulation metaphor
Metaphor in which objects on a display are manipulated to look like physical objects or graphic symbols that represent them
Desktop metaphor
Metaphor in which the visual display is organized into distinct regions with a large empty work space in the middle and a collection of tool icons around the perimeter
Dialogue metaphor
Metaphor in which user and computer accomplish a task by engaging in a conversation or dialogue via text voice or tools such as labeled buttons
____ promotes a broader vision of Software + Services, which refers to the company's strategy for cloud computing -- integrating software applications, platforms, and infrastructure.
Microsoft
Refers to e-commerce that is conducted in a wireless environment.
Mobile Commerce
What are the benefits of application software?
More powerful Flexible User friendly
Request for Quotation
More specific than a RFP. Only price quotations or bids are needed, since the specific product or service is already known.
A process in which a company integrates its offline and online channels.
Multichanneling
sequence codes
Numbers or letters assigned in a specific order Contain no additional information other than an indication of order of entry into the system
____ is an industry-standard protocol that makes it possible for software from different vendors to interact and exchange data.
ODBC
D) both A and B
On a data flow diagram, you may: A) repeat data stores B) repeat sources/sinks C) repeat processes D) both A and B
Attribute (Field) (Column)
One vertical group of data attribute values in a table
In what type of e-commerce business model do companies run auctions of various types on the internet
Online auctions
In what type of e-commerce business model do manufacturers or retailers sell directly to customers.
Online direct marketing
Oracle Corporation offers a service called ____, which provides e-business applications on a fixed fee basis.
Oracle On Demand
Involves finding the product to be shipped; packaging the product; arrange for speedy delivery to the customer; and handle the return of unwanted or defective products.
Order fulfillment
What are some service provider functions?
Order processing Customer Billing Enterprise wide software solutions such as accounting, inventory control, manufacturing
____ is the transfer of information systems development, operation, or maintenance to an outside firm that provides these services, for a fee, on a temporary or long-term basis.
Outsourcing
______________ determines how long it takes an information system to pay for itself through reduced costs and increased benefits _____________ is a percentage rate that compares the total net benefits received from a project to the total costs of the project _____________ of a project is the total value of the benefits minus the total value of the costs, with both costs and benefits adjusted to reflect the point in time at which they occur
Payback analysis Return on investment net present value
Stakeholder
People who have a vested interest in the system being developed.
A form of e-cash that enables two individuals or an individual and a business to transfer funds without using a credit card.
Person-to-person Payments
Level
Perspective from which a use case description is written, typically ranging from high level to extremely detailed.
Level
Perspective from which a use case description is written, typically ranging from high-level to extremely detailed.
Appears underneath the active window
Pop-under Ad
Appears in front of the current browser window.
Pop-up Ad
Internet Business Services (IBS)
Powerful web-based support for transactions such as order processing, billing and customer relationship management
User application
Programs that utilize standard business software, such as Microsoft office, which has been configured in a specific manner to enhance user productivity
Electronic marketplace in which there are many sellers and many buyers, and entry is open to all; it is frequently owned and operated by a third party
Public Exchange
What are three ways to customize a software package?
Purchase a basic package that vendors will customize to suit the project's needs Negotiate directly with the software vendor to make enhancements to meet the project's needs by paying for changes Purchase the package and make project-specific modifications
Traditional Development
- Compatibility issues influence systems design - Systems are designed to run on local and wide area company networks - Systems often utilize Internet links and resources, but web-based features are considered to be enhancements rather than core elements - Development is either in-house development, purchase of a software package with possible modification or use of outside consultants - Scalability can be effected by network limitations and constraints -Many applications require substantial desktop computing power and resources - Security issues are usually less complex
DFD Levels
- Data flow diagrams are built in layers - The top level is the context level - Each process may explode to a lower level - The lower level diagram number is the same as the parent process number - Processes that do not create a child diagram are called primitive
Evaluate Information System requirements
- Identify key features - Consider network and web-related issues - Estimate volume and future growth - Specify hardware, software or personnel constraints - Prepare a RFQ or RFP
Rules for DFDs
- Must have one process - Must not be any freestanding objects - A process must have input/output - A data store must be connected to at least one process. - External entities should not be connected to one another.
Web-Based Development
- Systems are developed and delivered in an Internet-based framework such as .NET - Internet-based development treats the web as the platform and not just the communication channel - Web-based systems are easily scalable and can run on multiple hardware environments - Large firms tend to deploy web based systems as enterprise wide software solutions - Software application is less dependent on desktop power and resources - SAAS limits in-house involvement and vendors can install, configure and maintain the system - Includes additional layers called middleware to communicate with existing software and legacy systems - More complex security issues
Diagram 0
- The explosion of the context diagram - May include up to nine processes - Each process is numbered - Major data stores and all external entities are included - Start with the data flow from an entity on the input side - Work backward from an output data flow - Examine the data flow to or from a data store - Analyze a well-defined process - Take note of any fuzzy areas
Three-Layer Architecture
-client / server architecture with application divided into view layer, logic layer, and data layer 1. view layer - user interface 2. logic layer - program logic to implement the functions 3. data layer - functions to access the data
DFD development process
1. Make a list of business activities and use it to determine various - External entities - Data flows - Processes - Data stores 2. Create a context diagram that shows the external entities and data flows to and from the system. Do not show any detailed processes or data stores. 3. Draw Diagram 0, the next level. Show processes, but keep them general. Show data stores at this level. 4. Create a child diagram for each of the processes in Diagram 0. 5. Check for errors and make sure the labels you assign to each process and data flow are meaningful. 6. Develop a physical data flow diagram from the logical data flow diagram. Distinguish between manual and automated processes, describe actual files and reports by name, and ass controls to indicate when processes are complete or errors occur. 7. Partition the physical data flow diagram by separating or grouping parts of the diagram in order to facilitate programming and implementation.
Eight Types of Web sites for Advertising
1. Portals: most popular; best for reach but not targeting 2. Search: second largest reach, high advertising value 3. Commerce: high reach, not conducive to advertising 4. News/weather/sports: poor target ability 5. Entertainment: large reach, strong target ability 6. Community: emphasize being a part of something; good for specific advertising 7. Communications: not good for branding; low target ability 8. Games: good for very specific types of advertising
Customizing a software package
1. Purchase a basic package that vendors will customize to suit the project's needs 2. Negotiate directly with the software vendor to make enhancements 3. Purchase the package and make project-specific modifications if the software license permits it
Reasons for in house development:
1. Satisfy unique business requirements 2. Minimize changes in business procedures and policies 3. Meet constraints of existing systems & technology 4. Develop internal resources and capabilities 5. Satisfy unique security requirements
The three types of Electronic Exchanges
1. Vertical Exchanges: connect byers and sellers in a given industry 2. Horizontal Exchanges: connect buyers and sellers across many industries and are used mainly for MRO materials 3. Functional Exchanges: needed services such as temporary help or extra office space are traded on an as-needed basis
steps in the software acquisition process
1. eval the info systems requirements 2. identify potential vendors or outsourcing options 3.evaluate the alternatives 4. perform cost benefit analysis 5. prepare a recommendation 6. implement the solution
B) has only inputs
A black hole is one that: A) has only inputs B) has only outputs C) has not been exploded to show enough detail D) has insufficient inputs to produce the associated processes
Report
A business document that contains only predefined data; it is a passive document used solely for reading or viewing. A report typically contains data from many unrelated records or transactions.
Identifier
A candidate key that has been selected as the unique, identifying characteristic for an entity type.
Combo box
A combination text box and list box that displays a predefined list but also allows data entry
foreign key
A common field that exists in more than one table and can be used to form a relationship, or link, between the tables
crow's foot notation
A common method of cardinality notation is called _____ _____ ________ because of the shapes, which include circles, bars, and symbols, that indicate various possibilities
Action bar
A common navigation bar with action controls used for smartphones and usually placed at the bottom of the screen
Server
A computer or a group of computers that manages shared resources such as file systems, databases, and websites, and enables users and computers to access those resources over a network.
Server
A computer that manages shared resources and allows users to access those resources over a network is called a what?
A) extended entry
A condition that has more than two values is a(n): A) extended entry B) simple entry C) complex entry D) limited entry
Functional dependency
A constraint between two attributes in which the value of one attribute is determined by the value of another attribute.
Referential Integrity Constraint
A constraint, stored in the schema, that the DBMS uses to automatically enforce referential integrity
Event modeling
A data flow diagram built based on events. Includes the event, source, trigger, activity, and response. The trigger and response become the input and output data flows, and the activity becomes the process.
C) level-0 diagram
A data flow diagram that represents a system's major processes, data flows, and data stores at a high level of detail refers to: A) context diagram B) level-1 diagram C) level-0 diagram D) level-00 diagram
Decentralized Database
A database stored at multiple locations without needing to be interconnected through a network or synchronized
B
A decision table is simplified by: A) removing extended entries B) removing any rules with impossible actions C) removing simple entries D) removing any rules with static actions
Use case
A depiction of a system's behavior or functionality under various conditions as the system responds to requests from users.
Use Case
A depiction of a system's behaviour or functionality under various conditions as the system responds to requests from users.
Data Store
A depository for the data that allows examination, addition, and retrieval of data. Named with a noun, describing the data. Usually given a unique reference number. Represents a: - Database - Computerized file - Filing cabinet
Conceptual data model
A detailed model that captures the overall structure of organizational data that is independent of any database management system or other implementation considerations.
Entity-relationship data model (E-R model)
A detailed, logical representation of the entities, associations, and data elements for an organization or business area.
Payback analysis
A determination of how long it takes and information system to pay for itself through reduced costs and increased benefits
Logical model
A diagram that focuses on the business and how the business operates; describes the business events that take place and the data required and produced by each event.
Sampling distribution
A distribution of statistics obtained by selecting all of the possible samples of a specific size from a population
Software requirements specification
A document that contains the requirements for the new system, describe the alternatives that were considered, and makes a specific recommendation to management. It is the end product of the systems analysis phase. Sometimes also called a systems requirement document
Request for Proposal (RFP)
A document that describes the company, lists the IT services or products needed, and specifies the features required
Information center (IC)
A facility that supports users by training them on application software. Used support specialists answer questions, troubleshoot problems, and serve as a clearinghouse for used problems and solutions. Also known as service desk or help desk
Discoverability
A feature of the user interface that provides Clues to help users uncover hidden features
Foreign Key
A field in one table that must match a primary key value in another table in order to establish the relationship between two tables
Pointer
A field of data that can be used to locate a related field or row of data.
secondary key
A field or combination of fields that can be used to access or retrieve records
primary key
A field or combination of fields that uniquely and minimally identifies a particular member of an entity
Primary Key
A field or combination of fields that uniquely identifies a particular member of an entity
Calculated field
A field that can be derived from other database fields. Also known as a computed field or a derived field.
D) data store
A file folder containing orders is represented on a data flow diagram as a: A) process B) source C) data flow D) data store
Indexed file organization
A file organization in which rows are stored either sequentially or nonsequentially, and an index is created that allows software to locate individual rows.
Sequential file organization
A file organization in which rows in a file are stored in sequence according to a primary key value.
Hashed file organization
A file organization in which the address of each row is determined using an algorithm.
Application service provider(ASP)
A firm that delivers a software application, or access to an application, by charging a usage or subscription fee.
Application Service Provider
A firm that delivers a software application, or access to an application, by charging a usage/subscription fee.
Application service provided (ASP)
A firm that delivers a software application, or access to and application, by charging a usage or subscription fee
Value-added reseller (VAR)
A firm that enhances a commercial package by adding custom features and configuring it for a particular industry
What is a service provider?
A firm that offers outsourcing solutions
Service provider
A firm that offers outsourcing solutions. Two popular outsourcing options involve application service providers and firms that offer internet business services
Entity-relationship diagram (E-R diagram)
A graphical representation of an E-R model.
Check boxes
A group of selection items that allows either none or many items to be selected within the group
Radio Buttons
A group of selection items that allows only one item to be selected within a group
Unified Modeling Language (UML)
A language that provides a standardized set of tools to document the object-oriented analysis and design of a software system.
False
A location diagram can be used to indicate the locations of the client computers and the server computers in a client/server environment.
Exclusive Lock (White Lock)
A lock where no other activity is allowed, neither reading nor writing the data
Which of the following is not an advantage of using a logical model?
A logical model clarifies which processes are automated
Decision table
A matrix representation of the logic of a decision, which specifies the possible conditions for the decision and the resulting actions
C) decision table
A matrix representation of the logic of a decision, which specifies the possible conditions for the decision and the resulting actions, defines a: A) structure chart B) state transition diagram C) decision table D) sequence diagram
Benchmark
A measure of time a blackberries to process a certain number of transactions
Asynchronous message
A message in which the sender does not have to wait for the recipient to handle the message.
Client/Server Architecture
A method of organizing software applications so that the data and core processing is in a central location and access to that core is distributed on user's computing devices is called what?
Ajax
A method using JavaScript and XML to dynamically change Web pages without displaying a new page by obtaining small amounts of data from the server.
B) has only outputs
A miracle process is one that: A) has only inputs B) has only outputs C) cannot be exploded further D) has insufficient inputs to produce the associated processes
Cloud Computing
A model for enabling ubiquitous, convenient, on-demand network access to a shared pool of configurable computing resources that can be rapidly provisioned and released with minimal management effort or service provider interaction
B) decision table
A modeling technique that allows you to represent a set of conditions and the actions that follow from them in a tabular format best describes: A) data flow diagram B) decision table C) flowchart D) Structured English
Physical table
A named set of rows and columns that specifies the fields in each row of the table.
Physical file
A named set of table rows stored in a contiguous section of secondary memory.
Relation
A named, two-dimensional table of data. Each relation consists of a set of named columns and an arbitrary number of unnamed rows
Return on Investment (ROI)
A percentage rate that compares the total net benefits (the return) received from a project to the total costs (the investment) of the project
Return on investment (ROI)
A percentage rate that measures profitability by comparing the total net benefits(the return) received from a project to the total costs (the investment) of the project. _______ = (total benefits - total costs) / total costs
Use case diagram
A picture showing system behavior, along with the key actors that interact with the system.
Use Case Diagram
A picture showing system behaviour, along with the key actors that interact with the system.
Transaction
A piece of work with several steps that must all be completed to be valid
What is middle (i.e.,label) of the process symbol used for?
A process description
Child Diagrams
A process on Diagram 0 that is exploded. Cannot produce output or receive input that the parent process does not also produce or receive. The child process is given the same number as the parent process. - Process 3 would explode to Diagram 3
Hypertext Markup Language
A protocol that defines the structure and content of a web page is called what?
Structured Query Language SQL
A query language used to access and update the data in a relational database
Third normal form (3NF)
A relation is in second normal form and has no functional (transitive) dependencies between two (or more) nonprimary key attributes.
Second normal form (2NF)
A relation is in second normal form if every nonprimary key attribute is functionally dependent on the whole primary key.
Well-structured relation
A relation that contains a minimum amount of redundancy and that allows users to insert, modify, and delete the rows without error or inconsistencies; also known as a table.
Functional Dependency
A relationship between columns such that the values in one (or more) column determine the values in a second column (or set of columns)
Unary relationship
A relationship between instances of one entity type; also called recursive relationship.
Second Normal Form (2NF)
A restriction that a table is in 1NF and that each non-key attribute is functionally dependent on the entire primary key
First Normal Form (1NF)
A restriction that all fields must be atomic, or single valued
Referential integrity
A rule that states that either each foreign key value must match a primary key value in another relation or the foreign key value must be null (i.e., have no value).
Scenario
A scenario, in UML refers to a single path, among many possible different paths, through a use case.
Web 2.0
A second generation of the web that enable people to collaborate, interact, and share information much more dynamically, based on continuously available used applications rather than static HTML webpages. Interactive experience is a hallmark of ______
Web 2.0
A second generation of the web that enables people to collaborate, interact and share informatino much more effectively
Virtual Private Network (VPN)
A secure communications scheme that utilizes the Internet but with very secure technologies so that it appears as a dedicated network is called what?
Fixed fee model
A service model that charges a set fee based on a specified level of service and used support
Subscription model
A service model that charges a variable fee for an application based on the number of users of workstations that have access to the application
Transaction model
A service model that charges a variable fee for an application based on the volume of transactions or operations performed by the application. Also called a usage model
Fixed fee model (outsourcing)
A set fee based on a specified level of service and user support
Record
A set of related fields that describes one instance or occurrence of an entity
Referential integrity
A set of rules that avoids data inconsistency and quality problems
referential integrity
A set of rules that avoids data inconsistency and quality problems
Repeating group
A set of two or more multivalued attributes that are logically related.
Ternary relationship
A simultaneous relationship among instance of three entity types.
Entity instance
A single occurrence of an entity type. Also known as an instance.
Data flow diagram fragment
A single process on a data flow diagram. All the fragments combine to form Diagram 0.
Three-layer architecture
A software architecture that divides an application into view, business logic, and data is called what?
Web service
A software function or set of functions or services that can be executed via Web protocols is called a what?
Vertical application
A software package developed to handle information requirements for a specific type of business
What is a vertical application?
A software package developed to handle information requirements for a specific type of business
Horizontal application
A software package that can be used by many different types of organizations
What is a horizontal application?
A software package that can be used by many different types of organizations
Vertical application
A software that has been developed to handle information requirements for a specific type of business
External entity (source or destination)
A source or destination of data considered to be external to the system being described. Also called an entity.
Null value
A special field value, distinct from zero, blank, or any other value, that indicates that the value for the field is missing or otherwise unknown.
Maintenance agreement
A specification of the conditions, charges, and time frame for users to contact the vendor for assistance when they have system problems or questions
Subtype
A subgrouping of the entities in an entity type that is meaningful to the organization and that shares common attributes or relationships distinct from other subgroupings.
B) source
A supplier of auto parts to our company is represented on a data flow diagram as a: A) process B) source C) data flow D) data store
System of record
A system or application component that maintains the current and correct Master Copy of one or more data items
Database Management System (DBMS)
A system software component that manages and controls one of more databases
Why do analysts work in teams when selecting hardware and software?
A team approach ensures that critical factors are not overlooked and that a sound choice is made
Transaction Logging
A technique by which any update to the database is logged with such audit information as user ID, date, time, input data, and type of update
File organization
A technique for physically arranging the records of a file.
Evaluation Model
A technique that uses a common yardstick to measure and compare vendor ratings
List box
A text box with a list of predefined data values
False
A three-layer architecture requires at least three computers to be implemented correctly.
Report generator
A tool for designing formatted reports rapidly. Also called a report writer
Default value
A value a field will assume unless an explicit value is entered for that field.
Service-oriented architecture (SOA)
A way of engineering systems in which reusable business functionality is provided by services through well defined interfaces. Technically, not software architecture but an architectural style
Request for proposal (RFP)
A written list of features and specifications given to prospective vendors before a specific product or package has been selected
When organizations request for bids for contracts on their own Web site for procurement, such business is classified as a(n): A. Buy-side marketplace. B. Sell-side marketplace. C. Electronic exchange. D. None of these.
A. Buy-side marketplace.
Organizations typically face issues related to e-tailing including A. Companies face issues in both of these areas B. Channel conflict C. Order fulfillment D. Companies do not face issues in either of these areas
A. Companies face issues in both of these areas
Downloading a book on an Amazon Kindle is an example of: A. Pure e-commerce. B. Partial e-commerce. C. Both of these are correct. D. Neither of these are correct.
A. Pure e-commerce.
For a small-to-medium enterprise, the benefits of setting up an e-commerce store front include (choose all that apply): A. The ability to reach a wider customer base. B. The ability to offer a larger selection of products. C. The ability to eliminate advertising. D. The ability to offer lower prices to customers.
A. The ability to reach a wider customer base. B. The ability to offer a larger selection of products. D. The ability to offer lower prices to customers.
The opening case illustrates how e-commerce has increased (choose all that apply): A. The volume of business transactions. B. The skill with which computers are able to handle unexpected situations. C. The occurrence of human errors. D. The speed at which we do business.
A. The volume of business transactions. D. The speed at which we do business.
eBay is an example of which type of e-commerce? A. consumer-to-consumer B. consumer-to-business C. business-to-consumer D. business-to-business E. government-to-citizen
A. consumer-to-consumer
When e-commerce is done in a wireless environment, this is called: A. mobile commerce B. wireless commerce C. pervasive computing D. location commerce E. consumer commerce
A. mobile commerce
Manufacturers or retailers sell directly to customers in which of the following business models? A. online direct marketing B. affiliate marketing C. find-the-best-price D. name-your-own-price E. electronic tendering system
A. online direct marketing
A(n) ____ is a firm that delivers a software application, or access to an application, by charging a usage or subscription fee.
ASP
Interoperability
Ability of a component or system to interact with other components or systems
An attempt to disseminate information in order to influence a buyer-seller transaction.
Advertising
ajax
Ajax is a technique that uses both JavaScript and XML to obtain small amounts of data, either plain text or XML, from a server without leaving the web page.
B) event
All business processes begin and end with a(n): A) starting and termination points B) event C) activity D) gateway
A) decision
All of the following are symbols used in business process modeling EXCEPT: A) decision B) gateway C) event D) activity
Business logic layer
Also known as The Domain layer the part of a three layer architecture that contains the programs that implement the business rules and processes
Which is NOT one of the four basic symbols used to chart data movement on data flow diagrams?
An Oval
B) data flow
An arrow on a data flow diagram represents a: A) data store B) data flow C) process D) source/sink
Extend relationship
An association between two use cases where one adds new behaviors or actions to the other.
Extend Relationship
An association between two use cases where one adds new behaviours or actions to the other. [The base use case can stand alone without the _____ case(s)].
Include relationship
An association between two use cases where one use case uses the functionality contained in the other.
Include Relationship
An association between two use cases where one use case uses the functionality contained in the other. [The base use case can't function without the ___ case(s).]
Candidate key
An attribute (or combination of attributes) that uniquely identifies each instance of an entity type.
Primary key
An attribute (or combination of attributes) whose value is unique across all occurrences of a relation.
Key
An attribute or set of attributes, the values of which are unique for each row of the table, that is used to uniquely identify a row
Foreign key
An attribute that appears as a nonprimary key attribute in one relation and as a primary key attribute (or part of a primary key) in another relation.
Foreign Key
An attribute that duplicates the primary key of a different (or foreign) table.
Composite attribute
An attribute that has meaningful component parts.
Required attribute
An attribute that must have a value for every entity instance.
Associative entity
An entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity Instances; also called a gerund.
A) dash (-)
An indifferent condition is represented by a(n): A) dash (-) B) asterisk (*) C) exclamation point (!) D) pound sign (#)
Open Database Connectivity (OBDC)
An industry-standard protocol that makes it possible for software from different vendors to interact and exchange data
In-house software
An information center of help desk within the IT department responsible for providing used support and offering services such as hotline assistance, training, and guidance to users who need technical help
data warehouse
An integrated collection of data that can include seemingly unrelated information, no matter where it is stored in the company
Data Warehouse
An integrated collection of data that can include seemingly unrelated information
Screen generator
An interactive tool that helps design a custom interface, create screen forms, and handle data entry format and procedures. Also called a form painter
Newsgroup
An online discussion on a particular topic, where people meet, offer support,and exchange ideas. The electronic equivalent of the physical bulletin board. Also called a forum
Cloud computing
An online software and data environment in which applications and services are accessed and used through an internet connection rather than on a local computer; refers to the cloud symbol for the internet
Managed hosting
An operation is managed by the outside firm, or host. Another term for IBS
Usability
An overall evaluation of how a system performs in supporting a particular user for a particular task.
Context diagram
An overview of an organizational system that shows the system boundaries, external entities that interact with the system, and the major information flows between the entities and the system
Context diagram
An overview of an organizational system that shows the system boundaries, external entities that interact with the system, and the major information flows between the entities and the system.
Metaphors
Analogies between features of the user interface and aspects of physical reality which users are familiar
candidate key
Any field that could serve as a primary key is called a
_____________ is a firm that delivers a software application, or access to an application _____________ provide powerful web-based support for transactions such as order processing, billing, and crm
Application service provider Internet Business Services
Business Process Outsourcing
Aspects of outsourcing such as programming, renting software/systems, or handling the IT functions.
Which type of electronic payment is typically favored in B2B A. Electronic credit cards B. Electronic checks C. Smart cards D. Electronic cash
B. Electronic checks
When organizations come to a company's Web site for procurement, such business is classified as a(n): A. Buy-side marketplace. B. Sell-side marketplace. C. Electronic exchange. D. None of these.
B. Sell-side marketplace.
Which of the following electronic payments is ideal for micropayments? A. Purchasing cards B. Smart cards C. Electronic checks D. None of the methods listed is suited to micropayments
B. Smart cards
The fee for a monetary transaction between a buyer and a seller using PayPal is paid for by: A. Neither party; PayPal is a free service. B. The payer. C. The payee. D. Both the payee and the payer.
B. The payer.
In an e-credit card transaction, the clearinghouse plays the following role: A. Initiates the transfer of money B. Validates and verifies the seller's payment information C. Transfers funds between the seller's bank and the buyer's bank D. All of these
B. Validates and verifies the seller's payment information
The four types of E-Commerce are:
B2C - Business to Consumer B2B - Business to Business C2C - Consumer to Consumer B2E - Business to Employee
An organization uses e-commerce internally to provide information and services to its employees. Companies allow employees to manage their benefits, take training classes electronically; buy discounted insurance, travel packages, and event tickets.
B2E
Electronic billboards.
Banners
What are the benefits of E-Commerce to organizations and customers and society?
Benefits to Organizations: -makes markets more accessible -lowers costs Benefits to Customers: -access to a vast number of products and services around the clock Benefits to Society: -ability to easily deliver to people everywhere
Purely physical organizations.
Brick-and-mortar organizations
Tool tip
Brief instructions that pop up when the mouse hovers over a control
Standards Architecture
Broad plan for creating standards - break problems into smaller pieces for ease of development - develop standards for the individual pieces - Dominant architecture today is the hybrid TCP/IP-OSI standards
The method by which a company generates revenue to sustain itself
Business Model
Which type of electronic exchange connect buyers with sellers within a specific industry? A. Functional exchanges B. Public exchanges C. Vertical exchanges D. Horizontal exchanges
C. Vertical exchanges
In this type of e-commerce, buyers and sellers are individuals. A. business-to-consumer B. business-to-business C. consumer-to-consumer D. government-to-citizen E. consumer-to-business
C. consumer-to-consumer
In _____, needed services such as temporary help or extra space are traded on an as-needed basis. A. buy-side marketplaces B. horizontal exchanges C. functional exchanges D. sell-side marketplaces E. vertical exchanges
C. functional exchanges
A(n) _____ is automatically launched by some trigger and appears in front of the active window. A. keyword banner B. random banner C. pop-up ad D. pop-under ad E. text box
C. pop-up ad
The major strategies for conducting __________ commerce on the Internet are auctions and classified ads.
C2C
D) process
Calculating an employee's salary is represented on a data flow diagram as a: A) data flow B) source C) data store D) process
The alienation of existing distributors when a company decides to sell to customers directly online
Channel Conflict
What is a usage model or transaction model?
Charges a variable fee based on the volume of transactions or operations performed by the application
Conduct some e-commerce activities, yet their business is primarily done in the physical world in example: partial EC
Click-and-mortar Organizations
Complex Data Types
Combinations of or extensions to primitive data types that are supported by programming languages, operating systems, and DMBSs
The blending of community, communication, and entertainment into a new form of online activity driven by consumers.
Communitainment
Software vendor
Company that develops software for sale
What are some characteristics of a traditional development environment?
Compatibility issues influence systems design Systems are designed to run on local and wide-area company networks Systems often use internet links as enhancements Follows three main paths, in-house, purchase a package, or outside consultants Scalability depends on networks limitations and constraints Require lots of computing power and resources Security issues are less complex
Table or File
Contains a set of related records that store data about a specific entity
Distribution of Sample Means
Contains all of the possible samples The collection of ample means for all of the possible random samples of a particular size (n) that can be obtained from a population.
What is a systems requirements specification?
Contains the requirements for the new system, describes the alternatives that were considered, and makes specific recommendation to management
Firmware
Control programs stored on chips are sometimes referred to as _________? The OS in an ipod, iphone or TV is most likely stored as _______?
Involves conducting banking activities from home, a place of business, or on the road instead of at a physical bank location.
Cyberbanking
____ and ____ are the two major challenges for the sellers in e-commerce. A. Order fulfillment, large orders B. Channel conflict, advertising C. Advertising, large orders D. Channel conflict, order fulfillment
D. Channel conflict, order fulfillment
In the _____ marketplace model, the reverse auction is typically used. A. desktop purchasing B. group purchasing C. electronic exchange D. buy-side E. sell-side
D. buy-side
Database administrator
DBA. The person in charge of the safety and operation of the database management system
A(n) ____ is a collection of tools, features, and interfaces that enable users to add, update, manage, access, and analyze the contents of data.
DBMS
A method that provides conceptional freedom for representing processes and flows in a business system is the _______.
Data Flow Diagram
Data store
Data at rest, which may take form of many different physical representations.
Data store
Data at rest, which may take the form of many different physical representations
B) data store
Data at rest, which may take the form of many different physical representations, defines: A) source B) data store C) data flow D) process
Derived element
Data fields or elements that are not keyed but are rather the result of a calculation or logical operation.
Base element
Data fields or elements that need to be keyed; must be stored in a file.
A) process models
Data flow diagrams that concentrate on the movement of data between processes are referred to as: A) process models B) data models C) flow models D) flow charts
Which of the following is not an error when drawing a data flow diagram?
Data flow on a child diagram that has only one end connected to a process, the other end is a point in space
D) data flow
Data in motion, moving from one place in a system to another, defines: A) data store B) process C) source D) data flow
Relational database model
Data represented as a set of related tables or relations.
Data store
Data that are at rest in a system; depicted using an open-ended rectangle in data flow diagrams.
Primitive Data Types
Data types supported directly by computer hardware or a programming language
Schema
Database component that contains descriptive information about the data stored in the physical data store
scalability, economy of scale, enterprise-wide application, stronger standards, better security, and data independence
Database management software advantages include:
Make or buy (build or buy)
Decision between developing or purchasing software. Developing is an "In House Software" Purchasing is a "Software Package"
In what type of e-commerce business model do companies offer deep price discounts
Deep discounters
Local Design
Defines "what" must take place, not "how" it will be accomplished.
HTTP (hypertext transfer protocol)
Defines format and content for transfer of web documents
Logical design
Defines what must take place, not how it will be accomplished
Pure versus Partial Electronic Commerce depends on the ______ involved.
Degree of Digitization
Process
Denotes a change in or transformation of data. Represents work being performed in the system. Naming convention: - Assign the name of the whole system when naming a high-level process. - To name a major subsystem attach the word subsystem to the name. - Use the form verb-adjective-noun for detailed processes.
Sequence diagram
Depicts the interactions among objects during a certain period of time
Physical design
Describes the actual process of entering, verifying and storing data
True
Describing the environment is one of the detailed activities of core process 4: Design system components.
User-centered design
Design techniques that embody The View that the user interface appears to be in the entire system
Mobile responsive
Designing websites so the pages are responsive to being displayed on small mobile devices
Payback Analysis
Determines how long it takes an information system to pay for itself through reduced costs and increased benefits.
Intermediaries or middlemen provide information and/or provide value-added services. When the function(s) of these intermediaries can be automated or eliminated, this process is called
Disintermediation
Request for Proposal
Document that describes the company, lists the IT services required, and specifies the features required.
Businesses and organizations set up Web sites to: A. Sell goods and services. B. Induce people to visit a physical location. C. Reduce operational and transaction costs. D. Enhance their reputation. E. All of the above.
E. All of the above
Electronic business includes which of the following? A. buying and selling B. servicing customers C. collaborating with business partners D. conducting electronic transactions within an organization E. all of the above
E. all of the above
The key mechanisms to sell-side marketplaces are
Electronic Catalogs and Forward Auctions
Describes the buying, selling, transferring or exchanging of products, services or information via computer networks, including the Internet.
Electronic Commerce (E-Commerce)
Allow customers to charge online payments to their credit card account
Electronic Credit Cards
Collections of individual shops under a single Internet address.
Electronic Malls
This enables you to pay for goods and services electronically.
Electronic Payment Systems
In what type of e-commerce business model do businesses request quotes from suppliers
Electronic tendering system
HTTPS (hypertext transfer protocol secure)
Encrypted and secure HTTP transfers
What are the steps in the software acquisition process?
Evaluate the Information System Requirements Identify Potential Vendors or Outsourcing Options Evaluate Alternatives Cost Benefit Analysis Prepare Recommendation Implement Solution
An _____________ model is a technique that uses a common yardstick to measure and compare vendor ratings
Evaluation
Exploding
Expanding a diagram to show subprocesses.
A value added contract provides for flexibility, but may result in a larger than expected bill.
False
Due to privacy issues, it is illegal for e-commerce Web sites to use cookies to record their customer's past behaviors and discover their identity. True False
False
If in-house experience exists for all the functional and technical needs of the new system, it will be easier to outsource the building of the system, because the company employees with those skills will be able to quickly learn the new system with very little training.
False
In general, e-commerce Web sites of click-and-mortar companies carry the same variety of merchandise as their brick-and-mortar stores. True False
False
In general, the e-commerce Web sites of click-and-mortar companies operate only during the business hours of their brick-and-mortar stores. True False
False
In-house experience is not a factor to be considered for selecting a design strategy since a company is always able to hire experienced developers.
False
Internet marketing typically is one-way and impersonal. True False
False
Many project teams believe that packaged software is the best way to create a system because they have complete control over the way the system looks and functions, and they can be flexible and creative in the way they solve business problems.
False
Max has been a project manager for 10 years and is considered one of the best in his department of well qualified IS professionals. The approval committee is considering the approval of a new unique Internet system that could possibly catapult the firm ahead of all of the competition. Buying a packaged system would be the best design strategy.
False
Processes in a rectangle with rounded corners sometimes denote something other than a change in or transformation of data or a system/subsystem.
False
Processes that transform data should be named with a noun which indicates the data that has been transformed.
False
Stored-value money cards contain chips with personal data. True False
False
The design strategy that would be most logical to a firm with a very limited amount of in-house IS expertise is allow end-users to create the system.
False
The highest level data flow diagram is called Diagram 0.
False
The sales tax laws that apply to brick-and-mortar stores also apply to all e-commerce stores. True False
False
The use of electronic commerce requires companies to hire additional employees. True False
False
There are three design strategies: 1) developing a custom application in-house, 2) hiring a consultant, and 3) relying on an external vendor, developer, or service provider to build the system.
False
Trademark owners in the US are not allowed to sue for damages in cases of cybersquatting. True False
False
Vertical exchanges are typically used only to buy and sell materials required for an organization's support activities. True False
False
Virtual credit cards create new credit card accounts that are valid only for a pre-defined number of transactions. True False
False
When two companies fight over a domain name the company that has been in business the longest is automatically considered the owner of the domain. True False
False
In what type of e-commerce business model do customers specify a need and an intermediary compares providers and shows the lowest price
Find-the-best-price
Recursive foreign key
A foreign key in a relation that references the primary key values of that same relation.
Normalization
A formal technique for transforming a relational schema to an equivalent one that minimizes data redundancy and eliminates data anomalies
data structure
A framework for organizing, storing, and managing data
Supertype
A generic entity type that has a relationship with one or more subtypes.
Data flow diagram
A graphical depiction of data processes, data flows, and data stores in a business system.
data flow diagram (DFD)
A graphical depiction of data processes, data flows, and data stores in a business system. (7)
Software license
A legal agreement that gives users the right to use the software under certain terms and conditions
Software as a Service (SaaS)
A model of software delivery in which functionality is delivered on-demand as a network-accessible service, rather than as a traditional software application that is downloaded and installed on the customer's computer
What is Software as a service?
A model of software development in which an application is hosted as a service provided to customers over the internet
Software as a Service
A model of software development in which an application is hosted as a service provided to customers over the internet.
Network diagram
A model that shows how locations and Hardware components are interconnected with network devices and wiring
Entity-Relationship Diagram (ERD)
A model that shows the logical relationships and interaction among entities. Provides the overall view of the system and a blueprint for creating the physical data structures.
Attribute
A named property or characteristic of an entity that is of interest to the organization.
Physical design
A plan for the actual implementation of the system
D) source/sink
A square on a data flow diagram represents a: A) data store B) data flow C) process D) source/sink
Evaluation model
A technique that used a common yardstick to measure and compare vendor ratings
In what type of e-commerce business model do vendors ask partners to place logos or banners on partner's sites
Affiliate Marketing
____ accounts for the majority of e-commerce transactions. A. B2C B. B2B C. C2C D. B2E E. G2C
B. B2B
C) identifying selection criteria
Basic procedures for constructing a decision table do not include: A) listing all possible rules B) naming the conditions and the values each condition can assume C) identifying selection criteria D) simplifying the decision table
B2B model in which organizations buy needed products or services from other organizations electronically, often through a reverse auction
Buy-side Marketplace
An individual sells products or services to other individuals
C2C
Usage or transaction model (outsourcing)
Charges a variable fee based on the volume of transactions or operations performed by the application
True
Computing devices include all of the following: a server, a laptop, a Kindle reader, an Apple Watch, and a smartphone.
Internet Protocol (IP) Address
Every device connected to the internet has an identifying address called __________?
Referential Integrity
Every value as a foreign key in one table must have an equivalent value as the primary key in the associated table
Electronic commerce makes national and international markets less accessible. True False
False
C) be coupled to each other
If two processes are connected by a data flow, they are said to: A) share the same timing effects B) share the same data C) be coupled to each other D) be strapped to each other
False
In three-layer architecture, the three layers consist of the view layer, the business logic layer, and the domain layer.
What is another term for internet business services?
Managed hosting
Benchmarking
Measurement of the time a package takes to process a certain number of transactions
Secondary key
One or a combination of fields for which more than one row may have the same combination of values.
Asks consumers to give their permission to voluntarily accept online advertising and e-mail.
Permission Marketing
The B2B equivalent of electronic credit cards and are typically used for unplanned B2B purchases
Purchasing cards
B) decision table
Removing any rules with impossible actions to make which of the following simple as possible? A) activity diagram B) decision table C) structure chart D) hierarchical chart
Detailed reports
Reports that contain specific information on business transactions
Sequence Diagram - Instance Form
Shows the sequence for only one scenario.
Total specialization rule
Specifies that each entity instance of the supertype must be a member of some subtype of the relationship.
___________ has a variable fee based on the number of users or workstations that have access to the application
Subscription model
What are some characteristics of a web-based development environment:
Systems are developed in internet-based framework Treats web as a platform Easily scalable and can run on multiple hardware Used by large firms for CRM, order processing, and materials management Treats the software application as a service that is less dependent on computing power and resources Can limit in-house involvement and have the vendor install, configure, and maintain the system Usually requires middleware to communicate with existing software and legacy systems More complex security issues
The process of building new systems by combining packaged software, existing legacy systems, and new software written to integrate everything together is called _____.
Systems integration
schema
The complete definition of a database, including descriptions of all fields, tables, and relationships
DFD consistency
The extent to which information contained on one level of a set of nested DFDs is also included on other levels
B) rules
The part of a decision table that links conditions to actions is the section that contains the: A) action statements B) rules C) condition statements D) decision stubs
Action stubs
The part of a decision table that lists the actions that result for a given set of conditions
D) multiply the number of values for each condition by the number of values for every other condition
To determine the number of rules required for the decision table, you would: A) add the number of values for each condition to the number of values for every other condition B) multiply the number of conditions by two C) add the number of values for each condition to the number of values for every other condition, then subtract 1 D) multiply the number of values for each condition by the number of values for every other condition
With a ______ approach, the diagrams move from general to specific.
Top-Down
Event response table
Used to summarize events.
Ui
User experience. The set of inputs and outputs that the user interacts with to invoke the functions of an application
False
For a large company such as RMO, external hosting of part or all of the system is not usually a cost effective technique.
Refers to online "word of mouth" marketing
Viral Marketing
Banks dedicated only to Internet transactions.
Virtual Banks
______________ second generation of the web that enables people to collaborate, interact, and share information much more effectively ____________ a model for enabling ubiquitous, convenient, on-demand network access to a shared pool of configurable computing resources that can be rapidly provisioned and released with minimal management effort or service provider interaction ___________ hand held electronics such as smartphones and tablets
Web 2.0 Cloud Computing Mobile Devices
Level-n diagram
a DFD that is the result of n nested decompositions from a process on a level-0 diagram
one-to-one relationship
abbreviated 1:1, exists when exactly one of the second entity occurs for each instance of the first entity
A(n) ______ matrix can be used to organize the pros and cons of the design alternatives so that the best solution will be chosen in the end.
alternative
Central limit theorem
For any population with a mean and standard deviation the distribution of sample means for sample size n will have a manu of u and ans standard deviation of square root over n and will approach a normal distribution as n approaches infinity.
Computer Network
hardware, software, transmission media
user interface
includes screens, commands, controls, and features that enable users to interact more effectively with an application
subject matching
synonym for individual matching
Drivers of today's online advertising include:
-Communitainment -Usites -Multitasking
What are the disadvantages of E-Commerce
-No universal security standard -Insufficient bandwidth -Expensive accessibility -Perception that EC is insecure -Lacks a critical mass of buyers and sellers
Reasons for purchasing a software package
1. Lower costs 2. Requires less time to implement 3. Proven reliability and performance benchmarks 4. Requires less technical development staff 5. Future upgrades provided by the vendor 6. Obtain input from other companies
A) level-3 diagram
A DFD that is a result of three nested decompositions of a series of subprocesses from a process on a level-0 diagram defines a: A) level-3 diagram B) level-1 diagram C) level-2 diagram D) primitive diagram
D) level-n diagram
A DFD that is the result of n nested decompositions from a process on a level-0 diagram, is called: A) primitive diagram B) level-0 diagram C) context diagram D) level-n diagram
Level-n diagram
A DFD that is the result of n nested decompositions from a process on a level-0 diagram.
Level-0 diagram
A DFD that represents a system's major processes, data flows, and data stores at a high level of detail
Physical model
A DFD that shows how a system will be implemented, including the hardware, software, people, and files involved.
Relational Database Management System (RDBMS)
A DMBS that organizes data in tables or relations
Homogeneous Distributed Database
A Database distributed across multiple locations with the same DBMS, and all database access coordinated by a global schema
Protocol
A ______ is a set of languages, rules, and procedures to facilitate accurate data exchange.
Three-layer architecture
A client/server architecture that divides an application interview layer, business logic layer, and data layer
Three layer architecture
A client/server architecture that divides an application into view, business logic and data layers is called what?
EBCDIC
A coding method used on mainframe computers and high-capacity servers
ASCII
A coding method used on most personal computers
Entity type
A collection of entities that share common properties or characteristics.
A) statements
A decision table does not include: A) statements B) condition stubs C) action stubs D) rules
Shared lock (Read lock)
A lock where other transaction are allowed to read the data
A primitive process is:
A process that is not exploded to a child diagram
Index
A table used to determine the location of rows in a file that satisfy some condition.
Active discovery
A user interface feature to lead users to discover hidden features
Actor
An external entity that interacts with a system.
Candidate Key
Any field that can serve as a primary key
C) 16
Assume the first condition has four values; the second condition has two values; the third condition has two values. How many rules will there be? A) 8 B) 7 C) 16 D) 24
B) 12
Assume the first condition has two values; the second condition has two values; the third condition has three values. How many rules will there be? A) 7 B) 12 C) 6 D) 11
D) 18
Assume we have three conditions. Condition one has two values; condition two has three values; condition three has three values. How many rules are needed? A) 8 B) 6 C) 5 D) 18
A competitive process in which either a seller solicits consecutive bids from buyers or a buyer solicits consecutive bids from sellers.
Auction
Major E-Commerce Mechanisms include:
Auctions Forward Auctions Reverse Auctions
Sellers use a _____ as a channel to many potential buyers. *Note that Sotheby's uses forward auctions.
Forward Auction Results in higher prices over time
Legal Issues Specific to E-commerce include
Fraud on the Internet- stocks Domain Names- competition Cybersquatting Domain Tasting Taxes and Other Fees Copyright
Refers to the practice of registering domain names solely for the purpose of selling them later at a higher price
Cybersquatting
Data store
Data at rest, which may take the form of many different physical representations.
A broader definition of EC, including buying and selling of goods and services, and also servicing customers, collaborating with partners, conducting e-learning and conducting electronic transactions within an organization.
E-Business
The use of Internet Technology in general and e-commerce in particular to deliver information about public services to citizens (called Government-to-citizen [G2C EC]), business partners
E-Government
Similar to paper checks and are used mostly in B2B.
E-checks
Purchasing by using electronic support
E-procurement
A(n) ____ is a graphical model of an information system that depicts the logical relationships and interaction among system entities.
ERD
A Web site that represents a single store.
Electronic Storefront
Class such as URLConnection (dealing with URL connections) should be handled in the layer Data Management.
False
On data flow diagram, an arrow is used to depict an external entity that can give and receive data from the system.
False
Pirate Adventures, Inc., a company that owns and operates hotels in tropical locations, is interested in replacing the 15-year-old room reservation system in all of its hotels. Custom development would be the best design strategy.
False
Event trigger
Input for an event.
JDBC enables ____ applications to exchange data with any database that uses SQL statements and is compliant with the standard.
Java
LAN
Local area network- small computer network typically spanning a single home, small office, or one floor of a building
Data mining software
Looks for meaningful data patterns and relationships
What is the main reason for IT offshoring?
Lower costs
Involves customers accessing services via the Web.
Online Service
Ethical issues related to E-commerce include
Privacy and Job loss
In what type of e-commerce business model do customers use the internet to self-configure products or services
Product customization
What are some risks of offshoring?
Project control security issues disparate cultures effective communication Economic impact
Internet Business Services (managed hosting)
Provide powerful web-based support for transactions such as order processing, billing, and CRM.
With a(n) ____ language, the user provides an example of the data requested.
QBE
The key mechanisms to buy-side marketplaces are
Reverse Auctions
Physical Design
Set of blueprints for the actual construction.
Client / Server architecture
Software design with part of the application on a server and part of the client
Software package
Software that is purchased or leased from another firm. A commercially produced software product, or family of products
Feedback
Some visual or audio response by the system in response to a user action
Interoperability
The ability of a component or system to interact with other components or systems is referred to as what?
Balancing
The conservation of inputs and outputs to a DFD process when that process is decomposed to a lower level.
Primary Key
The key chosen by a database designer to define relationships by being used as a foreign key in other tables
Degree
The number of entity types that participate in a relationship.
Normalization
The process of converting complex data structures into simple, stable data structures.
Technology Architecture
The set of computing hardware, network hardware and system software in an organization is usually referred to as the what?
Technology Architecture
The set of computing hardware, network hardware and system software used by an organization is called the what?
Application Architecture
The set of information systems the organization needs to support its operations is often called the what?
Lightweight graphics
The use of small, simple images to allow a Web page to be displayed more quickly.
Process
The work or actions performed on data so that they are transformed, stored, or distributed
Net Present Value
Total value of the benefits mins the total value of the costs.
Drill down
User interface design techniques that enables a user to select summary information and View supporting detail
Hypertext Transfer Protocol
What does HTTP stand for?
Software as a Service
What does SaaS stand for?
A Server Computer
What is a computer that manages shared resources for access across a network called?
Visibility
When a control is visible so that users know it's available
client/server architecture
a software design and deployment method that divides software into components that manage resources and components that use those resources
system of record
a system or application component that maintains the current and correct master copy of one or more data items
group counterbalancing
administering different sequences to different groups of participants
intrasubject counterbalancing
administering the treatment conditions to each individual participant in more than one order
Relational database management system
RDBMS. A DBMS that organizes data in tables or relations
A) process
Recording a customer's payment is represented on a data flow diagram as a: A) process B) source C) data flow D) data store
What are some benefits of SaaS?
Reduces the need for software maintenance, operation, and support
Exception reports
Reports that provide details or summary information about transactions or operating results of fall outside of predefined normal range of values
Executive reports
Reports used by high-level managers to assess overall organizational health and performance
External Entities
Represent another department, a business, a person, or a machine. A source of destination of data, outside the boundaries of the system. Should be named with a noun.
binary digits
Represents numbers as actual binary values, rather than as coded numeric digits
A -___________ is more specific than a RFP?
Request for quotation
One buyer, usually an organization, wants to buy a product or a service. The buyer posts a request for quotation (RFQ) on its Web site or on a third-party Web site. The RFQ contains detailed information on the desired purchase. Suppliers study the RFQ and submit bids, and the lowest bid wins the auction.
Reverse Auctions Results in lower prices over time
Many database programs generate ____, which is a language that allows client workstations to communicate with servers and mainframe computers.
SQL
Software-as-a-service
SaaS. A software delivery model similar to a utility, in which application software is accessed via the internet without locally installed programs
Why do companies choose to develop software in-house?
Satisfy unique business requirements Minimize changes in business procedures and policies Meet constraints of existing systems Meet constraints of existing technology Develop internal resources and capabilities
____ means that a system can be expanded, modified, or downsized easily to meet the rapidly changing needs of a business enterprise.
Scalability
Where organizations sell their products or services to other organizations electronically from their own Web site and/or from a third-party Web site
Sell-side Marketplace examples include: Ariba Dell Auction BigboXX.com
Internet business services (IBS)
Services that provide powerful web-based support for transactions such as order processing, billing, and customer relationship management
Protocol
Set of languages, rules, and procedures that ensure accurate and efficient data exchange and coordination among hardware and software components
Sequence Diagram - Generic Form
Shows all possible sequences of interactions, that is, the sequences corresponding to all the scenarios of a use case.
Data Flow
Shows movement of data from one point to another. Described with a noun. Arrowhead indicates the flow direction. Represents data about a person, place, or thing.
Activity Diagram
Shows the conditional logic for the sequence of system activities needed to accomplish a business process.
Contain a chip called a microprocessor that can store a considerable amount of information and are multipurpose - can be used as a debit card, credit card or a stored-value money card.
Smart Cards
Mobile device
Smartphones, tablets, and other computing devices that are not permanently tethered to a desk. They connect to the network wirelessly
Although the traditional model of software acquisition still accounts for more software acquisition, a new model, called ____, is changing the picture dramatically.
Software as a Service
____ is a model of software deployment where an application is hosted as a service provided to customers over the Internet.
Software as a Service
Software as a Service (SaaS)
Software deployment model in which an application is hosted as a service provided to customers over the Internet
Client/server architecture
Software design and deployment method that divides software into components that manage resources and components that use resources
Enterprise Resource Planning (ERP)
Software package that integrates the many functions of a business - sales & inventory - manufacturing & purchasing - human resources - order tracking & decision support
Middleware
Software that connects dissimilar applications and enables them to communicate and exchange data. For example, ________ can link a departmental database to a web server that can be accessed by client computers via the internet or a company intranet
Application software
Software that performs user or business specific tasks and is typically constructed as an app or web-based application
Companies that develop software for sale are called what?
Software vendors
System Software
Software, such as Web server software, and works behind the scenes is called what?
Business rules
Specifications that preserve the integrity of the logical data model.
Overlap rule
Specifies that an entity instance can simultaneously be a member of two (or more) subtypes.
Partial specialization rule
Specifies that an entity instance of the supertype does not have to belong to any subtype.
standard notation format
Starts with the name of the table, followed by a parenthetical expression that contains the field names separated by commas. The primary key field(s) is underlined, like this: NAME (FIELD 1, FIELD 2, FIELD 3)
The Software Acquisition process
Step 1: Evaluate the Information System Requirements Step 2: Identify potential vendors or outsourcing options Step 3: Evaluate the alternatives Step 4: Perform Cost-Benefit analysis Step 5: Prepare a recommendation Step 6: Implement the Solution
Allow you to store a fixed amount of prepaid money and then spend it as necessary.
Stored-value Money Card
B) data flow
Student data contained on an enrollment form is represented on a data flow diagram as a: A) process B) data flow C) source D) data store
Evaluation Model
Technique that uses a common yardstick to measure and compare vendors.
Template-Based HTML
Templates to display and process common attributes of higher-level, more abstract items.
Hyperlink
The URL of one web resource is embedded within another web resource
False
The Web is the highway over which messages and information travel from network to network.
International Organization for Standardization
The ____________ ____________ __ _______________requires a format of four digits for the year, two for the month, and two for the day (YYYYMMDD)
C) functional decomposition
The act of going from a single system to several component processes refers to: A) structuring B) balancing C) functional decomposition D) formatting
External systems and technology architecture.
The activity of Describing the Environment consists of what two key elements?
Make or buy
The choice between developing in-house software and purchasing software Also called build or buy
Schema
The complete definition of a database, including descriptions of all fields, tables and relationships is called a schema
Balancing
The conservation of inputs and outputs to a DFD process when that process is decomposed to a lower level
B) balancing
The conservation of inputs and outputs to a data flow diagram process when that process is decomposed to a lower level defines: A) decomposition B) balancing C) conservation D) data flow structuring
Usability
The degree to which a system is easy to learn and use
B) what you learned during requirements determination
The deliverables of process modeling state: A) how you should develop the system during physical design B) what you learned during requirements determination C) how you should implement the new system during implementation D) what you learned during project planning
A) context diagram
The diagram that shows the scope of the system, indicating what elements are inside and which are outside the system, is called a: A) context diagram B) level-2 diagram C) referencing diagram D) representative diagram
Level 0 diagram
The explosion (or decomposition) of a context-level data ow diagram that shows from three to nine major processes, important data flows, and data stores of the system under study.
DFD completeness
The extent to which all necessary components of a DFD have been included and fully described
B) DFD completeness
The extent to which all necessary components of a data flow diagram have been included and fully described refers to: A) DFD consistency B) DFD completeness C) DFD gap proofing D) DFD flexibility
DFD consistency
The extent to which information contained on one level of a set of nested DFDs is also included on other levels.
A) DFD consistency
The extent to which information contained on one level of a set of nested data flow diagrams is also included on other levels refers to: A) DFD consistency B) DFD completeness C) DFD gap proofing D) DFD flexibility
Internet Backbone Network
The high-speed, high capacity network that interconnects regions, countries, and continents.
Context Diagram
The highest level in a data flow diagram. Contains only one process, representing the entire system. The process is given the number 0. All external entities, as well as major data flows are shown.
Minimal Guarantee
The least amount promised to the stakeholder by a use case
Minimal guarantee
The least amount promised to the stakeholder by a use case.
D) primitive data flow diagrams
The lowest level of DFDs is called: A) level-0 diagrams B) context diagrams C) level-1 diagrams D) primitive data flow diagrams
Context-level diagram flow diagram
The most basic data flow diagram of an organization showing how processes transform incoming data into outgoing information. Also called an environmental model.
context level data flow diagram
The most basic data flow diagram of an organization showing how processes transform incoming data into outgoing information. Also called an environmental model.
Cardinality
The number of instances of entity B that can (or must) be associated with each instance of entity A.
Cardinality
The numeric relationship between two entities, shows how instances of one entity relate to instances of another entity
A) source/sink
The origin and/or destination of data, sometimes referred to as external entities defines: A) source/sink B) data store C) data flow D) process
Source/sink
The origin and/or destination of data; sometimes referred to as external entities.
Source/sink
The origin and/or destination of data; sometimes referred to as external entitiies
Business process outsourcing (BPO)
The outsourcing of basic business process
A) action stubs
The part of a decision table that lists the actions that result for a given set of conditions is called: A) action stubs B) condition stubs C) rule section D) condition execution
B) condition stubs
The part of a decision table that lists the actions that result for a given set of conditions is called: A) action stubs B) condition stubs C) rule section D) condition execution
Action stubs
The part of a decision table that lists the actions that result for a given set of conditions.
Condition stubs
The part of a decision table that lists the conditions relevant to the decision.
C) rules
The part of a decision table that specifies which actions are to be followed for a given set of conditions refers to: A) action stubs B) condition list C) rules D) decision list
Rules
The part of a decision table that specifies which actions are to be followed for a given set of conditions.
View layer
The part of a three layer architecture that contains the user interface
Data layer
The part of a three layer architecture that interacts with the data
Database Administrator (DBA)
The person in charge of the safety and operation of the DBMS
Data Administrator (DA)
The person in charge of the structure and integrity of the data
Global outsourcing
The practice of shifting IT development, support, and operations to other countries
Offshore outsourcing
The practice of shifting IT development, support, and operations to other countries. Not global
False
The primary benefit of a network diagram, is to show the network cabling and the network routers.
D) gap analysis
The process in analysis in which the analyst tries to discover discrepancies between two or more sets of data flow diagrams, representing two or more states of an information system, or discrepancies within a single DFD, is referred to as: A) double checking B) sequencing C) referencing D) gap analysis
Normalization
The process of creating table designs by assigning specific attributes to each table in the database
Gap analysis
The process of discovering discrepancies between two or more sets of DFDs or discrepancies within a single DFD
Gap analysis
The process of discovering discrepancies between two or more sets of DFDs or discrepancies within a single DFD.
Domain
The set of all data types and values that an attribute can assume.
Extension
The set of behaviors or functions in a use case that follow exceptions to the main success scenario.
Extension
The set of behaviours or functions in a use case that follow exceptions to the main success scenario.
Application Architecture
The set of information systems the organization needs to support its operations.
World Wide Web
The set of resources that can be accessed over the Internet is referred to what?
Field
The smallest unit of named application data recognized by system software.
Data Type
The storage format and allowable content of a program variable, class attribute, or relational database field
D) a rectangle with rounded edges
The symbol for an activity is: A) a square B) a circle C) an arrow D) a rectangle with rounded edges
Database lock
The technique of applying exclusive control to a part of the database so the one use at a time can use the data
Breadcrumbs (navigation)
The technique of displaying the sequence of pages traversed to allow easy backing out to a previous page
Outsourcing
The transfer of information systems development, operation or maintenance to an outside firm that provides these services, for a fee, on a temporary or long-term basis.
Outsourcing
The transfer of information systems development, operation, or maintenance to an outside firm that provides these services, for a fee, on a temporary or long-term basis
What is outsourcing?
The transfer of information systems development, operation, or maintenance to an outside firm that provides these services, for a fee, on a temporary or long-term basis
D) process
The work or actions performed on data so that they are transformed, stored, or distributed defines: A) source/sink B) data store C) data flow D) process
Process
The work or actions performed on data so that they are transformed, stored, or distributed.
Outsourcing
Transfer of information systems development, operation, or maintenance to an outside firm.
A rectangle with rounded corners is used to show the occurrence of a transforming process.
True
A(n) fixed price contract provides for a stable customer price, but requirements will be well defined by the outsourcer at the beginning of the contract period.
True
An advantage of outsourcing the application development process is that the organization may acquire technical skills and functional knowledge from the vendor.
True
An object wrapper creates an application program interface (API) to a legacy system, enabling object-oriented systems to interact with it.
True
Each external entity is labeled with a noun.
True
Information is the major component of the e-commerce offerings of service industries. True False
True
The data flow diagram graphically characterizes data processes and flows in a business system.
True
The key mechanisms in the sell-side marketplace are customized electronic catalogs and forward auctions. True False
True
The physical architecture layer addresses how the software will execute on specific computers and networks.
True
The primary characteristic of auctions is that prices are determined dynamically by competitive bidding. True False
True
The three primary types of contracts that can be drawn to control the outsourcing deal are (1) a time and arrangements contract, (2) a fixed-price contract, and (3) a value-added contract.
True
Unbalanced decomposition means that the data flow to or from parent process does not match the data flow in or out of a child diagram.
True
Synonym
Two different names that are used for the same attribute.
Tables (Relations)
Two-Dimensional data structures consisting of columns and rows
users
Typically work with predefined queries and switchboard commands, but also use query languages to access stored data
Uniform resource locator
URL. Identifier of a web resource containing a protocol header, server name or address, and resource name
When the data flow in and out of a parent process do not match the data flow in or out of a child diagram, it is called:
Unbalanced Decomposition
Database Synchronization
Updating one database copy with changes made to other database copies
block sequence codes
Use blocks of numbers for different classifications 100-level courses are freshman-level 200-level courses are sophomore-level
Request for quotation (RFQ)
Used to obtain a price quotation or bid on a specific product or package
Ux
User experience. All aspects of a person's interaction with a software application, including actions, responses, perceptions, and feelings
User Application
Utilizes standard business software (Ex. Microsoft), which has been configured in a specific manner to enhance user productivity. Some user applications have powerful "screen generators" or "report generators" that allow users to design their own data entry forms and reports.
A firm that enhances a commercial package by adding custom features and configuring it for a particular industry is called what?
Value-added reseller
In what type of e-commerce business model do receivers send information about your product to their friends
Viral marketing
Companies engaged only in E-Commerce (also called pure play)
Virtual Organizations
VPN
Virtual private Network. Secure communication over the internet using technologies that reliably identify senders and recipients and encrypt Network messages sent among them
The ____ environment enhances interactive experiences, including wikis and blogs, and social networking applications.
Web 2.0
What are three examples of evolving trends in the IT world?
Web 2.0 Cloud Computing Mobile Devices
Middleware
Web based software usually requires additional layers, called middleware, to communicate with existing software and systems.
cascading style sheets (CSS)
Web page encoding standard that enables a Web site designer to specify parts of a page that will always look the same and parts that will vary by task or audience
Building an application in a ____ environment can offer greater benefits, and sometimes greater risks, compared to a traditional environment.
Web-based
Success Guarantee
What a use case must do effectively in order to satisfy stakeholders.
Success guarantee
What a use case must do effectively in order to satisfy stakeholders.
Local Area Network
What does LAN stand for?
Extensible Markup Language
What does XML stand for?
data element (or item)
What is a field also called?
HTTP is less secure, while HTTPS would be used for credit card transactions.
What is the difference between HTTP and HTTPS?
HTML5
What is the latest version of HTML? (As of 2016)
Functionally primitive
When a process is not exploded. Also referred to as a primitive process.
D) limited entry
When condition values are either "yes" or "no", these values are called a(n): A) extended entry B) simple entry C) complex entry D) limited entry
C) primitive data flow diagrams
When you believe that you have shown each business form or transaction, computer screen, and report as a single data flow, you have probably reached the: A) level-0 diagrams B) level-1 diagrams C) primitive data flow diagrams D) level-3 diagrams
C) A data store has a noun phrase label.
Which of the following is a true statement regarding a data store? A) Data can move directly from one data store to another data store. B) Data can move directly from a sink to a data store. C) A data store has a noun phrase label. D) Data can move from an outside source to a data store.
D) A join in a data flow means that exactly the same data comes from any of two or more different processes, data stores, or sources/sinks to a common location.
Which of the following is a true statement regarding data flows? A) A data flow may have multiple directions between symbols. B) A data flow to a data store means retrieve or use. C) A data flow from a data store means update. D) A join in a data flow means that exactly the same data comes from any of two or more different processes, data stores, or sources/sinks to a common location.
D) none of the above
Which of the following is considered when diagramming? A) the interactions occurring between sources and sinks B) how to provide sources and sinks direct access to stored data C) how to control or redesign a source or sink D) none of the above
C) Composite data flows on one level cannot be split into component data flows at the next level.
Which of the following is not an advanced rule governing data flow diagramming? A) To avoid having data flow lines cross each other, data stores may be repeated on a DFD. B) At the lowest level of DFDs, new data flows may be added to represent data that are transmitted under exceptional conditions. C) Composite data flows on one level cannot be split into component data flows at the next level. D) The inputs to a process must be sufficient to produce the outputs from the process.
D) state-transition diagram
Which of the following is not one of the primary deliverables resulting from studying and documenting a system's processes? A) context data flow diagram (DFD) B) thorough descriptions of each DFD component C) DFDs of the current logical system D) state-transition diagram
Extensible markup language
XML. An HTML extension that enables the meaning of words phrases or numbers to be defined
data mining
____ ________ Looks for meaningful data patterns and relationships in large amounts of data
physical storage
_______ _______ is strictly hardware-related because it involves the process of reading and writing binary data to physical media such as a hard drive, CD-ROM, or network-based storage device
logical storage
_______ _______ refers to data that a user can view, understand, and access, regardless of how or where that information actually is organized or stored
Level-0 diagram
a DFD that represents a system's major processes, data flows and data stores at a high level of detail
Level-0 diagram
a DFD that represents a system's major processes, data flows, and data stores at a high level of detail
service desk
a centralized resource staffed by IT pros that provides users with the support they need to do their jobs - help desk
build or buy
a choice between developing in house software and purchasing software, often called a build or buy, or make or buy, decision
three-layer architecture
a client/server architecture that divides an application into view layer, business logic layer, and data layer
database management system
a collection of tools, features, and interfaces that enables users to add, update, manage, access, and analyze data
server
a computer or group of computers that manages shared resources such as file systems, databases, and Web sites, and enables users and other computers to access those resources over a network
payback analysis
a determination of how long it takes an info system to pay for itself through reduced costs and increased benefits
software requirements specification
a document that contains the requirements for the new system, describes the alteratives that were considered, and makes a specific recommendation to management. it is the end product of the system analysis phase.
information center
a facility that supports users by training them on application software. user support specialists answer questions, troubleshoot problems, and serve as a clearinghouse for user problems and solutions
application service provider
a firm that delivers a software application, or access to an application, by charging a usage or subscription fee
value added reseller
a firm that enhances a commercial package by adding customer features configuring it for a particular industry
service provider
a firm that offers outsourcing solutions - application service providers and internet business services
radio buttons
a group of choices from which the user selects only one; the system then automatically turns off all other buttons in the group
evaluation and selection team
a group of people involved in selecting hardware and software. the group includes systems analysts and users. a team approach ensures that critical factors are not overlooked and that a sound choice is made
internet backbone network
a high-capacity and high-speed computer network that carries a large amounts of internet traffic across regions, countries, and continents
SQL (structured query language)
a language that allows client workstations to communicate with servers and mainframe cmputers
software license
a legal agreement that gives users the right to use the software under certain terms and conditions
individual matching
a matching technique in which each participant is matched with another participant on selected variables
yoked control
a matching technique that matches participants on the basis of the temporal sequence of administering an event
Decision table
a matrix representation of the logic of a decision; it specifies the possible conditions for the decision and the resulting actions
benchmark
a measure of time a package takes to process a certain number of transactions
think-aloud technique
a method that requires participants to verbalize their thoughts as they are performing the experiment
blind technique
a method whereby knowledge of each research participant's treatment condition is kept from the experimenter
partial blind technique
a method whereby knowledge of each research participant's treatment condition is kept from the experimenter through as many stages of the experiment as possible
software as a service
a model of software delivery in which functionality is delivered on demand as a network accessible service, rather than as a traditional software application that is downloaded and installed on the customer's computer
network program
a model that shows how locations and hardware components are inter-connected with network devices and wiring
Data flow diagram (DFD)
a picture of the movement of data between external entities and the processes and data stores within a system
Hypertext Transfer Protocol (HTTP)
a protocol that defines the format and content of requests for Web documents and related data communication
text box
a rectangular box that accepts text typed on a keyboard or recognized from speech input
web 2.0
a second generation of the web that enables people to collaborate, interact, and share info much more dynamically, based on continually available user applications rather than by HTML webpages. interaction experience is a hallmark of web 2.0
order effect
a sequencing effect arising from the order in which the treatment conditions are administered to participants
carryover effect
a sequencing effect that occurs when performance in one treatment condition affects performance in another treatment condition
transaction model
a service model that charges a variable fee for an application based on the volume of transactions or operations performed by the application - usage model
protocol
a set of languages, rules, and procedures that ensure accurate and efficient data exchange and coordination among hardware and software components
repeating group
a set of one or more fields that can occur any number of times in a single record, with each occurrence having different values
Protocol
a set of rules and procedures for control of communications in a network
local area network (LAN)
a small computer network typically spanning a single home, small office, or one floor of a building.
software as a service (SaaS)
a software delivery model similar to a utility, in which application software is accessed via the internet without locally installed programs
horizontal application
a software package that can be used by many different types of organizations
vertical application
a software package that has been developed to handle information for a specific type of business
maintenance agreement
a specification of the conditions, charges, and time frame for users to contact the vendor for assistance when they have system problems or questions
third normal form
a table design is in _____ ______ ____ if every non-key field depends on the key, the whole key, and nothing but the key
second normal form
a table design is in ______ ______ _____ if it is in 1NF and if all fields that are not part of the primary key are functionally dependent on the entire primary key
unnormalized
a table design that contains a repeating group is called ____________
combo box
a text box that contains a predefined list of acceptable entries but permits the user to enter a new value when the list doesn't contain the desired value
differential carryover effect
a treatment condition affects participants' performance in a later condition in one way and in another when followed by a different condition
service oriented architecture
a way of engineering systems in which reusable business functionality is provided by services through well defined interfaces.
Unified Modeling Language
a widely used method of visualizing and documenting software systems design
request for proposal
a written list of features and specifications given to prospective vendors before a specific product or package has been selected
one-to-many relationship
abbreviated 1:M, exists when one occurrence of the first entity can relate to many instances of the second entity, but each instance of the second entity can associate with only one instance of the first entity
many-to-many relationship
abbreviated M:N, exists when one instance of the first entity can relate to many instances of the second entity, and one instance of the second entity can relate to many instances of the first entity
business logic layer
also known as the domain layer, the part of a three-layer architecture that contains the programs that implement the business rules and processes
Extensible Markup Language (XML)
an HTML extension that enables the meaning of words, phrases, or numbers to be defined
entity
an ______is a person, place, thing, or event for which data is collected and maintained
open database connectivity
an industry-standard protocol that makes it possible for software from different vendors to interact and exchange data
in house software
an information center or help desk within the IT department responsible for providing user support and offering services such as hotline assistance, training, and guidance to users who need technical help
screen generator
an interactive tool that helps design a custom interface, create screen forms, and handle data entry format and procedures - also called form painter
World Wide Web (WWW)
an interconnected set of resources accessed via the internet
postexperimental inquiry
an interview of the participant after the experiment is over
Functional decompoition
an iterative process of breaking the description of a system down into finer and finer detail, which creates a set of charts in which one process on a given chart is explained in greater detail on another chart
newsgroup
an online discussion on a particular topic, where people meet, offer support, and exchange ideas - also called forum
app
application software that is installed on the storage device of a computer or cell phone
Web-based application
application software that uses a Web browser as the user interface, has a URL for application access, uses a Web server and server-side software components, and uses Web standards for communication between Web browser and server
Enterprise Software
applications that address the needs of multiple users throughout an organization or work group
report generator
atool for designing formatted reports rapidly - also called report writer
The design phase of the SDLC creates a(n) _____.
blueprint for the future system
XML tags
character sequences (such as and ) that define the beginning, end, and meaning of the text that appears between them
software vendor
company that develops software for sale
Routers
computing devices that connect networks and exchange data between them
table (file)
contains a set of related records that store data about a specific entity
usability
degree to which a system is easy to learn and use
cardinality
describes the numeric relationship between two entities and shows how instances of one entity relate to instances of another entity
user-centered design
design techniques that embody the view that theuser interface is the entire system
complete counterbalancing
enumerating all possible sequences and requriing different groups of participants to take each of the sequences
incomplete counterbalancing
enumerating fewer than all possible sequences and requiring different groups of participants to take each of the sequences
Extensible Markup Language (XML)
extension of HTML that embeds self-defining data structures within textual Messages
turnaround documents
external outputs that includes one or more parts intended to be returned with new data or information
human-computer interaction (HCI)
field of study concerned with the efficiency and effectiveness of user interfaces vis-à-vis computer systems, human-oriented input and output technology, and psychological aspects of user interfaces
Software as a Service (SaaS)
firm subscribes to a third-party software and receives a service that is delivered online
When determining outsourcing fees, a ____ uses a set fee based on a specified level of service and user support.
fixed fee model
In the accompanying figure, a ____ is a field in one table that must match a primary key value in another table in order to establish the relationship between the two tables.
foreign key
sacrifice groups
groups of participants who are stopped and interviewed at different stages of the experiment
The layer that keeps the user interface implementation separate from the application or problem domain classes is the _____ layer.
human-computer interaction
Uniform Resources Locator (URL)
identifier of a Web resource containing a protocol header, server name or address, and resource name
method of difference
if groups are equivalent every variable except for one, then that one variable is the cause of the difference between the groups
Indifferent condition
in a decision table, a condition whose value does not affect which actions are taken for two or more rules
Indifferent condition
in a decision table, a condition whose value does not affect which actions are taken for two or more rules.
There are three methods to create a new system. They are ___.
in-house custom application, buy a package, and external vender
The following are all classic design mistakes EXCEPT _____.
including design time
record (tuple)
is a set of related fields that describes one instance, or occurrence, of an entity, such as one customer, one order, or one product
The following are all strengths of a custom development design strategy EXCEPT ___.
lower risk
database administrator
manages a DBMS, assesses overall requirements and maintains the database for the benefit of the entire organization rather than a single department or user
Server
manages shared resources & enables users and other computers access to these resources
A data ____ language controls database operations, including storing, retrieving, updating, and deleting data.
manipulation
scalability
means that a system can be expanded, modified, or downsized easily to meet the rapidly changing needs of a business enterprise
document metaphor
metaphor in which data is visually represented as paper pages or forms
direct manipulation metaphor
metaphor in which objects on a display are manipulated to look like physical objects (pictures) or graphic symbols that represent them (icons)
desktop metaphor
metaphor in which the visual display is organized into distinct regions, with a large empty workspace in the middle and a collection of tool icons around the perimeter
dialog metaphor
metaphor in which user and computer accomplish a task by engaging in a conversation or dialog via text, voice, or tools such as labeled buttons
To bridge the gap between a database and the Web and enable data to be viewed and updated, it is necessary to use ____, which is software that integrates different applications and allows them to exchange data.
middleware
Web-based software usually requires additional layers, called ____, to communicate with existing software and legacy systems.
middleware
To avoid the classic design mistake of "silver bullet syndrome," the analyst should ___.
not use a design tool that appears too good to be true
concurrent probing
obtaining a participant's perceptions of the experiment after completion of each trial
Internet Backbone
owned by governments & telecom companies
The ___ layer addresses how the software will execute on specific computers and networks.
physical architecture
In the accompanying figure, a ____ is a field or combination of fields that uniquely and minimally identifies a particular member of an entity.
primary key
user application
programs that utilize standard business software, such as Microsoft office, which has been configured in a specific manner to enhance user productivity
A(n) ____, which is used to access stored data, allows a user to specify a task without specifying how the task will be accomplished.
query language
random assignment
randomly assigning a sample of individuals to a specific number of comparison groups
audit log files
record details of all accesses and changes to the file or database and can be used to recover changes made since the last backup
In an entity-relationship diagram, entities are represented as ____.
rectangles
One type of validity check, called ____ integrity, is a set of rules that avoids data inconsistency and quality problems.
referential
The complete definition of a database, including descriptions of all fields, tables, and relationships, is called a(n) ____.
schema
virtual private network (VPN)
secure communication over the Internet using technologies that reliably identify senders and recipients and encrypt network messages sent among them.
mobile device
smartphones, tablets, and other computing devices that are not permanently tethered to a desk
table design
specifies the fields and identifies the primary key in a particular table or file
Amdahl's Law
systems speed is determined by its slowest component or the last mile
hyperlink
the URL of one Web resource is embedded within another Web resource
interoperability
the ability of a component or system to interact with other components or systems
The decision on which design strategy to use depends on ___.
the expertise of the project manager, how unique the business need is, the amount of in-house experience, the urgency of the project
DFD consistency
the extent to which information contained on one level of a set of nested DFD's is also included on other levels
Source/sink
the origin and/or destination of data; sometimes referred to as external entities
business process outsourcing
the outsourcing of a basic business process
Condition stubs
the part of a decision table that lists the conditions relevant to the decision
Action stub
the part of a decision table that specifies which actions are to be followed for a given set of conditions
view layer
the part of a three-layer architecture that contains the user interface
global outsourcing
the practice of shifting IT development, support, and operations to other countries
offshore outsourcing
the practice of shifting IT development, support, and operations to other countries
automation
the technique of totally automating the experimental procedures so that no experimenter participant interaction is required
absolute date
the total number of days from some specific base date
net present value
the total value of the benefits minus the costs, with both the costs and benefits being adjusted to relflect the point in time at which they occur
outsourcing
the transfer of info systems development, operation, or maintenance to an outside firm that provides these services, for a fee, on a temp or long term basis
Attribute Value
the value held in a single table cell.
What is the primary objective of the evaluation and selection team?
to eliminate system alternatives that will not meet requirements, rank the alternatives that are feasible, and present the viable alternatives to management for a final decision
alphabetic codes
use alphabet letters to distinguish one item from another based on a category, an abbreviation, or an easy to remember value, called a mnemonic code
use case
use case summarizes an event and has a similar format to process specifications
request for quotation
used to obtain a price quote or bid on a specific product or package
A ___________ utilizes standard business software, such as word or excel, which has been configured in a specific manner to enhance user productivity
user application
drill down
user-interface design technique that enables a user to select summary information and view supporting detail
visibility
when a control is visible so that users know it is available, the control providing immediate feedback to indicate that it is responding to the user
peer-to-peer connection
when independent computers communicate and share resources without the need of a centralized server computer
differential influence
when the influence of an extraneous variable is different for the various groups
Transmission Control Protocol (TCP)
works at both ends of internet communications to ensure perfect copies of messages are sent
