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 70 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
Excellent

Missbam101

  • Member
  • Posts: 341
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Pink eye is a term that refers to conjunctivitis, which is inflammation of the thin, clear membrane (conjunctiva) over the white part of the eye (sclera). It may be triggered by a virus, bacteria, or foreign body in the eye. Antibiotic eye drops alleviate bacterial conjunctivitis, and antihistamine allergy pills or eye drops help control allergic conjunctivitis symptoms.

Did you know?

Drugs are in development that may cure asthma and hay fever once and for all. They target leukotrienes, which are known to cause tightening of the air passages in the lungs and increase mucus productions in nasal passages.

Did you know?

Never take aspirin without food because it is likely to irritate your stomach. Never give aspirin to children under age 12. Overdoses of aspirin have the potential to cause deafness.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

Illicit drug use costs the United States approximately $181 billion every year.

Solubility Rules Solubility Rules
Critical thinking model for safety planning Critical thinking model for safety planning
Critical Pediatric Symptoms Indicating Need for Assessment and Possible Intervention Critical Pediatric Symptoms Indicating Need for Assessment and Possible Intervention
Private Practice Massage Therapy Business Plan Private Practice Massage Therapy Business Plan
Breaking the Rules Breaking the Rules
Tips for Critical Thinking Tips for Critical Thinking
Video: Sigmoidoscopy

For a complete list of videos, visit our video library