Answer to Question #295741 in Economics of Enterprise for Jen

Question

(True or False): In relational databases, the link between two tables is that the primary key of one table is the foreign key in the other table. Write a paragraph response on why it's true or false.

Question: In the fourth query, we use the WHERE and HAVING clauses. Please select the right choice for the relationship between these two clauses.

1. WHERE clause is used for filtering rows prior to the execution of aggregate functions, while the HAVING clause is used for filtering rows after the execution of aggregate functions.
2. WHERE clause is used for filtering rows after the execution of aggregate functions. The HAVING clause is used for filtering rows prior to the execution of aggregate functions.
3. The WHERE clause can be exchanged to use the HAVING clause.
4. The HAVING is not a clause in SQL queries.

Answer 1

True: In a foreign key reference, a link is created between two tables when the column or columns that hold the primary key value for one table are referenced by the column or columns in another table. This column becomes a foreign key in the second table.

the right choice for the relationship between these two clauses is:

1.WHERE clause is used for filtering rows prior to the execution of aggregate functions, while the HAVING clause is used for filtering rows after the execution of aggregate functions.