Show:
DBMS
Potpourri 1
SDLC
Potpourri 2
Business Intiatives
100
The primary key of one table that exists as a column in a related table
What is a Foreign Key
100
Compression by replacing strings of repeating characters with symbols representing the character and the number of repeats
What is Run Length Encoding
100
SDLC
What is Systems Development Life Cycle
100
A scale model or mock up of a software system used to demonstrate its potential
What is a prototype
100
CRM
What Customer Relationship Management
200
The two main types of databases
What are Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP)
200
Involves choosing IT specialists within your organization to develop the system
What is Insourcing
200
Step one of the SDLC
What is Planning
200
A compression method by which the post_compressed version of the file is identical to the pre-compressed version
What is lossless compression (critical for data files, executables, etc)
200
An example of a Software as a Service CRM product
What is Salesforce.com
300
A rule that helps ensure the quality of information in a database
What is an integrity constraint
300
The delegation of specific work to a third party for a specified length of time, at a specified cost, and at a specified level of service
What is Outsourcing
300
Step two of the SDLC
What is Analysis
300
Backup and security are part of what database sub-system
What is Maintenance
300
Knowledge about competitors, suppliers, your own internal operations, etc
What is Business intelligence
400
A standardized fourth-generation language found in most DBMSs used to manage data in a database
What is Structured Query Language (SQL)
400
Four advantages of outsource
What are: Focus on unique core competencies Exploit the intellect of another organization Better predict future costs Acquire leading-edge technology Reduce costs Improve performance accountability
400
Step 3 of the SDLC
What is Design
400
Five common business initiatives that need IT
What are: Customer relationship management (CRM) Supply chain management (SCM) Business intelligence (BI) Integrated collaboration environments (ICE)
400
Uses information about customers to gain insight in order to serve them better
What is CRM (Customer Relationship Management) system
500
The five components of a database management system DBMS
What are 1) DBMS engine 2) Data definition subsystem 3) Data manipulation subsystem 4) Application generation subsystem 5) Data administration subsystem
500
Four Disadvantages to outsourcing
What are: Reduces technical know-how for future innovation Reduces degree of control Increases vulnerability of your strategic information Increases dependency on other organizations
500
Steps 4 thru 7 of the SDLC
What is Development, Testing, Implementation and Maintenance
500
Using a contractual service to completely manage, deliver and operate one or more (typically IT or call center-intensive) business processes or functions
What is Business Process Outsourcing
500
Porter's Five business forces
What are: Buyer power Supplier power Threat of substitute products and services Threat of new entrants Rivalry among existing competitors