Models of Database Management Systems (DBMS)

An error occurred trying to load this video.

Try refreshing the page, or contact customer support.

You're on a roll. Keep up the good work!

Take Quiz Watch Next Lesson
Your next lesson will play in 10 seconds
  • 0:43 Flat File
  • 1:53 Hierarchical DBMS
  • 3:28 Network DBMS
  • 4:55 Relational DBMS
  • 7:03 Object-Oriented DBMS
  • 9:04 Lesson Summary
Create an account to start this course today
Try it free for 5 days!
Create An Account

Recommended Lessons and Courses for You

Lesson Transcript
Instructor: Paul Zandbergen

Paul has a PhD from the University of British Columbia and has taught Geographic Information Systems, statistics and computer programming for 15 years.

Get to know the different models of database management systems and learn how each one is used to systematically organize large amounts of data in a logical manner.

DBMS Models

There are a number of different types of database management systems (DBMS), also referred to as DBMS models. Each one represents a somewhat different approach to organizing data in a systematic manner. They include:

Flat file

Hierarchical DBMS

Network DBMS

Relational DBMS

Object-oriented DBMS

Of these five models, the relational DBMS is by far the most widely used, but a quick overview of each model is useful.

Flat File

The most basic way to organize data is as a flat file. You can think of this as a single table with a large number of records and fields. Everything you need is stored in this table, or flat file.

Think of a database of customers. Everything you want to know about the customers is stored in this one table. You start off with a single record for every customer. A customer places an order and you enter this in one of the fields. You continue entering customer orders in this way.

What if the same customer places a second order? Do you enter this as a new record in the table, or do you add a field to the existing record for this customer?

There is no single best answer for this. The key point here is that a flat file is quite limited since it provides very little in terms of structure. In fact, it is so simple that you could argue it is not a DBMS at all. However, it is good to start off with the idea of a flat file, and then you will see how alternative models are more flexible and effective.

Hierarchical DBMS

In a hierarchical DBMS one data item is subordinate to another one. This is called a parent-child relationship. The hierarchical data model organizes data in a tree-like structure.

One of the rules of a hierarchical database is that a parent can have multiple children, but a child can only have one parent. For example, think of an online store that sells many different products. The entire product catalog would be the parent, and the various types of products, such as books, electronics, etc., would be the children. Each type of product can have its own children categories. For example, books could be broken up into fiction and non-fiction. Each of these categories can be broken up into subcategories. You can continue like this by listing individual authors and then the individual book titles.

This is a rather simple way to represent data, but it is very efficient. This model works best for data that is inherently hierarchical in nature. Many datasets cannot easily be organized in this manner and require a more complex approach. For example, in the case of the product catalog, what if a book falls into more than one category? Or what if one author has written several books but also published an audio CD of one of her books? This is where the hierarchical model breaks down.

Network DBMS

In a network DBMS every data item can be related to many others ones. The database structure is like a graph. This is similar to the hierarchical model and also provides a tree-like structure. However, a child is allowed to have more than one parent. In the example of the product catalog, a book could fall into more than one category. The structure of a network database becomes more like a cobweb of connected elements.

For example, consider an organization with an employee database. For each employee there are different pieces of data, such as their name, address, telephone number, social security number and job function. Different units in the organization need different levels of access. For example, the human resources department needs to have access to the social security information for each employee so they can take care of tax deductions and set up benefits. This is somewhat sensitive information, so other departments do not need access to this part of the database. All the pieces of data are connected in a network that implements these rules.

While conceptually relatively simple, this database structure can quickly become very complicated.

Relational DBMS

In a relational DBMS all data are organized in the form of tables. This DBMS model emerged in the 1970s and has become by far the most widely used type of DBMS. Most of the DBMS software developed over the past few decades uses this model. In a table, each row represents a record, also referred to as an entity. Each column represents a field, also referred to as an attribute of the entity.

A relational DBMS uses multiple tables to organize the data. Relationships are used to link the various tables together. Relationships are created using a field that uniquely identifies each record. For example, for a table of books, you could use the ISBN number since there are no two books with the same ISBN. For a table of authors, you would create a unique Author ID to identify each individual author.

Consider a relational database of books and authors. The first table is a table of authors. Each author is identified by a unique author ID, and the table also contains their name and contact information. The second table is a table of books. Each book is identified by its ISBN number, and the table also contains the book's title, the publisher and the author ID associated with the author of the book.

What makes a relational database so effective is that you can link these tables together. In this example you would use the author ID field to do this. For example, you can store multiple books written by the same author or multiple authors for the same book. The detailed information for each author and each book is only stored once and not duplicated in both tables. Yet all the information you need can be accessed using the table relationship.

To unlock this lesson you must be a Member.
Create your account

Register for a free trial

Are you a student or a teacher?
I am a teacher
What is your educational goal?

Unlock Your Education

See for yourself why 10 million people use

Become a member and start learning now.
Become a Member  Back

Earning College Credit

Did you know… We have over 49 college courses that prepare you to earn credit by exam that is accepted by over 2,000 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Click "next lesson" whenever you finish a lesson and quiz. Got It
You now have full access to our lessons and courses. Watch the lesson now or keep exploring. Got It
You're 25% of the way through this course! Keep going at this rate,and you'll be done before you know it.
The first step is always the hardest! Congrats on finishing your first lesson. Go to Next Lesson Take Quiz
Way to go! If you watch at least 30 minutes of lessons each day you'll master your goals before you know it. Go to Next Lesson Take Quiz
Congratulations on earning a badge for watching 10 videos but you've only scratched the surface. Keep it up! Go to Next Lesson Take Quiz
You've just watched 20 videos and earned a badge for your accomplishment! Go to Next Lesson Take Quiz
You've just earned a badge for watching 50 different lessons. Keep it up, you're making great progress! Go to Next Lesson Take Quiz
You just watched your 100th video lesson. You have earned a badge for this achievement! Go to Next Lesson Take Quiz
Congratulations! You just finished watching your 200th lesson and earned a badge! Go to Next Lesson Take Quiz
Congratulations! You just finished watching your 300th lesson and earned a badge! Go to Next Lesson Take Quiz
You are a superstar! You have earned the prestigious 500 video lessons watched badge. Go to Next Lesson Take Quiz
Incredible. You have just entered the exclusive club and earned the 1000 videos watched badge. Go to Next Lesson Take Quiz
You have earned a badge for watching 20 minutes of lessons.
You have earned a badge for watching 50 minutes of lessons.
You have earned a badge for watching 100 minutes of lessons.
You have earned a badge for watching 250 minutes of lessons.
You have earned a badge for watching 500 minutes of lessons.
You have earned a badge for watching 1000 minutes of lessons.