INF 402: Fundamentals of Management Information Systems and Data Processing

Introduction to Management Information Systems (MIS)

• Conceptual Meaning of MIS: Management Information System, commonly referred to as MIS, is a phrase consisting of three fundamental words: Management, Information, and Systems. At its most basic level, MIS refers to systems that provide information to management.

• Definition of Management: The process of planning, organizing, staffing, coordinating, and controlling the efforts of members within an organization to achieve stated common goals. A manager utilizes human skills, material resources, and scientific methods to perform activities that lead to goal achievement.

• Definition of Information: Information is the output element of a data processing system. It is derived from data that has been subjected to processing operations to convert meaningless raw facts into a useful form for recipients. In the MIS context, information is processed data used to support management functions, day-to-day business operations, and decision-making processes.

• Definition of Data: Unprocessed raw facts consisting of details regarding business transactions. Data serves as the input to a data processing system.

Data Hierarchy and Types of Business Data

• Data Hierarchy: This refers to the systematic organization of data. It helps illustrate relationships between smaller and larger components in a database or data file and is essential for arranging data without redundancy.

  • Bit: A unit of measurement to quantify computer data with a single value of $0$ or $1$.

  • Byte: A unit of digital information where $1\,\text{byte} = 8\,\text{bits}$, representing a single character.

  • Field: Holds a single fact or attribute of an entity (e.g., a student's name or a birthdate). A date field like "$19\,\text{September}\,2004$" can be one field or three sub-fields: day, month, and year.

  • Record: A collection of related fields (e.g., an employee record containing name, address, and birthdate).

  • File: A collection of related records. For example, if there are $100$ employees, the collection of their records forms an "Employee Personal Details file."

  • Database: An integrated collection of files, often managed through a Database Management System (DBMS).

• Categories of Business Data:

  1. External Environment Data: Relates to social, political, and economic factors.

  2. Competitive Data: Highlights past performance, present activities, and future plans of main competitors.

  3. Qualitative and Quantitative Data: Covers quality control, performance levels, costs, overheads, profits/losses, cash flows, and credit lines.

  4. Organizational Data: Relates to manpower levels and departmental structures.

  5. Reference Data: Includes stock control parameters.

• Specific Domain Examples:

  • GPA: Student Registration Number, Name, Course Code, Course Title, Credit Unit.

  • Payroll: Employee Number, Name, Department, Tax Code, Hours Worked, Hourly Rate.

  • Credit Card: Cardholder Number, Name, Address, Credit Limit, Minimum Payment, Purchase Details, Interest Rate.

  • Car Hire: Type of Car, Model, Colour, Number of Seats, Engine Capacity, Registration Number.

Data Processing Methods

• Manual Data Processing: Handled entirely without electronic devices or software. Involves human intervention for collection, filtering, and calculation. While low-cost in terms of tools, it is high in error rates, labor costs, and time required.

• Mechanical Data Processing: Utilizes mechanical devices such as calculators, typewriters, and printing presses. It offers fewer errors than manual processing but has become too complex for modern data volumes.

• Electronic Data Processing (EDP): Uses modern technologies and software. It is the most expensive method but offers the fastest speeds, highest reliability, and accuracy.

• Electronic Processing Strategies:

  • Batch Processing: Data is accumulated in a group (batch) over a defined period (daily, weekly, monthly) and processed all at once. Examples include payroll systems and document printing. Master files are only as current as the last update run. Users have no direct interaction during processing.

  • Online Processing: Data is processed immediately upon receipt. The input unit (e.g., terminal) is directly connected to the computer via a communication link. Examples include banking account status inquiries, Sales Order Processing, and Insurance policy maintenance.

  • Real-time Processing: A subset of online processing where the computer processes data and updates files as events occur, providing an immediate response to influence the event. Examples include airline ticket reservations, hotel bookings, and space exploration.

  • Time-sharing: Multiple terminals are connected to a central CPU. Each user is allocated a "time slice" in a round-robin sequence, making it appear that all are using the system simultaneously.

Attributes and Categories of Information

• Key Attributes (Properties) of Information:

  1. Enables effective decision-making.

  2. Suitable for control action.

  3. Compatible with the specific manager's responsibilities.

  4. Relates to the current situation.

  5. Contains an appropriate level of detail.

  6. Focuses on exceptions (Management by Exception).

  7. Cost-effective (optimum cost).

  8. Easily understandable.

  9. Relevant and non-redundant.

  10. Provided at a suitable frequency.

  11. Accurate for its purpose.

• Levels of Information:

  • Strategic Information: Long-term planning policies for top management. Examples: Market penetration, projected raw material costs, cash flow trends ($years$).

  • Tactical Information: Short-term planning ($months$) for department heads. Examples: Sales analysis, cash flow projections, annual financial statements, manpower levels.

  • Operational Information: Immediate, day-to-day, or hourly running of a department. High specificity. Examples: Current stock-in-hand, weekly work hours, raw materials available ($daily$).

Systems Classification and Structure

• Definition of a System: An orderly grouping of interdependent components linked to achieve a specific objective.

• System Classifications:

  • Physical Systems: Tangible entities. Static components include desks and chairs; dynamic components include a programmed computer with changing data/applications.

  • Abstract Systems: Conceptual entities, models, or formulas (e.g., a mathematical representation of a physical situation).

  • Open Systems: Interface with the environment, receive inputs, and deliver outputs. MIS is usually an open system as it must adapt to user demands.

  • Closed Systems: Isolated from environmental influences. Rarely exist in reality.

• Accounting Information System (AIS): A computer-based method for tracking financial activity. Subsystems include:

  1. Transaction Processing System (TPS).

  2. General Ledger System / Financial Reporting System (GLS/FRS).

  3. Management Reporting System (MRS).     

Organizational Pyramid and Information Systems

• Transaction Processing Systems (TPS): Serves the operational level. Records daily routine transactions like sales entries and payroll. Failures in TPS (e.g., UPS tracking or Airline reservations) can lead to firm failure.

• Management Information Systems (MIS): Serves the management level. Provides reports on current performance and historical records, typically focusing on internal data rather than external environment. MIS summarizes TPS data into regular reports (weekly, monthly, yearly).

• Decision Support Systems (DSS): Serves top-level managers for semi-structured decisions. Uses MIS output and external data (market forces, competition). Features high analytical power and interactive, user-friendly software.

• Consolidated Consumer Products Corporation Case Study (MIS Report $2005$):

  • Product 4469 (Carpet Cleaner): Actual sales totals for Northeast ($4,066,700$), South ($3,778,112$), Midwest ($4,867,001$), and West ($4,003,440$). Total actual: $16,715,253$ vs. Planned: $17,550,000$.

  • Product 5674 (Room Freshener): Total actual sales: $18,559,253$ vs. Planned: $17,700,000$.

Design, Goals, and Implementation of MIS

• Five Components of MIS: People (users like HR managers), Business Processes (best practices), Data (documented transactions), Hardware (computers, printers), and Software (operating systems and applications).

• Goals to Achieve: Enhance communication, deliver complex material, provide an objective recording system, reduce labor-intensive costs, and support strategic direction.

• Core Design Principles:

  • Scalability: Handling growth without performance drops.

  • Reliability/Availability: Redundancy and disaster recovery.

  • Security: Access controls and encryption.

  • Interoperability: System-to-system communication.

  • Performance: Database optimization.

  • Compliance: Legal and regulatory standards.

• Steps in Designing MIS:

  1. Planning: Gaps identification, budget, and timeline.

  2. Analysis: Functional specifications and communication protocols.

  3. Design: Code development, database building, and extensive testing.

  4. Implementation: Formal testing, data migration, and training move the system to "live" status.

  5. Maintenance: Monitoring for bugs and ensuring the system does not become obsolete.

Evolution of Computers

1. First Generation ($1940\text{s} - 1950\text{s}$): Vacuum tube based.

2. Second Generation ($1950\text{s} - 1960\text{s}$): Transistor based.

3. Third Generation ($1960\text{s} - 1970\text{s}$): Integrated circuit based.

4. Fourth Generation ($1970\text{s} - \text{present}$): Microprocessor based.

5. Fifth Generation (Present and Future): Artificial Intelligence based.

Data Processing Cycle

1. Data Collection: Gathering raw data from sensors, surveys, or databases.

2. Data Preparation: Cleaning data by removing redundant or bad data.

3. Data Input: Feeding prepped data into software via manual entry or automatic capture.

4. Data Processing: Transformation using filtering, sorting, or classification.

5. Data Output and Interpretation: Presenting information as reports or graphs.

6. Data Storage: Storing information in databases or warehouses for future use.

Sub-Optimization Issues and Solutions

• The Issue: Occurs when departments optimize their own performance at the expense of the overall organization.

  • Examples: Data silos, conflicting departmental objectives, competition for limited resources, redundant processes, and inconsistent reporting metrics.

• The Solutions:

  1. Centralized Data Management: Integrated database/warehouse.

  2. Unified Objectives: Shared Key Performance Indicators (KPIs).

  3. Collaborative Resource Planning: Cross-departmental systems.

  4. Process Standardization: Shared services for common functions.

  5. Integrated Reporting Systems: Enterprise-wide unified frameworks.

System Software and Applications

• Categories of System Software:

  • Operating Systems: Windows Server, Linux.

  • DBMS: Oracle, MySQL, SQL Server.

  • Middleware: IBM WebSphere.

  • Security Software: McAfee, Symantec.

  • Virtualization: VMware vSphere, Hyper-V.

• Multi-programming (Multitasking): Allows multiple programs to run concurrently on a single CPU. Impacts include improved resource utilization, higher throughput, and increased system responsiveness.

• Business Problem Solving via DBMS:

  • Data Redundancy: Centralized storage prevents duplicates.

  • Data Security: Implements Role-Based Access Control (RBAC).

  • Data Integrity: Enforces constraints like primary and foreign keys.

  • Backup and Recovery: Automated daily backups (e.g., in SQL Server).