« previous next »

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

Adult head lice are gray, about ? inch long, and often have a tiny dot on their backs. A female can lay between 50 and 150 eggs within the several weeks that she is alive. They feed on human blood.

Did you know?

The average human gut is home to perhaps 500 to 1,000 different species of bacteria.

Did you know?

Aspirin may benefit 11 different cancers, including those of the colon, pancreas, lungs, prostate, breasts, and leukemia.

Did you know?

Multiple sclerosis is a condition wherein the body's nervous system is weakened by an autoimmune reaction that attacks the myelin sheaths of neurons.

Did you know?

The human body produces and destroys 15 million blood cells every second.

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
Periodic Table Periodic Table
Assisting the patient to transfer from the bed or examining table to a wheelchair. Assisting the patient to transfer from the bed or examining table to a wheelchair.
A roller cell-type electric fuel pump. A roller cell-type electric fuel pump.
APA Table - SPSS APA Table - SPSS
Chloroplast segregation determined by mating type in Chlamydomonas Chloroplast segregation determined by mating type in Chlamydomonas
Video: Facilitated Diffusion - Glucose transport

For a complete list of videos, visit our video library