« previous next »

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

Calcitonin is a naturally occurring hormone. In women who are at least 5 years beyond menopause, it slows bone loss and increases spinal bone density.

Did you know?

Ether was used widely for surgeries but became less popular because of its flammability and its tendency to cause vomiting. In England, it was quickly replaced by chloroform, but this agent caused many deaths and lost popularity.

Did you know?

According to the National Institute of Environmental Health Sciences, lung disease is the third leading killer in the United States, responsible for one in seven deaths. It is the leading cause of death among infants under the age of one year.

Did you know?

Medication errors are more common among seriously ill patients than with those with minor conditions.

Did you know?

The first oral chemotherapy drug for colon cancer was approved by FDA in 2001.

Functional groups Functional groups
Table 6.1 illustrates the main regime types and their differences. It breaks the regimes into four Table 6.1 illustrates the main regime types and their differences. It breaks the regimes into four
a) Avoid bending your spine from working with the table too low. b) Avoid hiking your shoulders from ... a) Avoid bending your spine from working with the table too low. b) Avoid hiking your shoulders from ...
Is this glass half empty or half full? Is this glass half empty or half full?
Sympathetic Nervous System's Flight or Fight Response Sympathetic Nervous System's Flight or Fight Response
table table
Video: Barriers - eye structures, digestive mucosa, respiratory mucosa & genitourinary mucosa

For a complete list of videos, visit our video library