As a separate entity with a 1:M relationship to Student

As a derived attribute

As a composite attribute

As a single attribute in the Student table

Referential integrity cannot be enforced

Surrogate keys must be used

Data independence is lost

Foreign key constraints become optional

Unary 1:M

Ternary

Binary 1:1

An entity without a primary key and with existence dependency

An entity that can exist independently

A derived entity from a supertype

An entity with only composite attributes

Ignored in mapping

Stored as a single multivalued field

Stored into separate columns

Converted to a separate table

Salary of all employees in departments with more than 3 employees.

Departments with average salary > 3

The average salary of the top 3 highest-paid employees per department.

The average salary for departments with more than 3 employees

17000.00

19000.00

13540.60

23000.00

Distinct employees (Sanders, Pernal, Hanes, etc.)

8

Distinct departments (D15, D20, D38, D42)

4