Management Information Systems Study Guide PDF

Management Information Systems Study Guide Management Information Systems Study Guide 1. Databases - Purpose of Databases: - Minimize data redundancy. - Organize and manage data systematically. - Replace outdated file systems for efficient processing and storage. - Forms of Data: - Struc...

Management Information Systems Study Guide Management Information Systems Study Guide 1. Databases - Purpose of Databases: - Minimize data redundancy. - Organize and manage data systematically. - Replace outdated file systems for efficient processing and storage. - Forms of Data: - Structured: Predefined format (e.g., relational tables). - Unstructured: Raw data, no set structure (e.g., emails, videos). - Semi-structured: Partially organized data (e.g., JSON, XML). - Data Redundancy Reduction: - Centralized repository. - Use of keys to ensure data integrity: - Primary Key: Unique identifier (e.g., Employee ID). - Foreign Key: Connects tables. - Composite Key: Combines multiple columns for uniqueness. 2. Types of Databases - Centralized Database: Data stored in one location, ensuring consistency. - Distributed Database: Data spread across multiple sites for accessibility. - Single-user vs. Multi-user: Page 1  Management Information Systems Study Guide - Microsoft Access: Single-user (requires manual save). - Oracle: Multi-user, real-time updates visible to all. 3. Database Management Roles - Designer: Conceptualizes tables, keys, and relationships. - Developer: Implements database designs. - Administrator: Oversees performance, backups, and security. - Analyst: Uses data for decision-making and reporting. 4. Data Anomalies - Insertion: Errors when adding new records. - Update: Issues when modifying data. - Deletion: Problems removing records, potentially corrupting data. 5. Business Intelligence & Analytics - RFM Analysis: - Recency, Frequency, Monetary. - Identifies high-value customers for marketing efforts. - Market Basket Analysis: - Reveals item-purchasing associations. - Example: Amazon's "Frequently Bought Together." - Decision Trees: - Predict outcomes using a branching model. - OLAP (Online Analytical Processing): - Summarizes data using techniques like slicing, dicing, and drilling. Page 2  Management Information Systems Study Guide - Example: Pivot tables in Excel. 6. Software and Programming - In-house Software: Customized but costly. - Off-the-shelf Software: Generalized and vendor-dependent. - Python Programming: - High-level, object-oriented, interpreted language. - Advantages: Simplicity, flexibility, and real-time debugging. - Key Concept: Uses an interpreter (not a compiler). 7. Social Media Information Systems - Social Capital Formula: Relationships × Strength × Controlled Resources. - Software as a Service (SaaS): - Examples: Google Drive, ChatGPT. - Provides web-based software services. 8. Web Evolution - 1960s - Arpanet: - Developed for military communication; precursor to the Internet. - 1990 - Web 1.0: - Static pages with basic text and images. - Example: Early informational websites. - 2000 - Web 2.0: - Dynamic, user-generated content (e.g., Facebook, YouTube). - Enhanced interactivity and personalization. Page 3  Management Information Systems Study Guide - Present - Web 3.0: - Integration of AI, blockchain, and advanced technologies. - Examples: Decentralized apps, personalized user experiences. 9. Additional Topics - Data Mining: - Techniques: Supervised (decision trees), unsupervised (clustering). - Insights: Extracting relationships and patterns. - Excel for OLAP: - Slicers, pivot tables, and trend analysis. - Control Flow in Programming: - Logical operators: AND, OR, XOR. - Conditional statements: if, else, nested if. This guide provides a comprehensive overview of the key topics discussed. Good luck with your studies! Page 4