Skip to content

Need for a Database Class 12 CS: File System Limits, DBMS

questionbuddy.in/cbse/class-12/computer-science/database-concepts/need-for-a-database-and-file-system-limitations

Computer ScienceCBSE Class 12 · Database Concepts

Need for a Database: Limitations of the File System and What a DBMS Adds (Class 12 Computer Science)

Updated 17 October 2026 · Fact-checked

A database is an organised collection of related data stored so that it can be accessed, updated and managed easily. A file system keeps data in separate files, which causes redundancy, inconsistency, difficult access, weak security and no control over simultaneous users. A DBMS (database management system) removes these problems by storing data once and managing access.

In a file system each file keeps its own copy, so copies can disagree; a DBMS stores the data once and every application shares it.

Illustration drawn for QuestionBuddy.

Understand Need for a Database: Limitations of the File System

A database is an organised collection of related data. A DBMS (Database Management System) is the software that creates the database, stores data, lets users retrieve and change it, and protects it. MySQL, the DBMS named in the CBSE syllabus, is an example.

File system. Earlier, each application kept its own files (for example a fees file, a library file and a transport file in a school). This causes these limitations:

  • Data redundancy: the same data (a student's address) is stored again and again in several files, wasting space.
  • Data inconsistency: when the same item is stored in more than one place and one copy is updated but not the others, the copies disagree.
  • Difficulty in access: to answer a new question a programmer must write a new program, because the file system gives no easy query facility.
  • Data isolation: data in different files in different formats is hard to combine.
  • Weak integrity: rules (for example "marks must be 0 to 100") must be coded in every program; nothing enforces them centrally.
  • Weak security: access can only be given to the whole file; it is hard to hide some fields from some users.
  • No control of concurrent access: if two users update a file together, one update may be lost.

What a DBMS offers.

  • Data is stored once and shared, so redundancy and inconsistency fall.
  • A query language (SQL) answers new questions without new programs.
  • Constraints (such as NOT NULL, UNIQUE, PRIMARY KEY) keep data correct.
  • Access rights control who can see or change which data.
  • Concurrent access by many users is managed safely.
  • Backup and recovery after a failure.

Terms. *Redundancy* means duplication; *inconsistency* means the duplicate copies no longer match. Redundancy is the cause, inconsistency the harmful effect.

Need for a Database: Limitations of the File System: key facts

File system limitations
  • Data redundancy
  • Data inconsistency
  • Difficult access
  • Data isolation
  • Weak integrity
  • Weak security
  • No concurrent access control
Learn any three with an example.
DBMS advantages
  • Reduced redundancy
  • Consistent data
  • Query language (SQL)
  • Constraints for integrity
  • Access control
  • Safe concurrent use
Opposite of each limitation.
Redundancy versus inconsistency
Redundancy: same data stored many times | Inconsistency: copies of the same data disagree
Redundancy causes inconsistency.
Database terms
Databaseorganised collection of related data
DBMSsoftware that manages the database
Example DBMSMySQL
MySQL is the DBMS of the syllabus.

How to answer Need for a Database: Limitations of the File System questions

For a "need for a database" question, link every limitation to a concrete example.

  1. 1Name the limitation (redundancy, inconsistency, access, security, integrity, concurrency).
  2. 2Give a one-line meaning in your own words.
  3. 3Add a small example from the scenario in the question (student address, stock, salary).
  4. 4Say how a DBMS removes it: single copy, query language, constraints, access rights, concurrency control.
  5. 5In a three-mark answer, write three such pairs, each worth one mark.

Need for a Database: Limitations of the File System in real life

The idea, met in an everyday situation. Answer the question in your own words, then compare with the model answer. The one-line hook is what to remember.

Address stored in three files

Suppose a school keeps a student's home address in the fees file, the library file and the transport file. The family moves house and the address is changed in the fees file only.

Which two problems are visible, and how does a database help?

Try it first, then show the solutionSolution
  1. The address is stored three times: redundancy.
  2. Now the files show two different addresses: inconsistency.
  3. In a database the address is stored once in the student table and every application reads that single copy.

Answer: Redundancy and inconsistency; a database stores the address once.

Memory hook: One notice board is better than three old noticeboards.

Two cashiers, one stock

Suppose two cashiers sell the last copy of a book at the same moment using a shared file; both see "1 copy left".

What limitation is this, and how does a DBMS handle it?

Try it first, then show the solutionSolution
  1. Two users updating the same data together: concurrent access.
  2. A DBMS controls simultaneous updates so that the second user sees the updated count of 0.

Answer: Concurrency problem; DBMS controls simultaneous access.

Memory hook: Only one person can hold the pen at a time.

Tricks to remember Need for a Database: Limitations of the File System

Short memory aids. Say each one aloud once, then use it on a question the same day.

  • R-I-A-S-I-C

    Redundancy, Inconsistency, Access, Security, Isolation, Concurrency.

    Use it when: Listing file-system limits.

  • Redundancy repeats, inconsistency disagrees

    Repeated copies are redundancy; copies that disagree are inconsistency.

    Use it when: Telling the two apart.

  • One copy, many views

    A database stores data once and gives each user their own view.

    Use it when: DBMS advantages.

  • DBMS is the manager

    The database is the data; the DBMS is the software that manages it.

    Use it when: Definition questions.

Need for a Database: Limitations of the File System: solved examples

Ordered from board level to HOTS. Try each one before you open the solution.

Example 1: Redundancy · 1 mark · MCQBoard level

Duplication of data in a file system is called:
(a) data isolation (b) data redundancy (c) data integrity (d) data security

Try it first, then show the solutionSolution
  1. Redundancy means the same data is stored repeatedly.

Answer: (b) data redundancy

Example 2: Database and DBMS · 2 marks · Short answerBoard level

What is a database? Give any two advantages of a DBMS over a file system.

Try it first, then show the solutionSolution
  1. A database is an organised collection of related data. (1 mark)
  2. Any two advantages: reduced redundancy, consistent data, easy retrieval using SQL, better security, controlled concurrent access (stated in half marks, total 1 mark).

Answer: Organised collection of related data; for example, less redundancy and a query language.

Example 3: Spot the problems · 3 marks · Short answerHarder board level

Suppose a shop stores a customer's phone number in its billing file and its delivery file. The number is changed in the billing file only. (i) Name the two problems. (ii) How does a DBMS prevent them?

Try it first, then show the solutionSolution
  1. (i) Redundancy (the phone number is stored twice) and inconsistency (the two files now show different numbers). (1.5 marks)
  2. (ii) In a DBMS the number is stored once in a table and used by all applications, so one update is seen everywhere. (1.5 marks)

Answer: Redundancy and inconsistency; store once and share.

Example 4: Limitations of file systems · 3 marks · Short answerHarder board level

Explain any three limitations of a file system with an example each.

Try it first, then show the solutionSolution
  1. Difficulty in access: a new question needs a new program, for example "list students of 12A with fees due". (1 mark)
  2. Weak security: access is given to the whole file, so a clerk who needs addresses can also see marks. (1 mark)
  3. No control of concurrent access: two users editing the same file at once may overwrite each other's changes. (1 mark)

Answer: Any three correct limitations with examples.

Example 5: Case: moving a shop to a database · 4 marks · Case-basedHOTS / competency

Suppose a bookshop keeps its stock, sales and staff salaries in separate text files, all editable by every staff member.
(i) Name the problem if the price of a book is stored in both the stock file and the sales file. (1 mark)
(ii) How would a database stop a cashier from seeing salaries? (1 mark)
(iii) What would the shop use to ask "which books have fewer than 5 copies left" without writing a new program? (1 mark)
(iv) What happens in a database if the rule "copies cannot be negative" is set? (1 mark)

Try it first, then show the solutionSolution
  1. (i) Data redundancy, which can lead to inconsistency.
  2. (ii) Access rights can be given per user or per table, so the cashier can be allowed the stock table but not the salary table.
  3. (iii) A query in SQL.
  4. (iv) A constraint keeps data correct: an update that makes copies negative is rejected, which is data integrity.

Answer: (i) Redundancy (ii) Access rights (iii) SQL query (iv) The invalid value is rejected (integrity)

Where students lose marks in Need for a Database: Limitations of the File System

The slips examiners see most often, and what to write instead.

  • Mistake: Defining inconsistency as duplication

    Duplication is redundancy; inconsistency is the mismatch of duplicate copies.

    Wrong working

    Inconsistency means the same data is stored many times.

    Right working

    Inconsistency means copies of the same data have different values.

    Do this: Say "disagree" for inconsistency and "repeat" for redundancy.

    Usually costs: 1 mark

  • Mistake: Saying a DBMS is a database

    The DBMS is the software; the database is the data it manages.

    Wrong working

    MySQL is a database.

    Right working

    MySQL is a DBMS that manages databases.

    Do this: Use the word software for DBMS.

    Usually costs: 0.5 mark

  • Mistake: Listing limitations without examples

    The question asks to "explain"; the example carries the mark.

    Wrong working

    Data redundancy.

    Right working

    Data redundancy: a student's address is stored in three files.

    Do this: Add a short example to each point.

    Usually costs: 1 mark

Exam tips

  • Pair every limitation with a concrete example in the school or shop context.
  • Use the words redundancy and inconsistency correctly; they are different.
  • Write "organised collection of related data" for a database.
  • Name MySQL as the DBMS, SQL as the language.
  • Mention at least three DBMS benefits in a three-mark answer.

Practice questions on Need for a Database: Limitations of the File System

Write each answer on paper first. Open the hint only if you are stuck, and the answer only when you have finished.

  1. Q1 · 1 mark · MCQBoard level

    Which of the following is NOT an advantage of a DBMS over a file system?
    (a) Reduced data redundancy (b) Better security (c) Increased inconsistency (d) Easy retrieval of data

    Hint

    Choose the harmful item.

    Answer

    (c) Increased inconsistency

  2. Q2 · 1 mark · Very short answerBoard level

    Write the full form of DBMS.

    Hint

    Database ...

    Answer

    Database Management System

  3. Q3 · 2 marks · Short answerHarder board level

    Differentiate between data redundancy and data inconsistency with an example.

    Hint

    One is repetition and the other is disagreement.

    Answer

    Redundancy: the same data stored more than once (an address in three files). Inconsistency: after an update to one copy, the copies no longer agree (two different addresses).

  4. Q4 · 1 mark · Assertion-reasonHarder board level

    Assertion (A): A DBMS reduces data redundancy.
    Reason (R): In a DBMS the data is stored once and shared by all the applications.
    (a) Both A and R are true and R is the correct explanation of A. (b) Both A and R are true but R is not the correct explanation of A. (c) A is true but R is false. (d) A is false but R is true.

    Hint

    Single storage is the cause.

    Answer

    (a) Both are true and R explains A.

  5. Q5 · 3 marks · Short answerHOTS / competency

    Suppose a school is moving its records from separate files to a database. Give three benefits it can expect, with a school example for each.

    Hint

    Think access, security and consistency.

    Answer

    Consistency: a student's address is stored once, so one update fixes it everywhere. Security: teachers can see marks but not fee records, through access rights. Easy access: a query lists all students with attendance below a limit without writing a new program.

Test your recall

Answer in your head or on paper first, then open the card. Pulling an answer out of memory makes it stick far better than re-reading.

  1. 1.What is data redundancy?Show answer

    Duplication of data.

  2. 2.What is data inconsistency?Show answer

    Copies of the same data having different values.

  3. 3.What does DBMS stand for?Show answer

    Database Management System.

  4. 4.Which DBMS is named in the syllabus?Show answer

    MySQL.

  5. 5.Which language queries a DBMS?Show answer

    SQL.

  6. 6.What controls who may see data in a DBMS?Show answer

    Access rights (security).

Need for a Database: Limitations of the File System: frequently asked questions

Why do we need a database when we have files?

Files cause redundancy, inconsistency, difficult access, weak security and unsafe simultaneous use. A DBMS stores data once, answers queries with SQL, enforces rules and controls access.

What is the difference between a database and a DBMS?

The database is the organised collection of data. The DBMS is the software, such as MySQL, that creates, stores, retrieves and protects the database.

What is data inconsistency?

It is when copies of the same data stored in different places disagree, usually because one copy was updated and the others were not.

Does Class 12 ask about levels of data abstraction?

The syllabus lists the introduction and need for a database, the relational model and keys. Detailed schemas and abstraction are not asked.