Notes MFM 109

MFM 109 Information Technology Management Notes for GGSIPU MBA FM Sem 1

MFM 109 Information Technology Management Notes are a printed book for GGSIPU MBA (Financial Management) Semester 1. They cover all 4 official units with 48 exam questions (24 short-answer and 24 long-answer) with answer outlines, 12 SQL queries, 4 HTML code examples and a quick revision table for every unit. They follow the MBA (FM) scheme for 2021-22 onwards.

Written and reviewed by Prateek Talwar · Checked against the GGSIPU MBA (Financial Management) scheme and syllabus, dated 20 May 2022 · Updated 14 October 2026 · Editorial policy

Scheme: MBA (FM) 2021-22 Onwards | Applies to: batches admitted 2021-22 onwards | Verified against: Scheme and Syllabus of MBA (Financial Management), dated 20 May 2022

MFM 109 Information Technology Management at a glance: GGSIPU MBA FM Sem 1 credits, units and exam pattern

MFM 109 is the Skill Enhancement theory paper in MBA (Financial Management) Semester 1. It sits alongside eight other papers in the semester.

MFM 109 snapshot from the MBA (FM) scheme and syllabus
Code and titleMFM 109 (MFM-109 on the syllabus page) · Information Technology Management
Course and semesterMaster of Business Administration (Financial Management) · First Semester
Category and creditsSkill Enhancement · 3 credits · L-T-P: 3-0-0
Marks100: 25 internal (15-mark class test and 10 marks for other assessment activities) + 75 external
Pass markNot specified in the supplied scheme details. Refer to GGSIPU Ordinance 11 for applicable examination rules.
Applies toBatches admitted from 2021-22 onwards under this scheme
End-term patternNo MFM 109 paper-setter instructions identified in the supplied scheme details
Units and hours4 units, 42 teaching hours: Unit I 6; Unit II 14; Unit III 12; Unit IV 10
Paired labMFM 117 Information Technology Management Lab · 1 credit · T/P 2 · 40 internal + 60 external marks
View complete table: MFM 109 snapshot from the MBA (FM) scheme and syllabus

This view preserves the original alignment. Scroll within it if needed to read the complete content.

MFM 109 snapshot from the MBA (FM) scheme and syllabus
Code and titleMFM 109 (MFM-109 on the syllabus page) · Information Technology Management
Course and semesterMaster of Business Administration (Financial Management) · First Semester
Category and creditsSkill Enhancement · 3 credits · L-T-P: 3-0-0
Marks100: 25 internal (15-mark class test and 10 marks for other assessment activities) + 75 external
Pass markNot specified in the supplied scheme details. Refer to GGSIPU Ordinance 11 for applicable examination rules.
Applies toBatches admitted from 2021-22 onwards under this scheme
End-term patternNo MFM 109 paper-setter instructions identified in the supplied scheme details
Units and hours4 units, 42 teaching hours: Unit I 6; Unit II 14; Unit III 12; Unit IV 10
Paired labMFM 117 Information Technology Management Lab · 1 credit · T/P 2 · 40 internal + 60 external marks

The course outcomes cover areas including SQL queries, HTML web pages and information systems for decision-making.

MFM 109 Information Technology Management Notes unit-wise: 48 exam questions, 12 SQL queries and 23 figures across 4 units

These MFM 109 notes progress from computer hardware and cloud computing to software, databases, networks, information systems and emerging technologies. Each unit includes six short-answer questions, six long-answer questions and a quick revision table.

MFM 109 Unit 1: Information Technology

Unit 1 (pages 5 to 19) covers Information Technology, Computer Architecture and Cloud Computing. Its 10 sections discuss IT components, classification of computers, CPU, memory, HDD versus SSD, RAID, NAS and SAN, cloud models and data-centre tiers. It contains 6 figures, 6 short-answer questions and 6 long-answer questions.

Quick look: Von Neumann vs Harvard architecture (from page 10)

Von Neumann and Harvard architecture comparison
BasisVon NeumannHarvard
MemoryShared memory for data and instructionsSeparate instruction and data memories
BusesShared path for instruction and data transfersSeparate instruction and data paths
PerformanceShared transfer path can create a bottleneckCan fetch instructions and data concurrently
Typical applicationsGeneral-purpose computer architecturesMicrocontrollers and digital signal processors

Von Neumann and Harvard architecture comparison

