Chapter 12: Security & Privacy |
Database Administration |
Computer Viruses |
Types of Information Systems |
Know
all Types ( |
Info. Systems, Office Info.
Systems, Transaction |
Anti-Virus Programs |
Processing Systems, Management
Info. Systems, |
Virus
Definitions, Inoculate, Rescue Disk |
Decision Support Systems, Expert
Systems |
Hackers |
Chapter 14: Information Systems Development |
Access Control / Identification /
Authentication |
System Development Life Cycle |
User Name / Password (What is a good
password?) |
Planning,
Analysis, Design, Implementation, Support |
Possessed Objects |
Systems
Analyst, Steering Committee |
Biometric Devices / Identifiers |
Scope,
Project Plan, Gantt Chart |
Callback Systems
|
Feasibility
Assessment |
Hardware / Software Theft |
Documentation
(Project Notebook, Project Dictionary) |
Software Piracy,
License Agreements
|
Planning Phase |
Information Theft |
Steering
Committee’s Responsibilities |
Encryption (Private / Public Key) |
Analysis Phase |
System Failure (Blackout, Surge
Protector, UPS) |
Entity
Relationship Diagrams, Data Flow Diagrams |
Backup (Disaster
Recovery Plan) |
Structured
English |
Internet/Network Security |
Decision
Tables, Decision Trees, Data Dictionary |
Secure Site, Digital Certificates, SSL, SHTTP,
Firewall |
Build-or-Buy
Decision |
Information Privacy (Cookies, Spyware,
Spam)
|
Packaged
vs. Custom Software |
Chapter 13: Databases and Info. Management |
Design Phase |
Data & Information |
RFQ, RFP, RFI, Value-Added Reseller (VAR)
|
Data vs. Information, Data
Integrity |
Test & Evaluate Vendor Proposals
|
Database Hierarchy |
Input/Output
Design |
Levels |
Mockup
vs. Layout Chart |
Character |
CASE Tools |
Field |
Implementation Phase |
Record |
Program
Development Life Cycle |
File |
Different
Conversion Styles |
Database |
Support Phase |
Data Types (Know different
types) |
Chapter 16:
Computer Careers & Certifications
|
Maintaining Data |
4 Job
|
Adding,
Changing, Deleting Records |
Computer
Equipment Industry (Hardware) |
Data
Validation |
Computer
Software Industry |
Alphabetic/Numeric
Check |
IT
Professional Industry |
Completeness
Check |
Computer
Related Training & Education Industry |
Range
Check |
5 Main IT Job Groups |
Consistency
Check |
Management, Operations, System
Development, |
Check
Digit |
Technical
Services, End-User Computing |
File Processing vs. Database |
Education & Training, Sales,
Service & Repair, Consulting |
Advantages/Disadvantages |
Computer Degrees
(CIS, CS/Software Engineering, CE) |
Data
Redundancy |
Trade Schools |
Database Management Systems |
Professional Organizations (ACM) |
Data
Dictionary |
Continuing Education (COMDEX,
Computer Publications) |
Data
Maintenance & Retrieval |
Certification Areas |
Query
Language, QBE |
Database Systems, Programming,
Operating Systems, |
Forms/Reports |
Training
Security Sales, Networking, Internet, |
Data
Security |
Hardware,
Software Applications |
Backup
& Recovery (Rollback, Rollforward) |
Certification Benefits |
Five
Data Models |
Career,
Professional, Salary, Customers, |
Relational,
Object Oriented, Multidimensional |
Employers,
Industry |
Relational Databases |
Preparing for Certifications |
Table, Row, Column |
Self-Study,
Online Training Classes, Instructor-Led |
Relationships,
SQL |
Training,
Web Resources |
Object Oriented, Multidimensional,
& Web Databases |
Computer Certification Exams |