« previous next »

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

It is important to read food labels and choose foods with low cholesterol and saturated trans fat. You should limit saturated fat to no higher than 6% of daily calories.

Did you know?

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

Did you know?

There are actually 60 minerals, 16 vitamins, 12 essential amino acids, and three essential fatty acids that your body needs every day.

Did you know?

The first war in which wide-scale use of anesthetics occurred was the Civil War, and 80% of all wounds were in the extremities.

Did you know?

Warfarin was developed as a consequence of the study of a strange bleeding disorder that suddenly occurred in cattle on the northern prairies of the United States in the early 1900s.

Carrie Mae Weems, Untitled (Man Smoking/Malcolm X), from The Kitchen Table Series. Carrie Mae Weems, Untitled (Man Smoking/Malcolm X), from The Kitchen Table Series.
Functional anatomy of a synapse. Functional anatomy of a synapse.
Functional Requisites Functional Requisites
A beam-type torque wrench that displays the torque reading on the face of the dial. The beam display ... A beam-type torque wrench that displays the torque reading on the face of the dial. The beam display ...
A general model of the sensorimotor system. Notice its hierarchical structure, functional ... A general model of the sensorimotor system. Notice its hierarchical structure, functional ...
Table - Correlation Analysis Table - Correlation Analysis
Video: EpiPen Animation (Part 1)

For a complete list of videos, visit our video library