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

Author Question: What is an association relationship and how does it differ from an N:M relationship? What will be ... (Read 32 times)

mikaylakyoung

  • Hero Member
  • *****
  • Posts: 531
What is an association relationship and how does it differ from an N:M relationship?
 
  What will be an ideal response?

Question 2

The MySQL IF statement is used to test for a condition and then direct which blocks of code should be run depending on the outcome of the test.
 
  Indicate whether the statement is true or false



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

johnpizzaz

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

An association relationship is very similar to an N:M relationship except that the intersection table has attributes of its own. This means that in addition to the foreign key fields linking to the two strong entities, there is at least one additional field in what would otherwise be called the intersection table but is now an association table. For example, intersection table ENROLLMENT for STUDENT and CLASS showing student enrollment in each class would normally have two columns: StudentID and ClassID. However, we can turn this intersection table into an association table by adding the column Grade, which records each student's grade in each class.

Answer to Question 2

TRUE




mikaylakyoung

  • Member
  • Posts: 531
Reply 2 on: Jul 7, 2018
Great answer, keep it coming :)


kusterl

  • Member
  • Posts: 315
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

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?

The average adult has about 21 square feet of skin.

Did you know?

Symptoms of kidney problems include a loss of appetite, back pain (which may be sudden and intense), chills, abdominal pain, fluid retention, nausea, the urge to urinate, vomiting, and fever.

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.

For a complete list of videos, visit our video library