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 |