Which of the following is the correct technique for representing ...

[jilianpiloj]

Which of the following is the correct technique for representing a M:N relationship using the relational model?
 
  A) An intersection relation is created, and the key of either entity is placed as a key in both the intersection relation and in the other relation.
  B) An intersection relation is created with a surrogate key, which is placed in each of the parent entities.
  C) An intersection relation is created, and the keys of both parent entities are placed as a composite key in the intersection relation.
  D) The key from either relation is placed as a foreign key in the other relation.
  E) None of the above

Question 2

Which of the following is the correct SQL clause to sort the results of a SELECT query in reverse-alphabetic order using the Department field?
 
  A) SORT BY Department
  B) REVERSE Department
  C) ORDER BY Department DESC
  D) SORT BY Department DESC
  E) SORT BY Department REVERSE

[apple]

Answer to Question 1

C

Answer to Question 2

C

[jilianpiloj]

TYSM

[upturnedfurball]

Great answer, keep it coming