« previous next »

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

Since 1988, the CDC has reported a 99% reduction in bacterial meningitis caused by Haemophilus influenzae, due to the introduction of the vaccine against it.

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?

In 2010, opiate painkllers, such as morphine, OxyContin®, and Vicodin®, were tied to almost 60% of drug overdose deaths.

Did you know?

Signs of depression include feeling sad most of the time for 2 weeks or longer; loss of interest in things normally enjoyed; lack of energy; sleep and appetite disturbances; weight changes; feelings of hopelessness, helplessness, or worthlessness; an inability to make decisions; and thoughts of death and suicide.

Did you know?

Symptoms of kidney problems include a loss of appetite, back pain (which may be sudden and intense), chills, abdominal pain, fluid retention, nausea, the urge to urinate, vomiting, and fever.

(a) Yucca baccata in full flower; (b) a Yucca moth, Tegeticula planella, ovipositing on a Yucca flow (a) Yucca baccata in full flower; (b) a Yucca moth, Tegeticula planella, ovipositing on a Yucca flow
Assist recipient into side-lying position. Woman sits on edge of table holding drape to cover her ... Assist recipient into side-lying position. Woman sits on edge of table holding drape to cover her ...
Effleurage hand over hand along spinal muscles. Stand at the side directly facing the table and ... Effleurage hand over hand along spinal muscles. Stand at the side directly facing the table and ...
Look at Table 4.2.2. Consumers learn that the rubber ducks wear out batteries quickly. As a ... Look at Table 4.2.2. Consumers learn that the rubber ducks wear out batteries quickly. As a ...
According to Table 17.1, which will reduce water but not Mg2+? According to Table 17.1, which will reduce water but not Mg2+?
Type II curve. Mortality does not vary with age. Data for five-lined skink (Eumeces fasciatus). Type II curve. Mortality does not vary with age. Data for five-lined skink (Eumeces fasciatus).
Video: Cardiac conductile cells

For a complete list of videos, visit our video library