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 35 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


amynguyen1221

  • Member
  • Posts: 355
Reply 3 on: Yesterday
Wow, this really help

 

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

Allergies play a major part in the health of children. The most prevalent childhood allergies are milk, egg, soy, wheat, peanuts, tree nuts, and seafood.

Did you know?

Blood in the urine can be a sign of a kidney stone, glomerulonephritis, or other kidney problems.

Did you know?

About one in five American adults and teenagers have had a genital herpes infection—and most of them don't know it. People with genital herpes have at least twice the risk of becoming infected with HIV if exposed to it than those people who do not have genital herpes.

Did you know?

People with alcoholism are at a much greater risk of malnutrition than are other people and usually exhibit low levels of most vitamins (especially folic acid). This is because alcohol often takes the place of 50% of their daily intake of calories, with little nutritional value contained in it.

For a complete list of videos, visit our video library