Data Management Foundations Exam Preparation Material | WGU Data Management – Foundations Exam

Explanation:
An intangible entity is an entity that does not have a physical presence but still holds meaning in a database. These entities represent concepts, relationships, or abstract data that exist in a logical sense.
Example Usage in Databases:
Customer Loyalty Status (Gold, Silver, Bronze)
The loyalty level is an intangible entity since it is derived from other data (purchase history). Online User Sessions
A session ID exists logically in the system but does not have a tangible presence like a product or employee.
Why Other Options Are Incorrect:
Option A (Concrete entity) (Incorrect): No such formal term in database design.
Option B (Tangible entity) (Incorrect): Represents something physical, like an employee or product.
Option D (Physical entity) (Incorrect): Refers to data stored on disk, like database tables or indexes.
Thus, the correct answer is Intangible entity, as it only exists in a logical sense within the database.
Reference: Database Entity-Relationship Modeling.

Explanation:
The CASCADE constraint ensures that updates or deletions in the primary key table automatically reflect in the foreign key table.
Example Usage:
sql
CREATE TABLE Departments (
DeptID INT PRIMARY KEY,
DeptName VARCHAR(50)
);
CREATE TABLE Employees (
EmpID INT PRIMARY KEY,
Name VARCHAR(50),
DeptID INT,
FOREIGN KEY (DeptID) REFERENCES Departments(DeptID) ON UPDATE CASCADE ON DELETE CASCADE
);
If DeptID changes in Departments, it automatically updates in Employees.
If a DeptID is deleted, all employees in that department are also deleted.
Why Other Options Are Incorrect:
Option A (SET DEFAULT) (Incorrect): Sets foreign key values to a default value, rather than propagating changes.
Option B (SET NULL) (Incorrect): When the referenced key is deleted, dependent records are set to NULL instead of being updated/deleted.
Option C (RESTRICT) (Incorrect): Prevents deletion of a referenced row if dependent foreign key rows
exist.
Thus, the correct answer is CASCADE, as it propagates primary key changes to dependent foreign keys.
Reference: SQL Foreign Key Constraints.

Explanation:
The first step in database analysis is identifying entities, which are the real-world objects that need to be represented in the database.
Example Usage:
In a school system, the main entities could be:
Students, Courses, Instructors
Why Other Options Are Incorrect:
Option A (Determine cardinality) (Incorrect): Determining relationships comes after identifying entities.
Option C (Draw an ER diagram) (Incorrect): ER diagrams visualize entities but are not the first step.
Option D (Implement attributes) (Incorrect): Attributes are defined after entities are identified.
Thus, the correct answer is Identify entities, as entities form the foundation of the database model.
Reference: Database Analysis and Entity Discovery.

Explanation:
Aggregate functions perform calculations on a set of values and return a single result. MAX() is one such function, returning the largest value in a column.
Common Aggregate Functions:



Example Usage:
sql
SELECT MAX(Salary) FROM Employees;
Retrieves the highest salary in the Employees table.
Why Other Options Are Incorrect:
Option B (TRIM) (Incorrect): Removes spaces from strings but is not an aggregate function.
Option C (ABS) (Incorrect): Returns the absolute value of a number but does not aggregate multiple rows.
Option D (DESC) (Incorrect): Used in ORDER BY for sorting in descending order, not for aggregation.
Thus, the correct answer is MAX(), as it is a true aggregate function.
Reference: SQL Aggregate Functions​.

Explanation:
The ALTER TABLE statement is used to modify an existing database table structure. One common clause is CHANGE, which allows renaming a column and modifying its data type.
Example:
sql
ALTER TABLE Employees CHANGE COLUMN OldName NewName VARCHAR(50); Option A (Incorrect): DELETE is used to remove rows, not alter table structure.
Option B (Correct): CHANGE is a valid clause for renaming and modifying columns in MySQL and some other databases.
Option C (Incorrect): STOP is not a valid SQL keyword for altering tables.
Option D (Incorrect): AGGREGATE refers to functions like SUM() and AVG(), not table alterations.
Reference: SQL ALTER TABLE syntax in SE 3050 zyBooks.