This topic contains a solution. Click here to go to the answer
« previous next »

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

panfilo

  • Hero Member
  • *****
  • Posts: 572
on: Jul 7, 2018
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
Reply #1 on: Jul 7, 2018
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
Great answer, keep it coming :)

helenmarkerine

  • Member
  • Posts: 324
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

The Centers for Disease Control and Prevention has released reports detailing the deaths of infants (younger than 1 year of age) who died after being given cold and cough medications. This underscores the importance of educating parents that children younger than 2 years of age should never be given over-the-counter cold and cough medications without consulting their physicians.

Did you know?

The top five reasons that children stay home from school are as follows: colds, stomach flu (gastroenteritis), ear infection (otitis media), pink eye (conjunctivitis), and sore throat.

Did you know?

Fewer than 10% of babies are born on their exact due dates, 50% are born within 1 week of the due date, and 90% are born within 2 weeks of the date.

Did you know?

Vaccines cause herd immunity. If the majority of people in a community have been vaccinated against a disease, an unvaccinated person is less likely to get the disease since others are less likely to become sick from it and spread the disease.

Did you know?

Most strokes are caused when blood clots move to a blood vessel in the brain and block blood flow to that area. Thrombolytic therapy can be used to dissolve the clot quickly. If given within 3 hours of the first stroke symptoms, this therapy can help limit stroke damage and disability.

There are several laws of thermodynamics critical to understanding physical processes. Two of those There are several laws of thermodynamics critical to understanding physical processes. Two of those
Authoritative parenting involves enforcing rules in a way that conveys parental affection. Authoritative parenting involves enforcing rules in a way that conveys parental affection.
Critical Steps in CLIA Testing Critical Steps in CLIA Testing
Mathematical Rules and Guidelines Mathematical Rules and Guidelines
Columns With Papyriform And Bud Capitals, Hypostyle Hall, Great Temple Of Amun At Karnak Columns With Papyriform And Bud Capitals, Hypostyle Hall, Great Temple Of Amun At Karnak
International Business: The Challenges of Globalization, 8th Edition International Business: The Challenges of Globalization, 8th Edition
Video: Hormonal regulation of pregnancy - weeks 17 through 38

For a complete list of videos, visit our video library