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.
| Code and title | MFM 109 (MFM-109 on the syllabus page) · Information Technology Management |
|---|---|
| Course and semester | Master of Business Administration (Financial Management) · First Semester |
| Category and credits | Skill Enhancement · 3 credits · L-T-P: 3-0-0 |
| Marks | 100: 25 internal (15-mark class test and 10 marks for other assessment activities) + 75 external |
| Pass mark | Not specified in the supplied scheme details. Refer to GGSIPU Ordinance 11 for applicable examination rules. |
| Applies to | Batches admitted from 2021-22 onwards under this scheme |
| End-term pattern | No MFM 109 paper-setter instructions identified in the supplied scheme details |
| Units and hours | 4 units, 42 teaching hours: Unit I 6; Unit II 14; Unit III 12; Unit IV 10 |
| Paired lab | MFM 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)
| Basis | Von Neumann | Harvard |
|---|---|---|
| Memory | Shared memory for data and instructions | Separate instruction and data memories |
| Buses | Shared path for instruction and data transfers | Separate instruction and data paths |
| Performance | Shared transfer path can create a bottleneck | Can fetch instructions and data concurrently |
| Typical applications | General-purpose computer architectures | Microcontrollers 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)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>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)
| Basis | TPS | MIS | DSS | ESS |
|---|---|---|---|---|
| Users | Operational staff | Middle managers | Analysts and managers | Senior executives |
| Decisions | Structured | Structured or semi-structured | Semi-structured or unstructured | Strategic and often unstructured |
| Example | Payroll and billing | Monthly sales report | Credit-scoring analysis | Executive 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.
| Unit | Short-answer | Long-answer | Worked material |
|---|---|---|---|
| Unit 1: Information Technology | 6 | 6 | 6 figures |
| Unit 2: Computer Software | 6 | 6 | 12 SQL queries |
| Unit 3: Data Communication and Networks | 6 | 6 | 4 HTML examples |
| Unit 4: Functional and Enterprise Systems | 6 | 6 | 7 figures |
| Total | 24 | 24 | 12 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:
- 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).
- 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).
- 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).
- 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
- Group employee records by department using
GROUP BY. - Calculate the average salary for each department using
AVG(Salary). - Filter the grouped results using
HAVING:SELECT Dept, AVG(Salary) FROM Employee GROUP BY Dept HAVING AVG(Salary) > 40000; - Explain that
WHEREfilters individual rows before grouping, whereasHAVINGfilters 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.
| Group | Papers |
|---|---|
| Related theory 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 |
| Other theory papers | MFM 105 Managerial Economics; MFM 113 Communication in Organizations |
| Paired practical paper | MFM 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.
| Official unit | Official topics | Where in the notes | Status |
|---|---|---|---|
| Unit I: Information Technology (6 hours) | IT system components, classification of computers, architecture, memory, storage, mass storage, cloud computing and data centres | Sections 1.2–1.10, pages 5–17 | Mapped 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 SQL | Sections 2.1–2.18, pages 20–34 | Mapped 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 HTML | Sections 3.1–3.11, pages 37–48 | Mapped 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 IoT | Sections 4.1–4.11, pages 51–60 | Mapped 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.
| Part | Pages |
|---|---|
| Cover and index | 1–4 (4) |
| Unit 1: Information Technology | 5–19 (15) |
| Unit 2: Computer Software | 20–36 (17) |
| Unit 3: Data Communication and Networks | 37–50 (14) |
| Unit 4: Functional and Enterprise Systems | 51–63 (13) |
| Total documented | 1–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.