Chapter 10
Databases & Information Management
Data and Information
- Data
Integrity
- Data
Security
Maintaining Data
- Adding
Records
- Changing
Records
- Deleting
Records
- Data
Validation
- Alpha/numeric Check
- Completeness Check
- Range Check
- Consistency Check
- Check Digit
File Processing vs. Database
- File
Processing Systems
- Data Redundancy
- Isolated Data
- The
Database Approach
- Reduced Data Redundancy
- Improved Data Integrity
- Shared Data
- Reduced Development Time
- Easier Reporting
Database Management Systems (DBMS)
- Data Dictionary
- Data Maintenance & Retrieval
- Data Security
- Backup & Recovery
Relational and Object-Oriented Databases
- Relational Databases
- Relational Algebra
- Structured Query Language
- Object-Oriented Databases
- Multimedia
- Groupware
- Hypertext
- Object Query Language
Database Administration
- Role of Data and Database Administrators
- Role of the User
- Database Design Guidelines
Qualities of Valuable Information
- Accurate
- Verifiable
- Timely
- Organized
- Meaningful
- Cost-Effective
- How Managers Use Information
o
Planning
o
Organizing
o
Leading
o
Controlling
·
Levels of Users
o
Executive Management
o
Middle Management
o
Operational Management
o
Non-management Employees
Types of Information Systems
·
Office Information Systems
·
Transaction Processing
Systems
·
Management Information
Systems
·
Decision Support Systems
·
Expert Systems
·
Integrated Information
Systems