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 44 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
YES! Correct, THANKS for helping me on my review

softEldritch

  • Member
  • Posts: 334
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Did you know?

Certain topical medications such as clotrimazole and betamethasone are not approved for use in children younger than 12 years of age. They must be used very cautiously, as directed by a doctor, to treat any child. Children have a much greater response to topical steroid medications.

Did you know?

Immunoglobulin injections may give short-term protection against, or reduce severity of certain diseases. They help people who have an inherited problem making their own antibodies, or those who are having certain types of cancer treatments.

Did you know?

Long-term mental and physical effects from substance abuse include: paranoia, psychosis, immune deficiencies, and organ damage.

Did you know?

More than 20 million Americans cite use of marijuana within the past 30 days, according to the National Survey on Drug Use and Health (NSDUH). More than 8 million admit to using it almost every day.

The functional structure of the peripheral nervous system. (A) Afferent or sensory neurons carry sen The functional structure of the peripheral nervous system. (A) Afferent or sensory neurons carry sen
Vertebral compression Fractures of the spine (vertebra) can cause severe ”band-like” pain that radia Vertebral compression Fractures of the spine (vertebra) can cause severe ”band-like” pain that radia
Functional groups Functional groups
A functional renal unit. A functional renal unit.
Functional Differences between Right and Left Hemispheres Functional Differences between Right and Left Hemispheres
Partial map of disease genes on human chromosome 21 Partial map of disease genes on human chromosome 21
Video: Exocytosis - secretion

For a complete list of videos, visit our video library