Attributes

A single column from a table .

There are several types of Attributes:

• Atomic/Simple - Atomic attributes cannot be divided (e.g., age).
• Composite - Can be divided into smaller sub-parts (e.g., Address, divided into town, County, Post Code).
• Derived Attribute - Derived from other attributes rather than stored directly (e.g., calculating Age from Date of Birth).
• Key Attribute - An attribute used as or part of a key, such as a Primary Key.
• Non-Prime Attribute - An attribute that is not part of any Candidate key.
• Prime Attribute - An attribute that is part of at least one Candidate key.