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

Author Question: You should not allow nulls in columns that are critical to your business rules. Indicate whether ... (Read 65 times)

panfilo

  • Hero Member
  • *****
  • Posts: 572
You should not allow nulls in columns that are critical to your business rules.
 
  Indicate whether the statement is true or false

Question 2

Explain many to many relationships and how to deal with them in design.
 
  What will be an ideal response?



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

stallen

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

TRUE

Answer to Question 2

In a many to many relationship, each record in the primary key table can relate to many records in the foreign key table and each record in the foreign key table can relate to many records in the primary key table. No database management system can implement this kind of relationship. The solution is always to create a linking entity between the two entities with a many to many relationship which resolves the relationship into two one to many relationships.




panfilo

  • Member
  • Posts: 572
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review


patma1981

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

 

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

Computer programs are available that crosscheck a new drug's possible trade name with all other trade names currently available. These programs detect dangerous similarities between names and alert the manufacturer of the drug.

Did you know?

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

Did you know?

Calcitonin is a naturally occurring hormone. In women who are at least 5 years beyond menopause, it slows bone loss and increases spinal bone density.

Did you know?

Today, nearly 8 out of 10 pregnant women living with HIV (about 1.1 million), receive antiretrovirals.

For a complete list of videos, visit our video library