Artificial Intelligence, Data Analytics and Cyber Security - Laws and Practice · Database Management

Introduction to DBMS and Data Models Explained

Updated 11 October 2026 · Fact-checked

A DBMS (Database Management System) is software that creates, stores, controls and retrieves an organised collection of related data called a database. It removes the redundancy and inconsistency of file systems. A data model defines how data is structured: hierarchical, network, relational or object-oriented. In exams, define, compare and give examples.

Understand Introduction to DBMS and Data Models

Data is raw facts such as names, numbers or dates, with no context. Information is data that has been processed and organised so that it has meaning and helps a decision. For example, a list of invoice amounts is data. Total sales for the month by region is information.

A database is an organised collection of related data, stored so that it can be accessed, managed and updated easily. A DBMS is the software that sits between users or applications and the database. It lets you define the structure, insert, update, delete and query data, and it controls security, concurrent access and recovery.

Before DBMS, organisations used file systems: separate files for each application. The same customer detail would be stored in many files. This caused data redundancy, inconsistency, difficulty in sharing, weak security and dependence of programs on file formats. A DBMS keeps data in one central place, reduces duplication, enforces integrity rules, supports multiple users and gives data independence.

A data model is a way of describing how data is organised and how the links between data items are represented. The hierarchical model arranges data as a tree: each child has one parent. The network model allows a child to have more than one parent, so it forms a graph. The relational model stores data in tables of rows and columns, linked by common values (keys). The object-oriented model stores data as objects that combine data and the operations on it.

The relational model is the most widely used in business today. The older models are important for comparison questions.

Key rules to remember

Data vs information: Information = processed, organised data that is meaningful for decisions; Use this to open any definition answer.
Hierarchical model: Tree structure; one parent per child; one-to-many links; Access starts from the root. Example: organisation chart.
Network model: Graph structure; a child can have many parents; many-to-many links; More flexible than hierarchical but more complex to design and maintain.
Relational model: Data in tables (relations) of rows (tuples) and columns (attributes); linked by keys; Queried with SQL. Rows are records, columns are fields.
Object-oriented model: Data stored as objects = attributes + methods; supports classes and inheritance; Suited to complex data such as multimedia and design data.
DBMS advantages: Less redundancy, better consistency, data sharing, security, integrity, backup and recovery, data independence; Contrast each with the file system problem.

How to solve Introduction to DBMS and Data Models questions

Most questions ask you to define, compare, list advantages or explain models. Use one structure and adapt it.

1Read the command word: define, differentiate, explain, list or discuss.
2Start with a one-line definition of the key term (data, database, DBMS or the model).
3If it is a comparison, draw a two-column layout and compare on the same points: redundancy, consistency, sharing, security, integrity, recovery.
4For data models, state the structure first, then the relationship type (one-to-many or many-to-many), then an example, then one strength and one limitation.
5Give a small business example, such as a bank, a company's employee records or a stock register.
6Close with a one-line conclusion, such as why the relational model is most used today.
7Check that each point you wrote answers the question and is not a repeat.

Quickest way: Four-point model recall

When to use it: When you must describe or compare data models in limited time.

For each model note: Shape, Links, Example, Limit.
Hierarchical: tree, one parent, organisation chart, rigid.
Network: graph, many parents, airline routes or railway network, complex.
Relational: tables, keys, bank accounts table, handling very complex data is harder.
Object-oriented: objects, classes and inheritance, multimedia or design data, less standardised.
For file system vs DBMS, remember the chain: redundancy, inconsistency, sharing, security, independence.

Common mistakes in Introduction to DBMS and Data Models

Using data and information as the same thing.
In everyday language both words mean similar things.
Fix: Always write that data is raw and information is processed data with meaning. Add a short example.
Saying a database and a DBMS are the same.
Both terms appear together in notes.
Fix: A database is the stored data. A DBMS is the software that manages it.
Confusing hierarchical and network models.
Both use links between records.
Fix: Hierarchical allows only one parent per child (tree). Network allows several parents (graph).
Listing DBMS advantages with no link to file system problems.
Students memorise the list without understanding.
Fix: Pair every advantage with the file system weakness it solves, for example less redundancy against duplicated files.
Describing the relational model without keys.
Students focus only on tables.
Fix: State that tables are related through common column values, such as a primary key in one table appearing as a foreign key in another.
Claiming a DBMS has no disadvantages.
Notes stress only the benefits.
Fix: Mention cost, complexity, need for trained staff and a single point of failure if backup is poor.

Worked examples

Example 1

Differentiate between a file system and a DBMS. (Any four points)

Show the solution

Begin with the meaning: a file system stores data in separate files for each application; a DBMS stores integrated data centrally and manages it through software.
Point 1, redundancy: in a file system the same data is repeated in many files; a DBMS keeps it to a minimum.
Point 2, consistency: duplicate copies in files can differ after updates; a DBMS keeps one controlled copy, so data stays consistent.
Point 3, sharing and security: file data is hard to share and has limited access control; a DBMS supports many users with user-level access rights.
Point 4, independence and recovery: file programs depend on file formats and recovery is manual; a DBMS provides data independence and built-in backup and recovery.

Answer: A file system has redundancy, inconsistency, poor sharing, weak security and format dependence. A DBMS reduces redundancy, keeps data consistent, allows controlled sharing, and provides independence and recovery.

Example 2

Explain the hierarchical and relational data models with an example of each, and state one limitation of the hierarchical model.

Show the solution

Hierarchical model: data is arranged as a tree with a root and child records. Each child has exactly one parent, so the links are one-to-many.
Example: a company has departments, and each department has employees. An employee record belongs to one department only.
Relational model: data is stored in tables with rows (records) and columns (fields). Tables are linked by key values.
Example: an Employee table with Emp_ID as primary key and Dept_ID as a column; a Department table with Dept_ID as primary key. Dept_ID links the two tables.
Limitation of hierarchical: it cannot represent many-to-many relations naturally, and access must go through the parent, so the structure is rigid.

Answer: The hierarchical model is a tree with one parent per child, for example department to employees, and is rigid for many-to-many data. The relational model uses key-linked tables, for example Employee and Department linked by Dept_ID.

Exam tips

Open every answer with a crisp definition; examiners award marks for it.
For comparison questions, use the same points on both sides and write at least four.
Attach a business example to each data model, such as a bank, a company or a library.
Link this topic to later ones: relational model, normalization, SQL and database security under the IT Act.
Keep the answer structured with short points; this paper is written and descriptive.

Practice questions from Database Management

Introduction to DBMS and Data Models: frequently asked questions

What is DBMS in CS Professional?

A DBMS is software that helps you create, store, manage and retrieve data in a database. It also controls security, shared access and recovery. In the AI, Data Analytics and Cyber Security elective, it forms the base for later topics such as the relational model and database security.

What is the difference between a file system and a DBMS?

A file system stores data in separate files for each application, which leads to duplication, inconsistency and weak security. A DBMS keeps integrated data in one place and manages it centrally. It reduces redundancy, supports many users and gives data independence.

What are the types of data models in DBMS?

The four models in this topic are hierarchical, network, relational and object-oriented. Hierarchical uses a tree, network uses a graph, relational uses tables and object-oriented stores objects. The relational model is the most widely used.

Is a database the same as a DBMS?

No. The database is the organised collection of data. The DBMS is the software used to define, access and control that data.