« previous next »

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

The average office desk has 400 times more bacteria on it than a toilet.

Did you know?

About 3.2 billion people, nearly half the world population, are at risk for malaria. In 2015, there are about 214 million malaria cases and an estimated 438,000 malaria deaths.

Did you know?

In 1886, William Bates reported on the discovery of a substance produced by the adrenal gland that turned out to be epinephrine (adrenaline). In 1904, this drug was first artificially synthesized by Friedrich Stolz.

Did you know?

Prostaglandins were first isolated from human semen in Sweden in the 1930s. They were so named because the researcher thought that they came from the prostate gland. In fact, prostaglandins exist and are synthesized in almost every cell of the body.

Did you know?

Complications of influenza include: bacterial pneumonia, ear and sinus infections, dehydration, and worsening of chronic conditions such as asthma, congestive heart failure, or diabetes.

The Indian palm squirrel is the most common type of squirrel found in India. The Indian palm squirrel is the most common type of squirrel found in India.
Range of Motion of the Hip Joint, Position of the Leg for Full External Rotation Range of Motion of the Hip Joint, Position of the Leg for Full External Rotation
Complete the table by dragging the white labels to the gray targets, the blue la Complete the table by dragging the white labels to the gray targets, the blue la
Aegyptopithecus may be ancestral to catarrhines and has full postorbital closure and two premolars. Aegyptopithecus may be ancestral to catarrhines and has full postorbital closure and two premolars.
Patient diagnosed with type 2 diabetes mellitus. Periodontal examination revealed deep periodontal ... Patient diagnosed with type 2 diabetes mellitus. Periodontal examination revealed deep periodontal ...
Human Development (Full Term) Human Development (Full Term)
Video: Muscle Fatigue and Recovery

For a complete list of videos, visit our video library