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 34 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
Great answer, keep it coming :)


billybob123

  • Member
  • Posts: 336
Reply 3 on: Yesterday
Gracias!

 

Did you know?

Complications of influenza include: bacterial pneumonia, ear and sinus infections, dehydration, and worsening of chronic conditions such as asthma, congestive heart failure, or diabetes.

Did you know?

Oxytocin is recommended only for pregnancies that have a medical reason for inducing labor (such as eclampsia) and is not recommended for elective procedures or for making the birthing process more convenient.

Did you know?

Alcohol acts as a diuretic. Eight ounces of water is needed to metabolize just 1 ounce of alcohol.

Did you know?

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

Did you know?

Signs and symptoms that may signify an eye tumor include general blurred vision, bulging eye(s), double vision, a sensation of a foreign body in the eye(s), iris defects, limited ability to move the eyelid(s), limited ability to move the eye(s), pain or discomfort in or around the eyes or eyelids, red or pink eyes, white or cloud spots on the eye(s), colored spots on the eyelid(s), swelling around the eyes, swollen eyelid(s), and general vision loss.

For a complete list of videos, visit our video library