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;
35 Cards in this Set
- Front
- Back
what is a database?
|
a self describing collection of integrated records
|
|
what are the 4 major components of a database?
|
1. entity
2. attributes 3. records 4. relationships 5. metadata |
|
what is a data model?
|
a logical representation of the data in a database that describes the data and relationships that will be stored in the database
|
|
what is an E-R data model and what are the components of it?
|
an Entity-relationship data model
Components: 1. entity 2. attributes (describe characteristics of entity) 3. identifier (attritube whose value is associated with one instance of an entity. ex. primary key) 4. relationships (connection between entities) |
|
what network element device prevents intrusion?
|
a firewall
|
|
what is normalization?
|
the process of coverting poorly structured tables into two or more well-structured tables
|
|
how do you transform a data model in a database design?
|
-convert data model into tables, relationships, and data constraints
1. entities into tables 2. attributes into fields/columns of the tables 3. identifiers of each entity into a primary key of the table. every table has to have a primary key 4. expresses the relationships by defining foreign keys 5. normalization, as necessary |
|
what is a primary key and why do databases use them?
|
-an attribute/s which uniquely identify a record in a table
1. every table must have a primary key 2. the data must be static (value of PK cannot change over time) 3. ALWAYS a required field |
|
what does DBMS stand for and what is it?
|
Database management system
the computer program used to manage and query a database. |
|
What does the acronym C.R.U.D. stand for?
|
Create
Read Update Delete |
|
why should you use the auto-number feature for a primary key?
|
Primary key's can't change value and Auto-number helps make sure value is static
|
|
what are the 2 types of Business Process Modeling Notation (BPMN)? (5 points)
|
1. Swimlane
2. Standard |
|
what does LAN stand for and what is it?
|
LAN= Local Area Network
A) computers connected on a single company site B) Usually located in a small area (home, office building/s) |
|
what does WIMAX stand for?
What is it? |
Worldwide Interoperability for Microwave Access
a telecommunications techonoloy that provides fixed, nomadic, portable, and fully mobile internet access |
|
What is a modem? How is a DSL modem different from an older modem?
|
Modem- a device to produce a signal to can be transmitted easily and decoded to reproduce the original digital data
Old modems used Narrowband (less than 56 kbps), DSL uses Broadband (more than 256 kbps) |
|
What does D.S.L. stand for? and how does it work?
|
Digital subscriber line
1. operates over telephone lines 2. data signals do not interfere with voice telephone service 3. faster data transmission than dial-up |
|
What is encryption and how does it work?
|
encryption is the process of transforming clear text into coded text
uses algorithms to encrypt data. Algorithm requires a key to encrypt and decrypt data |
|
What is Symmetic encryption?
What is Asymmentric Encryption? |
Symmetric encryption- same key encrypts and decrypts algorithm
Asymmetric encryption - different keys are used. One key encrypts data, another key decrypts data (this one is more complicated, therefore more secure) |
|
What are functional processes?
What are functional applications? |
business processes that support a single organizational function
a computer program that supports or possibly automates the major activities in a functional process |
|
What are some issues with functional processes?
|
isolated functions cause:
1. data duplication 2. Disjointed business processes 3. Lack of integrated enterprise (or competitive/market) information 4. Operational and intangible costs |
|
What are the stages of Business Process Management (BPM)?
|
1. model as-is function
2. evaluate functional application and select best fit 3. implements the functional application in the contect of the particular functional process |
|
what does CRM stand for and what is it?
|
Customer Relationship Management
CRM applications integrate all of the primary business functions depicted in Porter's Value Chain |
|
what is business intelligence? What is it's purpose?
|
BI represents the tools and systems that play a key role in the strategic planning process of the corporation.
These systems all a company to gather, store, access and analyze corporate data to aid in decision-making. |
|
What is data-mining and what is an example of a data-mining system?
|
1. use sophisticated statistical techniques, regression analysis and decision tree analysis
2. used to discover hidden patterns and relationship 3. used to anticipate and predict SPSS Clementine: data mining system |
|
What are the 4 business intelligence systems? What does each system do?
|
1. Reporting system
2. Data-mining system 3. Knowledge management system 4. Expert Systems |
|
What is market basket analysis?
|
correlates past orders to determine purchasing frequency
|
|
What are the 5 components of an Information system?
|
1. Hardware
2. software 3. data 4. procedures 5. people |
|
What is E-commerce?
|
buying and selling goods and services over public and private networks
|
|
What are the types of E-Commerce Merchant Companies?
|
A) Business-to-customer (B2C)
B) Business-to-Business (B2B) C) Business-to-Government (B2G) |
|
What are the 3-tiers for E-Commerce?
|
1. User tier
2. Server Tier 3. Database Tier |
|
What is web 2.0?
|
refers to loose cloud of capabilities, technologies, business models, philosophies
|
|
What are some Characteristics of Web 2.0?
|
A) Users and use increases value
B) Organic user interface C) Mashups D) Participation and ownership differences |
|
Why do companies use Business Process models?
|
its a graphic picture that is anazlyzed for flows, constraints, and opportunities
|
|
What are some characteristics of Fiber Optic cabling?
|
vertical cabling
high bandwidth (high bandwidth allows for lots of data to travel over cable at once) |
|
What are the criteria for selecting different networks?
|
1. Cost
2. Performance 3. Other |