CS 202 – Test 2 Terms:

E-Commerce Terms:

• B2B
• B2C
• Interdependence
• What “Dot-Com” means
• Napster
• File-Sharing
• Peer-to-Peer
• Impact on business

Database Concepts:

• DBMS
• SQL – Structured Query Language
• Data Dictionary
• Data vs. Information

• Database Objects:
• Table/File
• Record
• Field
• Database Primary Key/Unique Key
• Query
• Form
• Report
• Error concepts

• Data Validation

• Garbage in/ Garbage Out
• Database Administrator

Database Management (approach and system)

• Big Database Vendors
• Data Dictionary
• Data modeling
• Data mining
• Database Administrator
• Database Access: Direct (Random) or Sequential
• Relational/Object-Oriented Database Structures
• DBMS uses
• Application Development
• Database Development
• Database Interrogation
• Database Maintenance
• Database Objects:
• Database Primary Key/Unique Key
• Query
• Form
• Report
• Macro
• SQL (Query Language)
• Report Generation
• Types of Databases
• Data Warehouse
• Distributed
• External
• Hypermedia
• Operational

Information Systems

• IS (Information Systems)
• IT (Information Technology)
• Open vs. Closed system Architecture
• Competitive Advantage (using IT)
• Cost Strategies
• Differentiation Strategies
• Innovation Strategies
• Computer-Based Information System
• Data or Information Processing
• Data Resources
• Electronic Commerce (E-Commerce)
• End User
• Globalization
• Hardware Resources
• Data vs. Information
• Information Products
• Information Quality
• Information System Model
• Roles of IS in an organization
• Computer Systems/Computer Peripherals
• User Interface
• System Software/Application Software/Procedures
• The Ease of Overselling Technology (not in the book)

• CAD (computer aided design)
• CAM (computer aided manufacturing)
• CIM (computer integrated manufacturing)
• CASE (computer assisted software engineering)
• SQC/SPC (Statistical quality control)/(Statistical Process Control)
• Changes in staffing due to IS adoption
• Clerical reduced
• Technical increased
• Reasons for new IS

o to improve product quality

o to reduce personnel

o to improve productivity

• Specialized Information Systems
• Executive support type of IS

o niche information system

o turnkey system

o closed system

Software Development:

• Cyclical Nature of Software Development
• Development terms:
• Beta testing
• QA (Quality Assurance)
• Systems House
• RFP (Request for Proposal)
• System Development Life Cycle (SDLC)
• Planning
• Design
• Implementation
• Support

• Planning
• RFP
• Analysis
• Prototype
• Design
• Specifications:
• Functional Spec
• Design Spec (sometimes called Requirements spec)
• Implementation:
• Development
• Initial (alpha) Testing
• Support:
• Beta Testing
• User Training
• Maintenance and Support
• “Cycle” means it repeats thru life of system