Database Record: Definition & Explanation

An error occurred trying to load this video.

Try refreshing the page, or contact customer support.

Coming up next: Storing Hierarchical Data in a Database

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 Record?
  • 1:07 Records in the Database
  • 2:18 Example of Database Record
  • 3:13 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: Martin Gibbs

Martin has 16 years experience in Human Resources Information Systems and has a PhD in Information Technology Management. He is an adjunct professor of computer science and computer programming.

This lesson covers the concept of a database record in a database application. In this lesson, the concept of a record will be defined, and an example will be provided for a database record.

What Is a Record?

We're not talking about an LP or a 45, nor a measure of a feat of strength. A record is simply a set of data stored in a table, for example, a customer record. A record in a database is an object that can contain one or more values. Groups of records are then saved in a table; the table defines the data that each record may contain. In a given database, there are multiple tables, each containing multiple records.

Think of the rows and columns of a typical spreadsheet. Rows are horizontal and go across the spreadsheet from left to right, whereas columns are vertical and flow down the worksheet. Since a new row creates a new entry in the table/spreadsheet, it is called a record. The same is true in a database: records are stored in rows that make up the table. The fields in the database are the columns.

A fancy word for a database record is a tuple. Study.com lessons on relational databases may use this term. Additionally, the column can be called an attribute, and the table or data set is a relation.

Records in the Database

Records provide a practical way to store and retrieve data from the database. Each record can have different kinds of data, and thus a single row could have several types of information. A customer record could contain an ID number, name, birth date, cell phone number, and email.

There is one exception to the above rule. A good database design should include a primary key for the table. This means that each record in the data set has one field that is unique among all records and that it can't be repeated. Tools like Microsoft Access let you easily set a field to be the primary key; this is usually a field that is auto-numbered (starting at 1) and keeps adding as you add rows/records to the table.

The term ''record'' can also be pronounced reCORD, meaning to save information/data. This is also a helpful means to identify a database record: It's a record, or the data, that has been reCORDed.

A group of records can be called a file, data set, or table. Microsoft Access and other database tools refer to these objects as tables: This lesson will refer to the collective group of records as a table.

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