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 36 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
YES! Correct, THANKS for helping me on my review


scikid

  • Member
  • Posts: 300
Reply 3 on: Yesterday
:D TYSM

 

Did you know?

Increased intake of vitamin D has been shown to reduce fractures up to 25% in older people.

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

Historic treatments for rheumatoid arthritis have included gold salts, acupuncture, a diet consisting of apples or rhubarb, nutmeg, nettles, bee venom, bracelets made of copper, prayer, rest, tooth extractions, fasting, honey, vitamins, insulin, snow collected on Christmas, magnets, and electric convulsion therapy.

Did you know?

Illness; diuretics; laxative abuse; hot weather; exercise; sweating; caffeine; alcoholic beverages; starvation diets; inadequate carbohydrate consumption; and diets high in protein, salt, or fiber can cause people to become dehydrated.

Did you know?

Essential fatty acids have been shown to be effective against ulcers, asthma, dental cavities, and skin disorders such as acne.

For a complete list of videos, visit our video library