What type of functional dependency does NOT exist in the table FLIGHT? A) Trivial B) Full key ...

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

Need homework help now?

Ask unlimited questions for free

Ask a Question

JGIBBSON

Hero Member
Posts: 538

Reply #2 on: Jul 7, 2018

HandsomeMarc

Sr. Member
Posts: 360

Reply #3 on: Jul 7, 2018

Happy to Help

« previous next »

Did you know?

The types of cancer that alpha interferons are used to treat include hairy cell leukemia, melanoma, follicular non-Hodgkin's lymphoma, and AIDS-related Kaposi's sarcoma.

Did you know?

A serious new warning has been established for pregnant women against taking ACE inhibitors during pregnancy. In the study, the risk of major birth defects in children whose mothers took ACE inhibitors during the first trimester was nearly three times higher than in children whose mothers didn't take ACE inhibitors. Physicians can prescribe alternative medications for pregnant women who have symptoms of high blood pressure.

Did you know?

About 60% of newborn infants in the United States are jaundiced; that is, they look yellow. Kernicterus is a form of brain damage caused by excessive jaundice. When babies begin to be affected by excessive jaundice and begin to have brain damage, they become excessively lethargic.

Did you know?

Blastomycosis is often misdiagnosed, resulting in tragic outcomes. It is caused by a fungus living in moist soil, in wooded areas of the United States and Canada. If inhaled, the fungus can cause mild breathing problems that may worsen and cause serious illness and even death.

Did you know?

The oldest recorded age was 122. Madame Jeanne Calment was born in France in 1875 and died in 1997. She was a vegetarian and loved olive oil, port wine, and chocolate.

(a) Yucca baccata in full flower; (b) a Yucca moth, Tegeticula planella, ovipositing on a Yucca flow

Table Salt

The Periodic Table of Elements.

Teritary Structure and Functional Diversity

Functional Classification of Glandular Epithelium

A GWAS study for Type 2 diabetes revealed 386,371 genetic markers, clustered here by chromosome numb

Author Question: What type of functional dependency does NOT exist in the table FLIGHT? A) Trivial B) Full key ... (Read 158 times)

Related Topics

Need homework help now?