MENU
Which property of an entity can become a column in a table?
In database design, attributes of an entity become columns in a relational table.
Example Usage:
For an Employee entity, attributes might include:
CREATE TABLE Employees (
EmployeeID INT PRIMARY KEY,
Name VARCHAR(50),
Salary DECIMAL(10,2),
DepartmentID INT
);
Each attribute (e.g., Name, Salary) becomes a column in the table.
Why Other Options Are Incorrect:
Option A (Modality) (Incorrect): Describes optional vs. mandatory relationships, not table structure.
Option B (Uniqueness) (Incorrect): Ensures distinct values but is not a column property.
Option D (Non-null values) (Incorrect): Ensures that columns must contain data but does not define attributes.
Thus, the correct answer is Attribute, as attributes of entities become table columns.