In database design, which normal form requires the table to be in 1NF and have all non-prime attributes fully functionally dependent on the primary key (no partial dependency)?

Which ACID property ensures that all operations in a database transaction are completed successfully, or none of them are applied at all?

What type of key constraint ensures that values in a column must match existing values in a primary key column of another table?

Which SQL clause is used to filter group results after a GROUP BY operation has been performed?

In database normalization, what type of functional dependency is characterized by a non-key attribute depending on another non-key attribute, violating 3NF?

SELECT dept_name , ID , avg ( salary ) FROM instructor GROUP BY dept_name; This statement IS erroneous because

SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used.

Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause.