what is an attribute in database
What is an attribute in database
An attribute in a database is a property or characteristic that describes
an entity, and in a table it usually appears as a column. For example, in
a Student table, attributes might be Student_ID, Name, and Class.
Quick Scoop
Think of a database table like a spreadsheet: each row is one record, and each column is an attribute that stores one kind of information. Attributes help organize data so it can be stored, searched, and managed efficiently.
Simple Example
For a Students table:
| Student_ID | Name | Class |
|---|---|---|
| 101 | Amina | 10A |
Why it matters
- Attributes describe what data an entity has.
- They make it easier to filter, sort, and query information.
- They also support rules like
UNIQUEandNOT NULLfor cleaner data.
In one line
An attribute is just a named data field that holds one piece of information about something in the database.
If you want, I can also explain the difference between attribute, entity, row, and field.