Copyright

Relational Database: Model & Example

An error occurred trying to load this video.

Try refreshing the page, or contact customer support.

Coming up next: Designing a Relational Database: Tutorial & Overview

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

Take Quiz Watch Next Lesson
 Replay
Your next lesson will play in 10 seconds
  • 0:04 What Is a Relational Database?
  • 0:32 Relational Database Uses
  • 1:39 Relational Database Functions
  • 2:32 Lesson Summary
Save Save Save

Want to watch this again later?

Log in or sign up to add this lesson to a Custom Course.

Log in or Sign up

Timeline
Autoplay
Autoplay
Speed Speed

Recommended Lessons and Courses for You

Lesson Transcript
Instructor: Kaitlin Oglesby

Kaitlin has a BA in political science and extensive experience working in the business world as Director of Marketing and Business Development at a financial advice firm.

Relational databases help make up some of the most common uses of computers that we have. In this lesson, we'll see what relational databases are and how they are used and structured.

What Is a Relational Database?

Databases can have plenty of tables, and very often those tables have redundant information. Wouldn't it make sense, both in terms of time saved and errors avoided, if we could avoid some of that redundancy? Luckily, that's exactly what a relational database does. A relational database allows records from one table to link to related records on different tables. Think of it as a giant spider web. In this lesson, we'll look at uses of a relational database as well as seeing how one works.

Relational Database Uses

In 2004, the face of the Internet changed forever. In that year, Facebook was invented. Gone were the days where only the really savvy could have websites about themselves online. From this point on, social media would be a whole new world, ranging from mechanisms to report on tragedies to the home of cat memes. However, at its core, Facebook is a relational database. After all, you fill out information about yourself and then can connect to others via shared interests or relationships. As you might imagine, relational databases have plenty of uses beyond the world of social media.

While there's no way of knowing for sure that they do this, it would only make sense for the U.S. government to use a relational database for its intelligence gathering mission. After all, different tables can be obscured from view from those who don't need to see them. This way, spies in foreign countries can list information in their country tables, while not being able to see what's going on in different countries. Meanwhile, expert analysts back in the States are assigned one or two fields of interest and can only query in those parameters. Using a relational database, the data doesn't have to be reentered, meaning that fewer eyes see all the secrets.

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

Register to view this lesson

Are you a student or a teacher?

Unlock Your Education

See for yourself why 30 million people use Study.com

Become a Study.com member and start learning now.
Become a Member  Back
What teachers are saying about Study.com
Try it risk-free for 30 days

Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 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? Study.com 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.

Create an account to start this course today
Try it risk-free for 30 days!
Create an account
Support