Basis
Memory
Von Neumann
Shared memory for data and instructions
Harvard
Separate instruction and data memories
Basis
Buses
Von Neumann
Shared path for instruction and data transfers
Harvard
Separate instruction and data paths
Basis
Performance
Von Neumann
Shared transfer path can create a bottleneck
Harvard
Can fetch instructions and data concurrently
Basis
Typical applications
Von Neumann
General-purpose computer architectures
Harvard
Microcontrollers and digital signal processors

Modern processors may combine characteristics of both designs, so actual performance depends on the implementation.

MFM 109 Unit 2: Computer Software

Unit 2 (pages 20 to 36) covers Computer Software, Excel and Database Management. It is the longest documented unit, with 18 sections covering software types, operating systems, translators, Excel finance and What-If tools, DBMS keys, ER diagrams, integrity constraints and 12 SQL queries. It contains 5 figures, 6 short-answer questions and 6 long-answer questions.

Quick look: Excel finance formulas (from page 28)

=PMT(9%/12, 20*12, -2500000)
=NPV(10%, C3:C7) + C2
=IRR(C2:C7)
=IF(D2>500000, D2*10%, 0)
View preformatted content

This view preserves the original alignment. Scroll within it if needed to read the complete content.

=PMT(9%/12, 20*12, -2500000)
=NPV(10%, C3:C7) + C2
=IRR(C2:C7)
=IF(D2>500000, D2*10%, 0)

For a ₹25,00,000 loan at 9% annual interest over 20 years, with monthly payments and monthly compounding, the PMT formula gives approximately ₹22,493.15 per month. The NPV example assumes the initial cash flow is in C2 and subsequent periodic cash flows are in C3:C7.

MFM 109 Unit 3: Data Communication and Networks

Unit 3 (pages 37 to 50) covers Data Communication, Networks and the Internet. Its 11 sections explain transmission modes, PAN to WAN, communication media, six network topologies, OSI layers, switches and routers, the Internet, intranet, extranet and 4 HTML code examples. It contains 5 figures, 6 short-answer questions and 6 long-answer questions.

Quick look: skeleton of an HTML page (from page 47)

<!DOCTYPE html>
<html>
  <head>
    <title>Unnati Finance Ltd.</title>
  </head>
  <body>
    <p>We offer <b>home loans</b> and <i>investment advice</i>.</p>
  </body>
</html>
View preformatted content

This view preserves the original alignment. Scroll within it if needed to read the complete content.

<!DOCTYPE html>
<html>
  <head>
    <title>Unnati Finance Ltd.</title>
  </head>
  <body>
    <p>We offer <b>home loans</b> and <i>investment advice</i>.</p>
  </body>
</html>

The <body> contains the page's main displayed content, while the <title> identifies the document in browser tabs and other interfaces.

MFM 109 Unit 4: Functional and Enterprise Systems

Unit 4 (pages 51 to 63) covers Functional and Enterprise Systems, Security and Emerging Trends. Its 11 sections discuss DIKW, Simon's decision-making model, TPS to ESS, functional information systems, ERP and CRM, the CIA triad, 14 threats and 10 controls, blockchain, artificial intelligence, machine learning and IoT. It contains 7 figures, 6 short-answer questions and 6 long-answer questions.

Quick look: TPS, MIS, DSS and ESS compared (from page 55)

Four types of organisational information systems
BasisTPSMISDSSESS
UsersOperational staffMiddle managersAnalysts and managersSenior executives
DecisionsStructuredStructured or semi-structuredSemi-structured or unstructuredStrategic and often unstructured
ExamplePayroll and billingMonthly sales reportCredit-scoring analysisExecutive dashboard

Four types of organisational information systems

Basis
Users
TPS
Operational staff
MIS
Middle managers
DSS
Analysts and managers
ESS
Senior executives
Basis
Decisions
TPS
Structured
MIS
Structured or semi-structured
DSS
Semi-structured or unstructured
ESS
Strategic and often unstructured
Basis
Example
TPS
Payroll and billing
MIS
Monthly sales report
DSS
Credit-scoring analysis
ESS
Executive dashboard

MFM 109 exam corner: 24 short-answer and 24 long-answer questions by unit

The notes provide six short-answer and six long-answer practice questions per unit, with answer outlines. The source groups short-answer questions under 2–5 marks and long-answer questions under 10–15 marks; these are practice categories, not a confirmed university question-paper pattern.

MFM 109 practice questions and worked material per unit
UnitShort-answerLong-answerWorked material
Unit 1: Information Technology666 figures
Unit 2: Computer Software6612 SQL queries
Unit 3: Data Communication and Networks664 HTML examples
Unit 4: Functional and Enterprise Systems667 figures
Total242412 SQL queries and 4 HTML examples

