Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
71 Cards in this Set
- Front
- Back
|
Most Popular Browser in the World
|
Google Chrome
|
|
|
Computer System that competed on Jeopardy and Won
|
IBM Watson
|
|
|
Decision making process that involves choosing alternatives. In order to make this choice, we need:
|
Information Alternatives
|
|
|
The hardware/software/media used to store, organize, retrieve, and communicate information is known as:
|
Information Technology
|
|
|
Knowledge can best be described as:
|
Information that is applied to a decision or action
|
|
|
A set of coordinated activities that lead to specific goal/ outcome is known as:
|
Business Process
|
|
|
Looks Similar to a Flow Chart
|
Business Process
|
|
|
How to Calc Net Pay?
|
=Pay after Pre-Tax Deduction - Fed Taxes - Social Security
|
|
|
Why should I use a spreadsheet?
|
To keep a personal budget
|
|
|
What company is least likely to use excel?
|
Facebook
|
|
|
For Data to be useful it must be able to form what 4 core operations?
|
1) C reaton
2) R etrieval 3) U pdate 4) D elete |
|
|
What does DB Stand for?
|
Database
|
|
|
What does DBMS stand for?
|
Database management system
|
|
|
Database
|
Collection of tables logically related
|
|
|
Entities
|
Persons, Places, Events
|
|
|
Attributes
|
Pieces of Info about an entity
|
|
|
Field
|
Known as attributes or columns
|
|
|
Record
|
Row
|
|
|
Table
|
Collection of records
|
|
|
Primary Key
|
Unique Attributes used to identify a single instance of an entity.
|
|
|
Compound Primary Key
|
Unique combination of attributes used to identify a single instance of an entity
|
|
|
Which is the most likely primary key?
|
Course ID
|
|
|
Foreign Key
|
Primary key of one entity that is duplicated in another entity to identify relationships
|
|
|
When should i use associative entity
|
When my boss tells me to
|
|
|
Typical Hotel Reservations include
|
Personal Computer, Customer, and Networking
|
|
|
Which is the most important element of Info Systems?
|
People
|
|
|
In race with machines, Professor Brynjolfsson says we need to:
|
Reinvent our organizations and reinvent our economic measurements
|
|
|
An email sent to an instructor when a students adds a class is an example of :
|
Information Flow
|
|
|
Students are not allowed to register for a class b/c no pre-req is example of:
|
Process Control
|
|
|
Students can now see final course grades in icon before notice from registrar
|
Process Improvement
|
|
|
Autocorrecting?
|
Midterm?
|
|
|
What airline was the first to use a barcode for scanning on boarding passes?
|
Southwest
|
|
|
Consistent formatting and formulas can be maintained across 4 quarterlly worksheets by using
|
Worksheet Grouping
|
|
|
Which excel functions will be required to calculate a bonus payout
|
IF ( Function)
|
|
|
What is a 3D reference
|
Cross-referencing multiple worksheets creates an additional dimension
|
|
|
Which formula would compute projected beverage sales in april?
|
='Quarter 1' ! D6 * (1+$B$50)
|
|
|
Collaborative Consumption
|
a class of economic arrangements in which participants share access to products or services, rather than having individual ownership. Often this model is enabled by technology
|
|
|
Serious Networking
|
FIND
|
|
|
Rachel Botsman says collaborative consumption is enabled by :
|
Trust enabled by technology
|
|
|
What is essential for collaborative consumption and a sharing economy?
|
Quality information
|
|
|
Rachel Botsman suggests that to allow for transactions b/w strangers there is need for technology to aggregate
|
Reputation Capital
|
|
|
Which formula could be used to calculate the annual sales for beverages using the quarterly projections
|
=Sum('Quarter 1:Quarter 4' ! E6)
|
|
|
Name three things must be used to set up field in a table
|
1) Name
2) Data Type 3) Size |
|
|
What is a query?
|
A database function that extracts and displays information from a database given parameters
|
|
|
What does SQL stand for?
|
Search Query Language
|
|
|
SQL is also known as:
|
Data Programming Language
|
|
|
Name 4 Basic SQL Commands
|
1) Select
2) Update 3) Delete 4) Insert |
|
|
How would you use a query to select all residents of CA and IL
|
Select* From Client Information Where State='CA' or State= 'IL'
|
|
|
What is a field called when a primary key is one field in one table is the join field another table?
|
Foreign Key
|
|
|
Referential Integrity Constraint between 2 tables in case 6 will not allow to add:
|
A client ID value to the client info table without a corresponding schedule table
|
|
|
Records in a table are called a _____ of an entity
|
instance
|
|
|
Is an associative entity needed?
|
Yes
|
|
|
Which of these would be a primary key for a registration table
|
Section ID, Student ID
|
|
|
Update Anomaly
Insertion Anomaly Deletion Anomaly |
FIND
|
|
|
Normalization
|
Process that enables a designer to eliminate design problems by decomposing the existing table structures
|
|
|
Benefits of normalization
|
Better represents actual business situation and less redundant data
|
|
|
1NF
|
1st Normal form: model in 1NF, if for every instance of an entity each attribute of the instance is completely determined by the totality of the instances PK not just by some of its componenets
|
|
|
2NF
|
2ND Normal form: model in 1NF, AND for every PK with 2 or more components, each attribute is completely determined by instances PK not just by some of its components
|
|
|
3rd NF
|
a model is in 3NF if in 2nF and for every instance of an entity each secondary attribute is dependent only on the PK not any other secondary attribute
|
|
|
Which attribute can have multiple values
|
Course ID
|
|
|
How many entries are there in a 3NF database
|
4
|
|
|
When joins cant be set, what is the problem ?
|
Some values do not match between tables OR joining the wrong fields
|
|
|
Difference between parent and child entity
|
Parent entity is derived from child entity
|
|
|
Strategic Info System
|
Wen businesses use info to gain a competitive advantage
|
|
|
A web site of a bank allows account holders to view their current balance and make transactions is an example of:
|
A routine Info System
|
|
|
Quick trip is changing all of three stores to accept a form of e-money with their checkout and smart phones. What is this an example of?
|
Architecture
|
|
|
When should Porters 5 competitive forces approach best be used.
|
Determine whether or not to enter a market as a competitor.
|
|
|
Which would likely be a critical success factor for XYZ Logistics?
|
Low order-to-shipping time
|
|
|
For XYZ Logistics which uses robots that move on warehouse floors the use of drones by abc logistics for retrieving warehouse items would indicate:
|
Potential Threat of substitutes
|
|
|
Example of web 2.0
|
Youtube
|
|
|
What is the Value of Parameter Q in: http://www.google.com/finance/?Q=GOOG?
|
GOOG
|
