ISQS 2340 EXAM STUDY GUIDE
Data - Answers- Facts and statistics collected together for reference or analysis
information - Answers- Data converted into a meaningful and useful context
knowledge - Answers- Skills, experience, and expertise coupled with information and
intelligence that creates a person's intellectual resources
database system - Answers- An organization of components that defines and regulates
the collection, storage, management, and use of data in a database environment.
Database - Answers- a collection of organized data that allows access, retrieval, and
use of data
Big Data - Answers- a broad term for datasets so large or complex that traditional data
processing applications are inadequate.
data integrity - Answers- In a database or a collection of databases, the condition that
exists when data values are consistent and in agreement with one another.
data model - Answers- logical data structures that detail the relationships among data
elements using graphics or pictures
relational database - Answers- A database that represents data as a collection of tables
in which all data relationships are represented by common values in related tables
Primary Key - Answers- A field (or group of fields) that uniquely identifies a given entity
in a table
Foreign Key - Answers- 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
data type - Answers- indicates the type of data that can be stored in a field
SQL - Answers- Structured Query Language
NoSQL - Answers- A new generation of database management systems that is not
based on the traditional relational database model.
Database Management System (DBMS) - Answers- creates, reads, updates, and
deletes data in a database while controlling access and security
Technology - Answers- The application of scientific knowledge for practical purposes
Hardware - Answers- the physical parts of a computer
, software - Answers- the programs and other operating information used by a computer.
Networking and Communications - Answers- The practice of connecting two or more
computers in order to transfer data.
Components of an Information System - Answers- hardware, software, data,
procedures, people
Post-PC Era - Answers- An era characterized by the proliferation of new device form
factors, such as tablets or smartphones, which complement or even replace traditional
PCs and laptops.
RetailLink/Walmart (SCM IT) - Answers- you can see how many stores you're in, how
many things you've sold, and how many units they have (when something goes out of
stock, the manufacturer is told to immediately send some to the store through this)
ERP (Enterprise Resource Planning) - Answers- a suite of applications called modules,
a database, and a set of inherent processes for consolidating business operations into a
single, consistent, computing platform
What are reasons businesses use ERP systems? - Answers- ERP systems improve
enterprise efficiency and effectiveness in several ways. By integrating financial
information in a single system, ERP systems unify an organization's financial reporting.
What are some of the benefits of ERP systems? - Answers- The standardization and
simplification that ERP systems offer result in fewer rigid structures, thereby creating a
more agile enterprise that can adapt quickly while increasing the potential for
collaboration.
operating system - Answers- the software that supports a computer's basic functions,
such as scheduling tasks, executing applications, and controlling peripherals.
Application Software - Answers- computer software created to allow the user to perform
a specific job or task
PC Revolution - Answers- a phrase used to describe the rapid advances of
microprocessor-based computers from esoteric hobby projects to a commonplace
fixture of homes in industrial societies during the 1970s and 1980s.
Enterprise-wide integration - Answers- Business processes are integrated end to end
across departments and business units. For example, a new order automatically
initiates a credit check, queries product availability, and updates the distribution
schedule. Once the order is shipped, the invoice is sent.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller GEEKA. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.99. You're not tied to anything after your purchase.