encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support the performing of daily operational tasks.
encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks.
hierachical database model
here information is organised into a tree like model that allows repeating of information.
rational database model
database that store information in the form of logically related two dimensional tables.
the relational database model is a person, place, thing, transaction, or event about which information is stored.
the relational database model is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
of information deals with the physical storage of information on a storage device such as a hard disk.
focuses on now users logically access information to meet their particular business needs.
relational integrity constraints
are rules that enforce basic and fundamental information-based constraints.
business-critical integrity constraints
enforce business rules vital to an organizations success and often require more insight and knowledge than relational integrity constraints.
database management systems
is softward through which users and application programs interact with a database
is an interactive website kept constantly unpdated and relevant to the needs of its customers through the use of the data base.
takes information entered into a given system and sends it automatically to all downstream systems and processes.
takes informational entered into a given system and sends it automatically to all upstream systems and processes.
is a logical collection of information, gathered from many different operational databases that supports businessanalysis activities and decision making tasks.
a process that extracts information from intelectual and external databases, transforms the information using a common set of enterprize definitions and loads the information into the data warehouse.
information cleansing or scrubbing
this is a process that weeds out and fixes or discards inconsistent, incorrect, or incompleat information.
this is the process of analysing data to extract information not offered by the raw data alone.
customer reltionship management (CRM)
this involves managing all aspects of a customers relationship with an organization to increase customer loyalty and retention and organizations profitability.
help organizations identify their customers into categories such as best and worst customers.
supports traditional processing for day to day office operations or systems that deal directly with the customers.
supports back office operations and stategic analysis and includes all systems that do not directly deal the customers.
compile customer information froma variety of sources and segment information for different marketing campaign.
campaign management systems
guide uses through marketing campaigns performing such tasks as campaingn defintition planning, scheduling, segmentation and success analysis.
sales force automation
this is a system that automatically tracks all of the steps in the sales process.
sales management CRM systems
automate each phase of the sales process helping individual sales representatives coordinate their accounts.
contact management CRM systems
maintains customer contact information and identifys prospective customers for future sales.
opportunity management CRM systems
target sales opportunities by finding new customers or companies for future sales.
web based self service
allows customers to use the web to find answers to their questions or solutions to their problems.
occurs when a website can know enough about a persons likes that they offer more entising products.
focuses by keeping suppliers satisfied by evaluating and categorizing supppliers for different products.
focuses on keeping vendors satisfied by managing alliance partner and reseller relationships that provide customers with the optimal sales channel.
business information systems
refers to applilcations and technologies that are used to gather, provide access to, and analyze data and information to support decision making efforts.
data mining tools
use a variety of techniques to find patterns and relationships in large volumes of information.
is a technque used to devide an information set into mutally exclusive groups such that the members of each group are as close together as possible.
reveals the degree to which variables are related and the nature and frequency of these relationships in the information.
market basket analysis
aqnalyzes such items as websites and checkout scanner information to detect customers buying behavior.
performs such functions as info correlations distributions calculations and various analysis.
single point of access to information for users
with a BI solution, organizations can unlock information heldwithin theri databases by giving authorized users a singlepoint of access to data.
bi access across organization departments
the greatest benefit is that it can be used at every stop in the calue chain.
these include benefits working time saved in producing reports, selling information to suppliers and so on.
indireclty quantifiable benefits
this can be evaluated though indirect evidence such as improved customer service.
include improved communication thoughout the enterprise, improved job satisfaction of empowered users, and improved knowledge sharing.
predicting machinery failures; finding key factors that control optimization of manufacturing capacity.
brokerage and securities trading
predicting when bond prices will change; forecasting the range of stock fluctuations for particular issues and the overall market.
classifying customer demographics that can be used to predict which customers will respond to a mailing or buy a particular product.
enteprise resource planning (ERP)
integrates all departments and functions throughout an organization into a single IT system (better decisions can be made).
Core ERP compenents
are the traditional compenents included in most ERP systems and they primarily focus on internal operations.
Extended components ERP
are the extra components that meet the organizational needs covered by the core components and primarily focus on external operations.
Accounting and finance components ERP
manage accounting data and financial processes within the enterprise with functions such as general ledger, accounts payble, accounts receivable
productiong and materials management components ERP
handle the various aspects of production planning such as productiong scheduling.
human resources components ERP
track employee information including payroll, benefits, compensation, and performance assessment.
extended components ERP
the extra components that meet the organizational needs not covered by the core compenents.
supply chain management (SCM)
involves the management of information flows between and amoung stages to maximise effectiveness and profitability.
means conducting business on internet, not only buying and selling but also serving customers.
this is the business to business (B2B) purchase and sale or supplies and services over the internet.
this is several different types of softward that sit in the middle of and provide connectivity between two or more software apllicationss.
Enterprise application integration (EAI) middleware
this represents a new approach to middleware by packaging together commonly used functionality, such as providing prebuilt links to popular enterprise applications.
this is a management systtem, in addition to a measurement system, that enables organization to clarify their vision and strategy and translate them into action.
proper business analysis
the best way to determine which fit stategy is right to conduct a thorough business analysis.
systems development life cycle (SDLC)
this is the overall process for developing information systems from planning and analysis through implementation and maintenence
involves analyzing end-user business requirements and refinning project goals into definned functions and operations of the intended system.
are the detailed set of business requests that the system must meet in order to be successful.
involves describing the desired features and the operations of the system including screen layouts.
involves taking all of the detailed design documents from the design phase and transforming them into the actual system
involves bringing the project pieces together into a special testing enviroment to test for errors and bugs.
involves placing the system into production so users can begin to perform actual business operations witth the system
involves performing changes, corrections to ensure the system continues to meet the business goals.
this is an activity-based process in which each phase in the SDLC is performed sequentially from planning through implementation and maintenance
aims for the customer satisfaction through early continous delivery of useful software components developed by an iterative process.
rapid application development (RAD) methodology
emphasizes extensive user involvement in the rapid and evolutionary construction of working prototypes of a system to accelerate the systems developemnt process.
smaller-scale representation or working model of the users' requirements or a proposed design for an information system.
extreme programming (XP) methodology
like other agile methods, breaks a project into tiny phrases, and developers cannot continue on to the next phase untill the first pahse is complete.
individuals involved in the project whose interests might be affected as a result of project execution.
the document issued by the project initiator, formally authorizing the existance of a project.
(by a business person) a formal (understandable) approved document that manages and controls project execution. it needs to be team based and therigth size for your business.
program evaluation and review technique (PERT)
this is a graphical network model that depicts project's tasks and the relationships between those tasks.
this is where a company offers services for another company and does not perform those services in house.
using organizations from developing countries to write code and develop systems.
by taking advantage of outsourcing, an organization is able to acquire best-practice process expertise
the pervasive nature of the internet as an effective sales channel has allowed clients to become more comfortable with outsourcing
contract legth problem
difficulty of getting out of a contract, problems in foreseeing resources needed, problems reforming intenal IT contact.
effective and innovative use of IT can give an organization a _________ over it's rivals.
some companies decide against outsourcing due to secret information getting into the hands of the provider.
What in the relational database model is a person, place, thing, transaction, or event about which information is stored?
All of the following are advantages of database-stored information, except:
Increased information redundancy
how does CRM allow a business to perform better
Help sales staff close deals faster, Make call centers more efficient and Provide better customer service.
Which of the following operational CRM technologies does the marketing department typically use?
List generator, campaign management, cross-selling and up-selling
What targets sales opportunities by finding new customers or companies for future sales?
Opportunity management systems
What allows customers to use the web to find answers to their questions or solutions to their problems?
What focuses on keeping suppliers satisfied by evaluating and categorizing suppliers for different projects, which optimizes supplier selection?
Supplier relationship management
Which of the following is one of the CRM business drivers?
Automation/productivity/efficiency, Increase revenues and Inventory control
What activities do production and materials management components perform?
Handle the various aspects of production planning and execution such as demand forecasting, production scheduling, job cost accounting, and quality control.
Which extended ERP component collects information used throughout an organization, organizes it, and applies analytical tools to assist managers with decisions?
What are several different types of software, which sit in the middle of and provide connectivity between two or more software applications?
What represents a new approach to middleware by packaging together commonly used functionality, such as providing prebuilt links to popular enterprise applications, which reduces the time necessary to develop solutions that integrate applications from multiple vendors?
Enterprise application integration middleware
What is an IT-based set of tools that supports the work of teams by facilitating the sharing and flow of information?
What provides tools to manage the creation, storage, editing, and publication of information in a collaborative environment?
Content management system