Author Question: What type of functional dependency does NOT exist in the table FLIGHT? A) Trivial B) Full key ... (Read 145 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?

Cucumber slices relieve headaches by tightening blood vessels, reducing blood flow to the area, and relieving pressure.

Did you know?

Stevens-Johnson syndrome and Toxic Epidermal Necrolysis syndrome are life-threatening reactions that can result in death. Complications include permanent blindness, dry-eye syndrome, lung damage, photophobia, asthma, chronic obstructive pulmonary disease, permanent loss of nail beds, scarring of mucous membranes, arthritis, and chronic fatigue syndrome. Many patients' pores scar shut, causing them to retain heat.

Did you know?

There are over 65,000 known species of protozoa. About 10,000 species are parasitic.

Did you know?

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

Did you know?

Certain topical medications such as clotrimazole and betamethasone are not approved for use in children younger than 12 years of age. They must be used very cautiously, as directed by a doctor, to treat any child. Children have a much greater response to topical steroid medications.

For a complete list of videos, visit our video library