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

JGIBBSON

  • Hero Member
  • *****
  • Posts: 538
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
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


 

Did you know?

The cure for trichomoniasis is easy as long as the patient does not drink alcoholic beverages for 24 hours. Just a single dose of medication is needed to rid the body of the disease. However, without proper precautions, an individual may contract the disease repeatedly. In fact, most people develop trichomoniasis again within three months of their last treatment.

Did you know?

Individuals are never “cured” of addictions. Instead, they learn how to manage their disease to lead healthy, balanced lives.

Did you know?

In 2012, nearly 24 milliion Americans, aged 12 and older, had abused an illicit drug, according to the National Institute on Drug Abuse (NIDA).

Did you know?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

Did you know?

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

For a complete list of videos, visit our video library