CISP 10 and 12

Transaction

A business activity central to the nature of an enterprise- for example, a product being sold, an airline flight being booked, or a college course grade being recorded

Quick Response Code (QR)

A code that provides a signal to a consumer that he or she can find out more about a product or service online, by scanning the code with a mobile QR code scanner app

Database

A collection of data organized in one or more data tables stored on a computer, managed using database management system software

Record

A collection of related fields describing a single entity in a data table

Information System (IS)

A combination of hardware, software, networks, and other components that collect, store and process data that people in organizations use to manage daily and long-term operations and create and sell various types of products

Systems Integrator

A company that specializes in installing and supporting information systems

Primary key

A database field that must contain only unique entries, such as unique ID numbers, so it can be used to locate records quickly. The database designer sets the most important field in a table as the primary key

Operational database

A database system that works by offering a snapshot of a fluid situation. It usually tracks a changing operation or situation, such as the inventory of a store

Hybrid database

A database that may use different models together to allow more effective data handling

Legacy database

A database that runs using languages, platforms, or models that are no longer supported by an organizations current database system

Data warehouse

A database that stores data gathered from one or more databases, creating a vast storage space for information to be used in a variety of ways. It receives only periodic updates, or may rely on data from other sources for updates

Data type

A field property that specifies the type of information the field will hold. Examples include numeric, alphanumeric and data

Relational database

A model used by most modern databases in which fields with similar data can be connected between data tables or files in the database, making it possible to retrieve data from the related tables

Radio Frequency Identification (RFID)

A modern warehouse technology used to enhance inventory tracking and placement. RFID tags or labels include an integrated circuit and are able to receive and transmit a radio frequency signal

Turnkey System

A new information system that contains everything a business needs to get it up and running. The name comes from the idea of simply being able to "turn the key" similarly to how you start a car by turning the key to start the engine

Structured Query Language (SQL)

A popular query language that enables users to request information from a database. SQL works with most databases, and can bridge communications gaps between different database systems

Query by Example (QBE)

A process in which the user builds a query by selecting one or more tables, adding the fields to display in the results in a query grid, and then entering the entry to match or other criteria in applicable fields

Data mining

A process that involves using advanced computing to find patterns and relationships in large sets of data in order to apply an organizing structure and extract information

Standard Operating Procedure (SOP)

A set of instructions describing how to perform a task

Expert System

A sophisticated decision support system that attempts to model an experts knowledge of a topic

Flash Sale

A special sale where the online retailer sells a small quantity or surplus of stock at a large discount for a limited period of time

Customer Relationship Management (CRM)

A structured system to track interactions with current and potential customers, including building a customer contact list, targeted marketing and promotions, mobile and social marketing, and customer service and support tracking

Executive Information System (EIS)

A system that attempts to bring together information from an entire organization, rather than focus on any one department or group, for strategic decision making by executives

Electronic Data Interchange (EDI)

A system that automates repetitive business processes and is used by many business to exchange specially formatted business documents, such as purchase orders, invoices, credit application and approval forms, and shipping notices.

Statistical Quality Control (SQC)

A system that combines data tracking and modeling to quantify how well a factory operates, including measures such as final product quality compared with the conditions present throughout the manufacturing process

Online Analytical Processing (OLAP)

A system that defines and clarifies methods of handling "what if?" questions posed to large databases, as well as to massively distributed data systems such as the internet

Niche Information System

A system that exists to serve a specially focused set of customers

Computer-Aided Manufacturing (CAM)

A system that involves the direct use of computerized systems to manufacture products, such as the use of robots in automobile manufacturing plants

Management Information System (MIS)

A system that provides information that assists in the management of business operations

Computer-Integrated Manufacturing (CIM)

A system that provides much broader coverage than a computer-aided manufacture (CAM) system. A CIM focuses not only on the factory floor but also on the company as a whole

Decision Support System (DSS)

A system that uses data modeling to evaluate business cases or problems to help managers make informed business judgments

Enterprise Resource Planning (ERP)

A system that uses integrated applications or modules for the various business functions that work with the data in a centralized database

Flat file database

A traditional data file storage system that contains only one data table or file

Multimedia database

A type of database that allows the storage of pictures, movies, sounds, and hyperlinked fields

Distributed database

A type of database that spreads its data across multiple networked computers, with each one storing a portion of the data. It can hold more information and allows for cheap and easy expansion, as for public cloud computing

Object oriented database

A type of database that stores data in the form of objects

Supply Chain Management (SCM)

An area of expertise that involves establishing, running, and refining a supply chain

OLAP Cube

An array of data that structures data in multiple dimensions

Database administration

An important IT function that involves operating and maintaining the database system

Referential integrity

Involves making sure that the records entered into tables remain consistent with the relationships between tables

Which database model is used most when creating databases today?

Relational Database

Data validation

Techniques that ensure that users enter correct and complete data into the system

Connectivity

The ability to link with other programs and devices

Business Intelligence (BI)

The information yielded through effective use of online analytical processing systems

Normalization

The process of structuring a database to avoid redundancy and undesirable dependencies

Record

is A collection of related fields describing a single entity in a data table.

Field

is A single type of information in a data table, such as a name, an address, or dollar amount

Vertical Market System

is one in which the main members of a distribution channel—producer, wholesaler, and retailer—work together as a unified group in order to meet consumer needs