This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: When does a partial functional dependency occur? What will be an ideal ... (Read 61 times)

xclash

  • Hero Member
  • *****
  • Posts: 681
on: Jul 7, 2018
When does a partial functional dependency occur?
 
  What will be an ideal response?

Question 2

What is a data dictionary?
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

ririgirl15

  • Sr. Member
  • ****
  • Posts: 385
Reply #1 on: Jul 7, 2018
Answer to Question 1

A partial functional dependency occurs when a column of a relation is functionally dependent
on a component of a composite primary key.

Answer to Question 2

A data dictionary is a repository of the metadata (data about the data) of the database. The data dictionary, also sometimes called the metadata repository, contains information such as the names of the tables, names and types of columns in them, the primary keys, referential integrity constraints, and so on. The metadata showing the structure of the functioning database system is automatically stored by the DBMS in the data dictionary.


xclash

  • Member
  • Posts: 681
Reply 2 on: Jul 7, 2018
Wow, this really help

vickyvicksss

  • Member
  • Posts: 351
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Blood in the urine can be a sign of a kidney stone, glomerulonephritis, or other kidney problems.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

Fewer than 10% of babies are born on their exact due dates, 50% are born within 1 week of the due date, and 90% are born within 2 weeks of the date.

Did you know?

Astigmatism is the most common vision problem. It may accompany nearsightedness or farsightedness. It is usually caused by an irregularly shaped cornea, but sometimes it is the result of an irregularly shaped lens. Either type can be corrected by eyeglasses, contact lenses, or refractive surgery.

Did you know?

In 1844, Charles Goodyear obtained the first patent for a rubber condom.

The nonionic form does not occur in significant amounts in aqueous solutions The nonionic form does not occur in significant amounts in aqueous solutions
Scaling the Earth down to the size of a basketball, the Moon is roughly the size of a tennis ball. T Scaling the Earth down to the size of a basketball, the Moon is roughly the size of a tennis ball. T
Functional MRI Scans These scans of human brains show localized average increases in neural activity Functional MRI Scans These scans of human brains show localized average increases in neural activity
Does pregnancy occur during breastfeeding? "هل يحدث حمل أثناء الرضاعة Does pregnancy occur during breastfeeding? "هل يحدث حمل أثناء الرضاعة
A partial map of mutations in the A and B cistrons of the rII locus of phage T4 A partial map of mutations in the A and B cistrons of the rII locus of phage T4
Video: Oxygen transport: association and dissociation & Factors that affect hemoglobin's saturation with O2

For a complete list of videos, visit our video library