This topic contains a solution. Click here to go to the answer

Author Question: Which of the following is the correct technique for representing a M:N relationship using the ... (Read 31 times)

jilianpiloj

  • Hero Member
  • *****
  • Posts: 521
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



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

apple

  • Sr. Member
  • ****
  • Posts: 352
Answer to Question 1

C

Answer to Question 2

C




jilianpiloj

  • Member
  • Posts: 521
Reply 2 on: Jul 7, 2018
:D TYSM


Chelseyj.hasty

  • Member
  • Posts: 319
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

 

Did you know?

Approximately one in three babies in the United States is now delivered by cesarean section. The number of cesarean sections in the United States has risen 46% since 1996.

Did you know?

Dogs have been used in studies to detect various cancers in human subjects. They have been trained to sniff breath samples from humans that were collected by having them breathe into special tubes. These people included 55 lung cancer patients, 31 breast cancer patients, and 83 cancer-free patients. The dogs detected 54 of the 55 lung cancer patients as having cancer, detected 28 of the 31 breast cancer patients, and gave only three false-positive results (detecting cancer in people who didn't have it).

Did you know?

The immune system needs 9.5 hours of sleep in total darkness to recharge completely.

Did you know?

Approximately 70% of expectant mothers report experiencing some symptoms of morning sickness during the first trimester of pregnancy.

Did you know?

In 1885, the Lloyd Manufacturing Company of Albany, New York, promoted and sold "Cocaine Toothache Drops" at 15 cents per bottle! In 1914, the Harrison Narcotic Act brought the sale and distribution of this drug under federal control.

For a complete list of videos, visit our video library