This page contains detailed solutions of MBA (MIS) – Management Information System Previous Year Question Paper 2022. All answers are written in simple and exam-oriented format suitable for 2 to 10 marks university questions.
University: Dr. A.P.J. Abdul Kalam Technical University (AKTU)
Course: MBA – Management Information System
Year: 2022
Management Information System (MIS) plays an important role in bringing internal changes within an organization. MIS collects, processes, and provides relevant information to managers for planning, controlling, and decision-making. Through MIS, management can easily analyze the performance of different departments and identify areas where improvement is required. It helps in restructuring organizational processes, improving communication among departments, and introducing new technologies. MIS also supports automation of routine tasks, which increases efficiency and reduces manual errors. For example, if a company introduces an MIS-based employee management system, it can track attendance, performance, and payroll automatically, which helps management make internal administrative improvements.
IT capabilities refer to the ability of an organization to effectively use information technology resources such as hardware, software, databases, and networks to achieve business objectives. These capabilities enable an organization to collect, process, store, and distribute information efficiently. Strong IT capabilities help organizations improve productivity, support innovation, and gain competitive advantage. They include technical skills of employees, efficient IT infrastructure, system integration, and the ability to develop and manage information systems. For example, companies like Amazon use strong IT capabilities such as advanced databases, cloud computing, and analytics systems to manage large amounts of customer data and provide efficient online services.
An Information System (IS) is a set of interrelated components that collect, process, store, and distribute information to support decision-making, coordination, and control within an organization. It consists of hardware, software, data, procedures, and people working together to produce useful information. Information systems help organizations manage their operations, analyze problems, and create new products or services. For example, a banking information system stores customer data, processes transactions, and generates reports for management. Thus, an information system converts raw data into meaningful information that helps organizations function efficiently.
A decision is the process of selecting the best possible course of action from several available alternatives in order to achieve a specific objective. Decision-making is one of the most important responsibilities of managers in any organization. It involves identifying a problem, analyzing available information, evaluating different alternatives, and choosing the most appropriate solution. Decisions can be classified into programmed decisions (routine and repetitive) and non-programmed decisions (complex and unique). For example, deciding the daily work schedule of employees is a programmed decision, while launching a new product in the market is a non-programmed decision.
Information is a vital resource for every organization because it supports planning, decision-making, and control of business activities. Managers rely on accurate and timely information to understand business conditions and take appropriate actions. Information helps organizations identify market opportunities, analyze customer needs, and monitor performance. Without proper information, managers cannot make effective decisions or respond to changes in the business environment. Information also improves coordination among departments and enhances communication within the organization. For example, sales reports help management understand product performance and plan future marketing strategies. Therefore, information is essential for efficient management and organizational success.
Management Support Systems (MSS) are computer-based systems that assist managers in decision-making, planning, and problem-solving. These systems provide relevant information, analytical tools, and models that help managers evaluate different alternatives and choose the best option. Management Support Systems include Decision Support Systems (DSS), Executive Information Systems (EIS), and Expert Systems. They are mainly used for semi-structured and unstructured decisions where human judgment is required. For example, a DSS can help a manager analyze sales data and predict future demand using statistical models. Thus, MSS improves the quality and speed of managerial decision-making.
Data independence refers to the ability to modify the database structure without affecting the application programs that access the data. It is an important concept in database management systems. Logical data independence means the ability to change the logical structure of the database without affecting the external schema or application programs. For example, adding a new attribute to a table should not require changes in existing applications. Physical data independence means the ability to change the physical storage structure of the database without affecting the logical structure. For example, changing the storage location of data files or indexing methods should not affect how users access the data. Logical data independence is generally more difficult to achieve than physical data independence.
Data mining refers to the process of extracting useful patterns, trends, and knowledge from large volumes of data using statistical and computational techniques. The main aim of data mining is to transform raw data into meaningful information that can support decision-making. Data mining helps organizations identify hidden relationships, predict future trends, and improve business strategies. It is widely used in marketing, banking, healthcare, and e-commerce. For example, companies use data mining to analyze customer purchasing behavior and recommend products accordingly. The main objectives include prediction, classification, clustering, association analysis, and trend analysis.
A CHECK constraint in SQL is used to ensure that the values entered into a column satisfy a specific condition. It helps maintain data integrity and accuracy in a database. The CHECK constraint restricts the type of values that can be inserted into a table. For example, if a column stores employee age, a CHECK constraint can ensure that the age must be greater than 18. If a user attempts to insert a value that does not meet the specified condition, the database system rejects the entry. Thus, CHECK constraints prevent invalid data from being stored in the database.
Business Intelligence (BI) refers to the technologies, applications, and processes used to collect, analyze, and present business data to support decision-making. BI systems convert raw data into meaningful insights through reports, dashboards, and data visualization tools. It helps organizations monitor performance, identify trends, and make strategic decisions. Business Intelligence includes tools such as data warehouses, data mining, online analytical processing (OLAP), and reporting systems. For example, a company may use BI dashboards to analyze sales performance across different regions and plan marketing strategies accordingly. Thus, BI enables organizations to make data-driven decisions and improve overall efficiency.
Information plays a crucial role in delivering better customer service because it enables organizations to respond quickly, accurately, and efficiently to customer needs. In the case of Anjali Restaurant, the use of an information system allows waiters to enter customer orders directly into computer terminals placed in the dining room. This information is instantly sent to the appropriate kitchen printers, depending on the type of order such as salads, drinks, or sandwiches.
This system reduces delays and eliminates the traditional handwritten order method, which often caused mistakes due to poor handwriting or communication gaps between waiters and kitchen staff. By using computerized ordering, the restaurant ensures that orders are accurate and processed faster, resulting in improved service quality and customer satisfaction.
The information system also automatically generates the customer’s meal checklist and bill, saving time for both the customer and restaurant staff. In addition, when certain food items are out of stock, the kitchen staff updates the system immediately. This information is displayed on dining room terminals so waiters can inform customers quickly and suggest alternative options.
Therefore, timely and accurate information helps the restaurant improve communication, reduce errors, speed up service, and ultimately provide a better dining experience to customers.
The information system implemented in Anjali Restaurant has significantly contributed to attracting and serving more customers by improving operational efficiency and service quality. One of the major benefits is faster order processing. Waiters enter orders directly into the system, and the orders are immediately sent to kitchen printers. This reduces waiting time for customers and allows the restaurant to serve more people within a shorter time.
The system also eliminates errors that were common in the earlier manual three-carbon copy guest check system. Since the process is computerized, the chances of mistakes in order recording or billing are minimized. Accurate billing and quick service increase customer satisfaction, encouraging customers to visit the restaurant again.
Another advantage is the system’s ability to track the number of items sold and calculate the total sales achieved in a day. This helps management identify which food items are most popular among customers. Based on this information, the restaurant can modify its menu to include items that customers prefer the most.
Furthermore, the system records reasons whenever an order is cancelled. This information helps management analyze customer behavior and identify problems related to food quality or service. By solving these issues, the restaurant can improve customer satisfaction and attract more customers.
Thus, the use of an information system has helped Anjali Restaurant improve service speed, reduce errors, understand customer preferences, and enhance overall customer experience, leading to an increase in the number of customers.
In the context of the given case study, the information system provides several important benefits to Anjali Restaurant. First, it improves operational efficiency by automating the order-taking and billing processes. This reduces manual work, saves time, and allows employees to focus more on customer service.
Second, the system provides real-time information about food availability. When certain items are out of stock, the kitchen staff updates the system and this information appears on the dining room terminals. This helps waiters inform customers immediately and avoid ordering unavailable items.
Third, the system generates valuable business information such as daily sales reports, item-wise sales data, and weekly comparisons of sales and food costs. This information helps management analyze business performance and make better decisions regarding pricing, menu planning, and cost control.
Another important benefit is that the system records reasons for order cancellations. By analyzing these reasons, management can identify service issues or unpopular menu items and take corrective actions to improve quality.
Overall, the information system helps Anjali Restaurant improve efficiency, support better management decisions, reduce operational errors, and enhance customer satisfaction, which ultimately leads to business growth and success.
A Transaction Processing System (TPS) is a type of information system used by organizations to record, process, and manage routine daily transactions. These transactions include activities such as sales, purchases, payments, payroll processing, inventory updates, and customer orders. TPS is mainly used at the operational level of management where a large volume of routine transactions must be handled efficiently and accurately. The main objective of TPS is to ensure that business transactions are processed quickly, stored properly, and available for future reference.
TPS is very important for organizations because it ensures accuracy, reliability, and efficiency in handling large amounts of data generated from daily operations. It provides the basic data that is later used by other systems such as Management Information Systems (MIS), Decision Support Systems (DSS), and Executive Information Systems (EIS).
TPS is used in different functional areas of an organization to process routine transactions. The major functional areas where TPS is commonly used include the following:
1. Sales and Marketing: In the sales and marketing department, TPS is used to process customer orders, maintain sales records, generate invoices, and track customer payments. It helps businesses manage order processing and customer transactions efficiently.
2. Finance and Accounting: In the finance department, TPS handles financial transactions such as recording payments, managing accounts receivable and accounts payable, processing invoices, and generating financial reports. It ensures accurate financial record keeping.
3. Human Resource Management: TPS is used in HR departments for payroll processing, employee attendance tracking, employee records management, and benefit administration. This helps organizations manage employee-related transactions efficiently.
4. Inventory and Production Management: TPS tracks inventory levels, records purchase transactions, updates stock availability, and monitors production activities. It helps organizations avoid stock shortages and manage supply chains effectively.
5. Customer Service: TPS helps in recording customer inquiries, complaints, and service requests. This helps companies provide better customer support and maintain service records.
TPS provides several important services to organizations which help them manage daily operations smoothly. Some of the main services include:
1. Data Collection: TPS collects transaction data from different sources such as sales terminals, online systems, and customer orders.
2. Data Processing: The collected transaction data is processed and converted into useful information for business operations.
3. Data Storage: TPS stores transaction records in databases for future reference and reporting purposes.
4. Data Retrieval: Stored data can be retrieved whenever required for generating reports or checking transaction details.
5. Transaction Accuracy: TPS ensures that transactions are processed accurately and consistently without errors.
6. Report Generation: TPS generates routine reports such as daily sales reports, inventory reports, and payroll summaries.
Thus, Transaction Processing Systems play a vital role in managing daily business activities and providing reliable data for managerial decision-making.
Cloud computing is a technology that allows users to access computing resources such as servers, storage, databases, software applications, and networking over the internet instead of using local computers or physical servers. In cloud computing, data and applications are stored on remote servers maintained by service providers and can be accessed anytime from anywhere using the internet.
Cloud computing offers several advantages such as cost reduction, scalability, flexibility, high availability, and easy access to data and applications. Businesses use cloud computing to store large amounts of data, run applications, and manage IT infrastructure without investing heavily in hardware.
Cloud computing services are mainly categorized into three major service models: SaaS, PaaS, and IaaS. Each model provides a different level of service to users.
1. Software as a Service (SaaS): Software as a Service is a cloud computing model where software applications are delivered over the internet. Users do not need to install or maintain the software on their computers because the service provider manages everything including servers, databases, and application updates.
Users simply access the software through a web browser. SaaS is widely used in business applications such as email services, customer relationship management systems, and office productivity tools. Examples include Google Workspace, Microsoft 365, and Salesforce.
2. Platform as a Service (PaaS): Platform as a Service provides a development platform that allows developers to build, test, and deploy applications without worrying about underlying infrastructure such as servers and operating systems.
The cloud provider manages hardware, networking, storage, and runtime environment while developers focus only on writing application code. PaaS is commonly used by software developers for building web and mobile applications.
Examples of PaaS platforms include Google App Engine, Microsoft Azure App Services, and Heroku.
3. Infrastructure as a Service (IaaS): Infrastructure as a Service provides virtualized computing resources such as servers, storage, and networking over the internet. In this model, users can rent IT infrastructure instead of purchasing physical hardware.
Organizations have full control over operating systems, applications, and storage while the cloud provider manages the underlying physical infrastructure. IaaS is useful for businesses that require flexible and scalable infrastructure.
Examples of IaaS include Amazon Web Services (AWS), Microsoft Azure Virtual Machines, and Google Compute Engine.
In conclusion, cloud computing provides flexible and scalable computing resources, and the service models SaaS, PaaS, and IaaS allow organizations to choose the level of control and service they require.
1. Better Decision Making: MIS provides accurate and timely information to managers which helps them make effective and informed decisions.
2. Improved Efficiency: MIS automates many routine tasks and reduces manual work, which increases the overall efficiency of business operations.
3. Better Communication: MIS improves communication within an organization by providing a common platform for sharing information among different departments.
4. Effective Planning and Control: MIS helps managers plan business activities and monitor performance through regular reports and analysis.
5. Improved Data Management: MIS helps store and manage large volumes of organizational data in a systematic and organized manner.
6. Competitive Advantage: Organizations can use MIS to analyze market trends and customer preferences, which helps them stay ahead of competitors.
1. High Cost: Developing and maintaining an MIS can be expensive because it requires hardware, software, and skilled personnel.
2. Dependence on Technology: Organizations become highly dependent on technology, and system failures may disrupt operations.
3. Security Risks: MIS systems store sensitive organizational data, which may be vulnerable to cyber attacks or unauthorized access.
4. Need for Skilled Staff: Operating and managing MIS requires trained professionals, which may increase operational costs.
5. Data Quality Issues: If incorrect data is entered into the system, the resulting information may also be inaccurate and lead to wrong decisions.
Thus, while MIS offers many benefits for organizational management, it also has certain limitations that must be managed properly.
Decision-making systems are computer-based systems that support managers in analyzing information and making effective decisions. These systems help managers evaluate different alternatives and choose the best possible solution for organizational problems.
1. Transaction Processing System (TPS): TPS supports routine operational decisions by processing daily business transactions such as sales, payments, and inventory updates.
2. Management Information System (MIS): MIS provides summarized reports and structured information to middle-level managers for planning, control, and monitoring of business activities.
3. Decision Support System (DSS): DSS helps managers analyze complex problems using analytical models, data analysis tools, and simulations.
4. Executive Information System (EIS): EIS provides strategic information to top-level executives through dashboards and summary reports for strategic decision-making.
1. Programmed Decisions: These are routine and repetitive decisions that follow established rules or procedures. For example, reordering inventory when stock reaches a certain level.
2. Non-Programmed Decisions: These decisions are complex and unique, requiring managerial judgment and creativity. For example, entering a new market or launching a new product.
1. Structured Decisions: Structured decisions are routine and can be solved using standard procedures or rules.
2. Semi-Structured Decisions: These decisions involve both structured processes and human judgment. Managers may use analytical tools but still rely on experience.
3. Unstructured Decisions: These decisions are complex, novel, and require creativity and managerial insight. They are usually taken by top-level management for strategic issues.
Thus, decision-making systems help managers at different organizational levels make effective decisions by providing relevant information and analytical tools.
Herbert A. Simon, a Nobel Prize-winning economist, developed a systematic model of decision-making to explain how managers make decisions in organizations. According to Simon, decision-making is a process that involves identifying a problem, analyzing possible alternatives, and selecting the best solution. His model emphasizes the concept of bounded rationality, which means that managers make decisions based on limited information, limited time, and limited cognitive ability.
Herbert Simon divided the decision-making process into four main phases: Intelligence, Design, Choice, and Implementation.
In this phase, the problem or opportunity is identified. Managers collect relevant data and analyze the environment to understand the situation. The purpose of this stage is to recognize that a problem exists and determine its causes.
For example, if a company notices that sales are decreasing, managers collect sales data, customer feedback, and market trends to identify the reason behind the decline.
In the design phase, possible solutions to the problem are developed and analyzed. Managers create different alternatives and evaluate them based on their feasibility, cost, and effectiveness.
For instance, if sales are declining, management may consider alternatives such as introducing new products, reducing prices, or increasing marketing efforts.
In this phase, managers select the best alternative from the available options. The decision-maker evaluates each alternative carefully and chooses the one that best solves the problem or achieves the desired objective.
For example, management may decide to launch a new advertising campaign to increase sales.
The final phase involves putting the chosen solution into action. The organization implements the decision and monitors the results to ensure that the problem is resolved effectively.
For example, once the decision to start a marketing campaign is made, the company implements advertising strategies and evaluates their impact on sales.
Thus, Herbert Simon’s model provides a structured approach to decision-making that helps managers analyze problems systematically and make effective decisions.
GDSS stands for Group Decision Support System. It is a computer-based information system designed to support a group of people in making decisions collaboratively. GDSS provides tools and technologies that help group members share ideas, analyze alternatives, and reach a consensus efficiently.
Group decision-making is often complex because it involves multiple participants with different opinions and perspectives. GDSS helps improve communication, coordination, and participation among group members by using technology such as computer networks, collaboration software, and decision analysis tools.
GDSS allows participants to contribute ideas simultaneously, conduct electronic brainstorming, vote on alternatives, and analyze results in real time. It also helps reduce the influence of dominant individuals and encourages equal participation among members.
1. Decision Room GDSS:
In this type, group members meet in a specially equipped room that contains
networked computers and decision-support software. Each participant uses a
computer terminal to share ideas, evaluate alternatives, and vote on decisions.
2. Teleconferencing GDSS:
This type allows group members to participate in decision-making from different
locations using communication technologies such as video conferencing,
online meeting platforms, and collaboration software.
3. Electronic Brainstorming GDSS:
This system enables participants to generate and share ideas electronically.
Ideas are collected, organized, and evaluated using specialized software tools.
4. Web-Based GDSS:
Modern GDSS systems are often web-based and allow participants to collaborate
through internet platforms. These systems support real-time discussions,
polling, document sharing, and decision analysis.
Overall, GDSS improves the quality of group decisions by enhancing collaboration, communication, and analytical capabilities.
In a database management system (DBMS), various operations are used to modify the contents of a database. These operations allow users to add new data, update existing data, or remove unwanted data. The most common operations used to modify database contents are Insert, Update, and Delete.
The INSERT operation is used to add new records into a database table. It allows users to store new information in the database.
Example:
INSERT INTO Students (ID, Name, Age) VALUES (101, 'Rahul', 21);
This command inserts a new student record into the Students table.
The UPDATE operation is used to modify existing records in a database table. It allows users to change specific values stored in the database.
UPDATE Students SET Age = 22 WHERE ID = 101;
This command updates the age of the student with ID 101.
The DELETE operation is used to remove records from a database table. It helps eliminate unnecessary or outdated data.
DELETE FROM Students WHERE ID = 101;
This command deletes the record of the student whose ID is 101.
The ALTER operation is used to modify the structure of a database table. For example, adding or removing columns from a table.
ALTER TABLE Students ADD Email VARCHAR(50);
This command adds a new column named Email to the Students table.
These operations help maintain the accuracy and relevance of data stored in a database.
Business Intelligence (BI) involves various stakeholders who participate in collecting, analyzing, and using business data for decision-making. The main key players include:
1. Data Analysts:
They analyze business data and generate insights using statistical
tools and analytical techniques.
2. Business Managers:
Managers use BI reports and dashboards to make strategic and
operational decisions.
3. IT Professionals:
IT specialists design and maintain data warehouses,
databases, and BI systems.
4. Data Scientists:
They use advanced analytics, machine learning,
and predictive models to extract valuable insights from data.
5. End Users:
Employees and decision-makers who use BI tools
to analyze business performance and generate reports.
1. Improves decision-making by providing accurate and timely information.
2. Helps organizations identify market trends and business opportunities.
3. Enhances operational efficiency and productivity.
4. Improves customer satisfaction through better understanding of customer behavior.
5. Provides competitive advantage in the market.
1. Use of Artificial Intelligence and Machine Learning in data analysis.
2. Growth of cloud-based BI solutions.
3. Real-time data analytics and dashboards.
4. Self-service BI tools that allow non-technical users to analyze data.
5. Increased focus on data visualization and interactive reporting.
Exception handling in PL/SQL is used to handle runtime errors that occur during program execution. It allows programmers to manage errors gracefully instead of stopping the program abruptly.
PL/SQL provides a special block called the EXCEPTION block that handles errors.
BEGIN
-- SQL statements
EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE('No data found.');
END;
Common types of PL/SQL exceptions include predefined exceptions, non-predefined exceptions, and user-defined exceptions.
Triggers are special stored procedures that automatically execute when a specific event occurs in a database table.
The main types of SQL triggers are:
1. BEFORE Trigger – Executes before an INSERT, UPDATE, or DELETE operation.
2. AFTER Trigger – Executes after the operation is completed.
3. INSTEAD OF Trigger – Executes instead of the triggering event (commonly used in views).
CREATE TRIGGER before_insert_student
BEFORE INSERT ON Students
FOR EACH ROW
BEGIN
DBMS_OUTPUT.PUT_LINE('A new student record is being inserted.');
END;
This trigger automatically displays a message before inserting a new record into the Students table.
A Data Warehouse is a centralized repository that stores large volumes of historical data collected from multiple sources. It supports business analysis and decision-making.
Major functions of a data warehouse include:
1. Data integration from different sources.
2. Storage of large volumes of historical data.
3. Data analysis and reporting.
4. Support for strategic decision-making.
5. Data consistency and quality management.
1. ETL Tools (Extract, Transform, Load) such as Informatica and Talend.
2. OLAP tools for multidimensional analysis.
3. Data visualization tools like Power BI and Tableau.
4. Database management systems for storing large datasets.
1. Data extraction utilities – Collect data from different operational systems.
2. Data cleaning utilities – Remove errors and inconsistencies in data.
3. Data loading utilities – Load processed data into the warehouse.
4. Query and reporting utilities – Generate analytical reports and dashboards.
5. Data backup and recovery utilities – Ensure data security and reliability.
Thus, data warehouses play a crucial role in storing, organizing, and analyzing business data for effective decision-making.