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 34 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
Wow, this really help

bigcheese9

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

« previous next »
 

Did you know?

Cocaine was isolated in 1860 and first used as a local anesthetic in 1884. Its first clinical use was by Sigmund Freud to wean a patient from morphine addiction. The fictional character Sherlock Holmes was supposed to be addicted to cocaine by injection.

Did you know?

Although the Roman numeral for the number 4 has always been taught to have been "IV," according to historians, the ancient Romans probably used "IIII" most of the time. This is partially backed up by the fact that early grandfather clocks displayed IIII for the number 4 instead of IV. Early clockmakers apparently thought that the IIII balanced out the VIII (used for the number 8) on the clock face and that it just looked better.

Did you know?

Chronic necrotizing aspergillosis has a slowly progressive process that, unlike invasive aspergillosis, does not spread to other organ systems or the blood vessels. It most often affects middle-aged and elderly individuals, spreading to surrounding tissue in the lungs. The disease often does not respond to conventionally successful treatments, and requires individualized therapies in order to keep it from becoming life-threatening.

Did you know?

Hip fractures are the most serious consequences of osteoporosis. The incidence of hip fractures increases with each decade among patients in their 60s to patients in their 90s for both women and men of all populations. Men and women older than 80 years of age show the highest incidence of hip fractures.

Did you know?

Fungal nail infections account for up to 30% of all skin infections. They affect 5% of the general population—mostly people over the age of 70.

Critical thinking and the evaluation process Critical thinking and the evaluation process
Rules for Forming Plurals Medical Terms (NOUNS) Rules for Forming Plurals Medical Terms (NOUNS)
Critical-Thinking Tip Critical-Thinking Tip
Business Vector Icon Business Vector Icon
International Business Management International Business Management
Business Math Business Math
Video: Phases of an Action Potential - Resting Potential, Threshold, Rising, Falling, & Recovery Phases

For a complete list of videos, visit our video library