問題文
A team is turning an entity relationship diagram into a query. The diagram shows an entity, the attributes of that entity, and a one-to-many relationship to a second entity. Which mapping of diagram parts to query parts is correct?
選択肢
- The entity maps to a table named in the FROM clause, an attribute maps to a column named in the select list, and the relationship maps to a join condition between the two tables.
- The entity maps to a table named in the FROM clause, an attribute maps to a join condition between two tables, and the relationship maps to the sort order stated in the ORDER BY clause.
- The entity maps to a single row of stored data, an attribute maps to a join condition between two tables, and the relationship maps to a column named in the select list of the query.
- The entity maps to a column named in the select list, an attribute maps to a table named in the FROM clause, and the relationship maps to a group of rows formed by the GROUP BY clause.