MFM 109 practice questions and worked material per unit

Unit
Unit 1: Information Technology
Short-answer
6
Long-answer
6
Worked material
6 figures
Unit
Unit 2: Computer Software
Short-answer
6
Long-answer
6
Worked material
12 SQL queries
Unit
Unit 3: Data Communication and Networks
Short-answer
6
Long-answer
6
Worked material
4 HTML examples
Unit
Unit 4: Functional and Enterprise Systems
Short-answer
6
Long-answer
6
Worked material
7 figures
Unit
Total
Short-answer
24
Long-answer
24
Worked material
12 SQL queries and 4 HTML examples

Across all four units, the notes contain 48 practice questions and 23 figures. The SQL queries and HTML examples are additional worked material.

One question per unit, with answer pointers:

  1. Unit 1: What is PUE? Pointer: Power Usage Effectiveness = total data-centre facility power ÷ IT equipment power. A value closer to 1 indicates less facility overhead relative to IT equipment power (page 17).
  2. Unit 2: Explain primary key and foreign key. Pointer: A primary key uniquely identifies each row and cannot be null. A foreign key establishes a relationship by referencing a candidate key, commonly the primary key, in another or the same table (page 35).
  3. Unit 3: Distinguish between hub, switch and router. Pointer: A hub repeats signals at Layer 1, a typical Ethernet switch forwards frames using MAC addresses at Layer 2, and a router forwards packets using network-layer addresses at Layer 3 (page 49).
  4. Unit 4: Explain Simon's model of decision-making. Pointer: Explain Intelligence, Design and Choice, followed by Implementation, with information-system support at each stage (page 61).

Additional practice is planned under MFM 109 important questions.

Who writes and checks the MFM 109 IT Management notes?

  • Prateek Talwar, author: Founder, Unnati Educations; Associate Company Secretary (ACS), ICSI, membership no. 58704, since 15 May 2019; B.Com, University of Delhi (School of Open Learning), 2012. Author profile

Prateek Talwar is also listed as the reviewer. The 2026-27 edition includes topics such as the Digital Personal Data Protection Act, 2023, CERT-In's six-hour incident-reporting requirement, XLOOKUP and HTML5.

Last updated 14 October 2026. See the editorial policy.

The same team also prepares GGSIPU important questions.

How to write MFM 109 answers: comparison tables, labelled diagrams, SQL queries and HTML code

MFM 109 practice answers commonly involve comparisons, labelled diagrams and short code examples. The unit-end answer outlines suggest formats for these question types.

Difference questions. Use a table with a Basis column for RAM versus ROM, compiler versus interpreter, LAN versus MAN versus WAN, or Internet versus intranet versus extranet. The notes recommend four or five comparable points and demonstrate this approach for DAS, NAS and SAN on page 14.

Diagram questions. Draw the memory hierarchy with clearly labelled levels and indicate the general relationships between speed, cost per bit and capacity (page 12). For ER diagrams, label entities, attributes, relationships and cardinality (page 32). For network topologies, draw a small labelled sketch and explain how devices connect (page 42).

Emerging-technology questions. For blockchain, AI, machine learning and IoT, use consistent comparison headings: core idea, key term, origin, finance application and main risk. This format is suggested on page 62.

Worked example: Department-wise average salary above ₹40,000

  1. Group employee records by department using GROUP BY.
  2. Calculate the average salary for each department using AVG(Salary).
  3. Filter the grouped results using HAVING:
    SELECT Dept, AVG(Salary)
    FROM Employee
    GROUP BY Dept
    HAVING AVG(Salary) > 40000;
    View preformatted content

    This view preserves the original alignment. Scroll within it if needed to read the complete content.

    SELECT Dept, AVG(Salary)
    FROM Employee
    GROUP BY Dept
    HAVING AVG(Salary) > 40000;
  4. Explain that WHERE filters individual rows before grouping, whereas HAVING filters grouped results.

HTML questions. Begin with <!DOCTYPE html>, <html>, <head>, <title> and <body>. Add the elements requested by the question and keep the opening and closing tags correctly paired.

MFM 109 and the MFM 117 IT Management lab, plus other GGSIPU MBA FM Sem 1 papers

Paired lab: MFM 117 Information Technology Management Lab, a separate 1-credit practical paper based on MFM 109.

The lab's four areas correspond to the following sections of the notes:

  • Operating-system utilities: Unit 2, pages 21–23.
  • SQL queries: Unit 2, pages 33–34.
  • Spreadsheet tools: What-If analysis, Goal Seek, Solver and Pivot Tables in Unit 2, pages 26–28.
  • HTML tags: Unit 3, pages 46–48.

