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

Programming Terms

Application Programming
Systems Programming
Systems Analyst
Programmer
Algorithm
Procedures
Compiler
Interpreter
Source Code
Coding
Script Language
Compiled Language
Executable File
Low Level vs. High Level Languages

Object-Oriented Programming

Programming Languages

Assembly Language/Machine Language
C/C++/Java
Visual Basic

Old Programming Languages

o Cobol

Fortran

Data and Code

Multimedia

Digital
Digitizing
Data Compression

Graphics

Bitmap
Vector Graphics
Multimedia
Pixilated
3D modeling programs
Polygon
CG FX

Audio

Wav File
MIDI
MP3

Video

MPEG/AVI/MOV
WMV
Digital TV
High Definition TV
Frame/Frame rate
PDF

Games

AI and Graphics
Heavy processor drain
MMPOG

AI Concepts

Possible next revolution
Human Reasoning Simulation

Expert Systems
Machine Learning
Fuzzy Logic
Genetic Algorithms
Neural Networks
Intelligent Agents

Game AI

Stigma
Economic Performance
Entertainment Industry

Robotics

Vision Systems
Touch/Tactile
Dexterity
Locomotion
Navigation

Natural Interfaces

Speech Recognition
Natural Languages
Virtual Reality
Sensory Interfaces

Security

Security Risks

Network Security
Hacker/Cracker/Cracked software/Warez
Denial of Service
Information Theft
Industrial Espionage
Software Piracy
Cookie
Employee Monitoring
Spyware/VNC
Credit Card Fraud
Identity Theft
Data-Browsing
System Backdoors
Power Interruption

Computer Viruses

o Boot sector virus

o E-mail virus

o Trojan Horse

o Logic Bomb

o Software Worm

o Macro Virus

o Data Destructive Virus

o Hardware Destructive Virus

o Annoyance Virus

o Antivirus software

Precautions

Data Backup/Disaster Recovery
Data Encryption
Surge Protector/UPS
Firewall
User Name/Password or PIN
Constructing a good password
Smartcards
Software Certificates
Network Sniffers

Biometric Identifiers

Fingerprint Scanners
Iris recognition systems
Hand Geometry systems
Computerized Facial Recognition (CFR)
Thermography
Voice Verification systems
Signature Verification systems

Careers

Tech Salaries and Careers

Knowledge Workers

o Technical Work and Information Systems

Programmers/Problem Solvers
Change and Aging, Embracing Change
Switching Careers, Increasingly Common

Types Of Computer Jobs

Technical Operator/Data Entry
Technical Support
Technical Sales
Technical Training
Business Information Systems
Programming - Systems Development

Degree Programs

Computer Science
Computer Information Systems
Computer Engineering

Certificate Programs

Microsoft Certificates
Cisco Certificates
Novell Certificates

Where to Work

Ergonomics

o Carpal Tunnel

o Repetitive Motion Syndrome

Corporate culture
Big Bureaucratic
Family Kingdom
Personality-Driven

Problem-Solving Steps:

1. Identify the Problem

2. Understand the Problem

3. Identifying a List of Possible Solutions

4. Writing the Algorithm

5. Prototyping the Solution

6. Implementing and Testing the Solution

Algorithm for an Elevator:

Steps:

1. The first thing our elevator will handle is the pushing of buttons. When a button is pushed, the number of the requested floor will be immediately placed on a list of floors to visit. These floors will be visited in the order requested, unless another floor is requested along the way, in which case the elevator will stop to let people off.

2. Handling the doors is the next step. Ever noticed how elevators like to keep their doors closed? This step will attempt to close the doors, if they are open. Attempts will be made every 5 seconds and will close the doors unless something gets in the way.

3. If the doors are closed and the elevator car is on a floor that was requested, the doors will open. Ever notice that elevators will take you to a level, then wait a few seconds to open the doors? This is related to the way the computer program instructions are sequenced. There are three separate steps for the elevator: Getting the car to the floor requested, realizing it is there, and opening the door.

4. If the doors are closed and the request list is not empty then move the car one level towards the next floor on the request list. This is how the elevator moves the car up and down, one floor at a time. It then figures out what to do at that level in a later step.

5. That’s it! Go back to step one and repeat all of these.

Algorithm with Structure:

Steps:

1. If button is pushed then:

Add level number to request list

Goto step 1

2. If doors are open then:

Wait 5 seconds

Ring Bell

Attempt to Close doors

Goto step 1

3. If doors are closed and elevator car is on a level that has been requested then:

Ring Bell

Open doors

Goto step 1

4. If doors are closed and request list is not empty then:

Move elevator one level towards next level on request list

Goto step 1

5. Goto step 1