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 66 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
:D TYSM


triiciiaa

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

 

Did you know?

Pregnant women usually experience a heightened sense of smell beginning late in the first trimester. Some experts call this the body's way of protecting a pregnant woman from foods that are unsafe for the fetus.

Did you know?

HIV testing reach is still limited. An estimated 40% of people with HIV (more than 14 million) remain undiagnosed and do not know their infection status.

Did you know?

When blood is exposed to air, it clots. Heparin allows the blood to come in direct contact with air without clotting.

Did you know?

About 60% of newborn infants in the United States are jaundiced; that is, they look yellow. Kernicterus is a form of brain damage caused by excessive jaundice. When babies begin to be affected by excessive jaundice and begin to have brain damage, they become excessively lethargic.

Did you know?

There are 60,000 miles of blood vessels in every adult human.

For a complete list of videos, visit our video library