The MFM 117 lab notes page is pending. These theory notes can support practical preparation but do not replace hands-on exercises or a lab record.

  • MFM 107 Accounting for Management: Financial and accounting information systems, including Tally Prime, Zoho Books and SAP FICO, on page 55.
  • MFM 103 Quantitative Techniques: Solver and regression tools on page 28.
  • MFM 115 Legal Aspects of Business: IT Act and DPDP Act topics on page 57.
  • MFM 111 Marketing Management: CRM applications on page 56.
  • MFM 101 Management Process and Organisational Behaviour: Simon's decision-making model on page 52.
Other MBA (FM) Semester 1 papers under the 2021-22 onwards scheme
GroupPapers
Related theory papersMFM 101 Management Process and Organisational Behaviour; MFM 103 Quantitative Techniques; MFM 107 Accounting for Management; MFM 111 Marketing Management; MFM 115 Legal Aspects of Business
Other theory papersMFM 105 Managerial Economics; MFM 113 Communication in Organizations
Paired practical paperMFM 117 Information Technology Management Lab

Other MBA (FM) Semester 1 papers under the 2021-22 onwards scheme

Group
Related theory papers
Papers
MFM 101 Management Process and Organisational Behaviour; MFM 103 Quantitative Techniques; MFM 107 Accounting for Management; MFM 111 Marketing Management; MFM 115 Legal Aspects of Business
Group
Other theory papers
Papers
MFM 105 Managerial Economics; MFM 113 Communication in Organizations
Group
Paired practical paper
Papers
MFM 117 Information Technology Management Lab

Advantages of DBMS and the three-schema architecture: excerpt from page 30 of the MFM 109 notes

Excerpt from page 30

Advantages of DBMS

A database management system stores and shares organised data, helping control unnecessary duplication and maintain consistency. Multiple users and applications can access shared information, while data independence reduces the effect of changes in storage arrangements on application programs.

Integrity constraints support accurate and valid records. Passwords, access rights, views and encryption help protect information. Backup and recovery facilities support restoration after failures, while concurrency control coordinates simultaneous transactions. SQL supports data retrieval and reporting, and database administration helps maintain consistent definitions and formats.

Disadvantages

DBMS software and infrastructure can be expensive. Installation, administration and maintenance are complex, and trained personnel may be needed. Small applications may experience unnecessary overhead. Without suitable redundancy and recovery arrangements, a central database can become a critical point of failure.

Three-schema (ANSI/SPARC) architecture

The external or view level represents the data visible to individual users. A bank cashier, for example, may see only the customer information needed for their work. The conceptual or logical level defines the overall database structure, including entities, relationships and constraints. The internal or physical level describes storage structures such as files and indexes.

Logical data independence allows changes to the conceptual schema without requiring changes to external views, where the changes are compatible. Physical data independence allows internal storage changes without altering the conceptual schema.

Key DBMS terms

A schema is the database's defined structure, while an instance is its data at a particular moment. In a relation, degree is the number of attributes and cardinality is the number of tuples. DDL commands such as CREATE, ALTER and DROP define database structures. SQL statements such as SELECT, INSERT, UPDATE and DELETE retrieve or manipulate data. Transactions follow the ACID principles: atomicity, consistency, isolation and durability.

Do the MFM 109 notes cover the full GGSIPU syllabus?

The supplied syllabus map identifies corresponding notes sections for the topics in all four MFM 109 units.

MFM 109 syllabus topics mapped to notes sections
Official unitOfficial topicsWhere in the notesStatus
Unit I: Information Technology (6 hours)IT system components, classification of computers, architecture, memory, storage, mass storage, cloud computing and data centresSections 1.2–1.10, pages 5–17Mapped in supplied content
Unit II: Computer Software (14 hours)Software types, operating systems, GUI, translators, programming languages, spreadsheet and presentation software, Excel analysis, DBMS, data models, ER modelling, integrity constraints and SQLSections 2.1–2.18, pages 20–34Mapped in supplied content
Unit III: Data Communication and Networks (12 hours)Data communication, network types, transmission media, topologies, OSI model, internetworking devices, Internet, intranet, extranet, WWW and HTMLSections 3.1–3.11, pages 37–48Mapped in supplied content
Unit IV: Functional and Enterprise Systems (10 hours)Data, information, knowledge, decision-making, classification of information systems, security, blockchain, AI, machine learning and IoTSections 4.1–4.11, pages 51–60Mapped in supplied content

