« previous next »

Author Question: What type of functional dependency does NOT exist in the table FLIGHT? A) Trivial B) Full key ... (Read 146 times)

JGIBBSON

  • Hero Member
  • *****
  • Posts: 538
on: Jul 7, 2018
What type of functional dependency does NOT exist in the table FLIGHT?
 
  A) Trivial
  B) Full key
  C) Partial
  D) Transitive

Question 2

When does a circular foreign key dependency occur?
 
  What will be an ideal response?


HandsomeMarc

  • Sr. Member
  • ****
  • Posts: 360
Reply #1 on: Jul 7, 2018
Answer to Question 1

D

Answer to Question 2

Circular foreign key dependency occurs when Table A has a foreign key referring to the primary key of Table B, and Table B has a foreign key referring to the primary key of Table A.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question

JGIBBSON

  • Hero Member
  • *****
  • Posts: 538
Reply #2 on: Jul 7, 2018
TY


HandsomeMarc

  • Sr. Member
  • ****
  • Posts: 360
Reply #3 on: Jul 7, 2018
Happy to Help


« previous next »
 

Did you know?

Famous people who died from poisoning or drug overdose include, Adolf Hitler, Socrates, Juan Ponce de Leon, Marilyn Monroe, Judy Garland, and John Belushi.

Did you know?

Women are two-thirds more likely than men to develop irritable bowel syndrome. This may be attributable to hormonal changes related to their menstrual cycles.

Did you know?

Congestive heart failure is a serious disorder that carries a reduced life expectancy. Heart failure is usually a chronic illness, and it may worsen with infection or other physical stressors.

Did you know?

During pregnancy, a woman is more likely to experience bleeding gums and nosebleeds caused by hormonal changes that increase blood flow to the mouth and nose.

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.

Ectopic pregnancies. (a) An ectopic pregnancy may occur in any of the locations shown. Interstitial Ectopic pregnancies. (a) An ectopic pregnancy may occur in any of the locations shown. Interstitial
Cross functional Process Flow Diagram Cross functional Process Flow Diagram
Standing at the head of the table, apply oil or lotion to chest area. Spread lubricant fanning out ... Standing at the head of the table, apply oil or lotion to chest area. Spread lubricant fanning out ...
Coolest Period Table EVER Coolest Period Table EVER
Short Table of Laplace Tranforms Short Table of Laplace Tranforms
Video: Pressure Flow Model Animation

For a complete list of videos, visit our video library