What is an Attribute in a Database?

An error occurred trying to load this video.

Try refreshing the page, or contact customer support.

Coming up next: What is an Entity 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 The Need for Databases
  • 0:23 Relational Databases
  • 2:15 Functional Dependency
  • 2:43 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: Marcia Wert

Marcia has taught Information technology and Mathematics with a master's degree in IT

Explore how and what an attribute in a relational database is in this lesson. In database management systems, it refers to a table within the database. In relational databases, it refers to a column within the table.

The Need for Databases

Have you ever imagined a world in which there are no databases? Say you were at the airport, standing in line to get a flight, but the clerk has to look up any available seats from a huge book of paper or call someone to find out if a flight is available. This is why we have designed relational databases and the components within database tables.

Relational Databases

Relational databases are electronic tables that look like spreadsheets and house large amounts of interconnected data. They are make of up of rows and columns. The rows are called tuples, which are data sets that apply to one item. The columns are called attributes, which are the describing characteristics of each tuple, such as customers, flights, or suspects. Think of describing a person that committed a burglary to the police. You want to include their height, weight, eye color, race, and hair color. These would be important characteristics that help to identify the person.

The tables are connected to each other by use of a primary key, or a special column in the database table that describes all the records uniquely. Think of an airport in which you have a list of flights. The flight number is the primary key.

If we look at the table of flights with the primary key of flight number, we want to describe any object or data about the flight number. Corresponding attributes could be arriving time, arrival day, departing time, departure date, where it's departing and what city it will arrive in.

The corresponding table will look like this:


Example table with the unique flight number as the primary key, and the descriptive columns as attributes.
example table


These are all characteristics that describe important elements about the flight number, the primary key. Even if you were to take two flights, each flight number would be unique for that particular air carrier.

Tables are designated as either strong or weak entities. A table that has only one primary key is considered a strong entity. If the table doesn't have a primary key, but has two attributes that only together comprise a unique identifier, that's called using a composite key. Say a table describes which event will happen in which room at a convention center, like this:


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