MFM 109 syllabus topics mapped to notes sections

Official unit
Unit I: Information Technology (6 hours)
Official topics
IT system components, classification of computers, architecture, memory, storage, mass storage, cloud computing and data centres
Where in the notes
Sections 1.2–1.10, pages 5–17
Status
Mapped in supplied content
Official unit
Unit II: Computer Software (14 hours)
Official topics
Software types, operating systems, GUI, translators, programming languages, spreadsheet and presentation software, Excel analysis, DBMS, data models, ER modelling, integrity constraints and SQL
Where in the notes
Sections 2.1–2.18, pages 20–34
Status
Mapped in supplied content
Official unit
Unit III: Data Communication and Networks (12 hours)
Official topics
Data communication, network types, transmission media, topologies, OSI model, internetworking devices, Internet, intranet, extranet, WWW and HTML
Where in the notes
Sections 3.1–3.11, pages 37–48
Status
Mapped in supplied content
Official unit
Unit IV: Functional and Enterprise Systems (10 hours)
Official topics
Data, information, knowledge, decision-making, classification of information systems, security, blockchain, AI, machine learning and IoT
Where in the notes
Sections 4.1–4.11, pages 51–60
Status
Mapped in supplied content

Official syllabus reference: GGSIPU MBA (Financial Management) scheme and syllabus, 2021-22 onwards. The supplied page plan identifies MFM-109 on page 18.

Unit IV also includes functional and enterprise information systems on pages 55–56. The mapping is based on the supplied content inventory; the physical printed book has not been independently inspected.

MFM 109 IT Management notes FAQs

How do I get the full MFM 109 notes?

Use the Get Full Notes WhatsApp button to contact Unnati Educations at 9899436384. The full notes are supplied as a printed book, not a complete PDF. Order and delivery details are confirmed on WhatsApp.

Is MFM 109 a core paper or a Skill Enhancement paper?

MFM 109 is classified as a Skill Enhancement paper in the supplied MBA (Financial Management) scheme for 2021-22 onwards. It carries 3 credits. MFM 117 Information Technology Management Lab is a separate 1-credit practical paper based on MFM 109.

What are the passing marks for MFM 109?

MFM 109 has 100 marks: 25 internal and 75 end-term. The supplied scheme details do not specify the passing percentage. Check GGSIPU Ordinance 11 and the examination rules applicable to your admission batch.

Which MFM 109 unit is the longest in the notes?

Unit 2, Computer Software, is the longest documented unit at 17 pages (pages 20–36). It also has the highest official teaching allocation at 14 of the 42 hours and covers Excel, operating systems, DBMS and 12 SQL queries.

Do the MFM 109 notes help with the MFM 117 lab?

Yes. The notes cover operating-system utilities, SQL, spreadsheet analysis tools and HTML, corresponding to the four practical areas identified in the supplied lab mapping. Students still need to perform practical exercises and prepare any lab records required by their institute.

Are the MFM 109 notes available as a PDF download?

The full notes are offered only as a printed book. The page plan lists a separate eight-page sample PDF for preview; its availability should be checked on the website.

Get the full MFM 109 Information Technology Management Notes on WhatsApp

The MFM 109 notes are in English and offered as a printed book. The full book is not supplied as a downloadable PDF.

Documented pages in the MFM 109 printed notes
PartPages
Cover and index1–4 (4)
Unit 1: Information Technology5–19 (15)
Unit 2: Computer Software20–36 (17)
Unit 3: Data Communication and Networks37–50 (14)
Unit 4: Functional and Enterprise Systems51–63 (13)
Total documented1–63 (63)

Documented pages in the MFM 109 printed notes

Part
Cover and index
Pages
1–4 (4)
Pages
5–19 (15)
Pages
20–36 (17)
Pages
37–50 (14)
Pages
51–63 (13)
Part
Total documented
Pages
1–63 (63)

The source describes a 64-page book, while the supplied page ranges document 63 pages. The remaining page needs confirmation before the printed page count is treated as verified.

Delivery: within 5 to 7 days at most; the exact time may vary with your location.

Order the MFM 109 notes book on WhatsApp (4 units, 64 pages)

Unnati Educations is an independent education provider based in Vikaspuri, Delhi. We are not affiliated with, authorised by, or endorsed by Guru Gobind Singh Indraprastha University (GGSIPU). 'GGSIPU' and 'IPU' are used only to describe the syllabus our notes follow. For official information, visit ipu.ac.in.

Ready for the full notes?

Discuss coverage and delivery with our team.