« previous next »

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

Multiple experimental evidences have confirmed that at the molecular level, cancer is caused by lesions in cellular DNA.

Did you know?

Pubic lice (crabs) are usually spread through sexual contact. You cannot catch them by using a public toilet.

Did you know?

People about to have surgery must tell their health care providers about all supplements they take.

Did you know?

Most strokes are caused when blood clots move to a blood vessel in the brain and block blood flow to that area. Thrombolytic therapy can be used to dissolve the clot quickly. If given within 3 hours of the first stroke symptoms, this therapy can help limit stroke damage and disability.

Did you know?

The training of an anesthesiologist typically requires four years of college, 4 years of medical school, 1 year of internship, and 3 years of residency.

Drugs and their effect table Drugs and their effect table
Electronegativity Chart (Periodic Table) Electronegativity Chart (Periodic Table)
After adjusting the valves that are closed, rotate the engine one full rotation until the engine ... After adjusting the valves that are closed, rotate the engine one full rotation until the engine ...
Standing at the side of the table facing the head, mobilize the scapula by pressing along medial ... Standing at the side of the table facing the head, mobilize the scapula by pressing along medial ...
Standing at the head of the table, apply effleurage to upper trapezius from neck to shoulder using a ... Standing at the head of the table, apply effleurage to upper trapezius from neck to shoulder using a ...
High stress, by household type (age-standardized), age 18+, Canada, 1994-1995 High stress, by household type (age-standardized), age 18+, Canada, 1994-1995
Video: Homeostasis (range of body conditions, normal limits, mild stresses & severe stresses)

For a complete list of videos, visit our video library