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 100 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
Excellent

irishcancer18

  • Member
  • Posts: 310
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

The tallest man ever known was Robert Wadlow, an American, who reached the height of 8 feet 11 inches. He died at age 26 years from an infection caused by the immense weight of his body (491 pounds) and the stress on his leg bones and muscles.

Did you know?

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

Did you know?

Signs and symptoms that may signify an eye tumor include general blurred vision, bulging eye(s), double vision, a sensation of a foreign body in the eye(s), iris defects, limited ability to move the eyelid(s), limited ability to move the eye(s), pain or discomfort in or around the eyes or eyelids, red or pink eyes, white or cloud spots on the eye(s), colored spots on the eyelid(s), swelling around the eyes, swollen eyelid(s), and general vision loss.

Did you know?

For about 100 years, scientists thought that peptic ulcers were caused by stress, spicy food, and alcohol. Later, researchers added stomach acid to the list of causes and began treating ulcers with antacids. Now it is known that peptic ulcers are predominantly caused by Helicobacter pylori, a spiral-shaped bacterium that normally exist in the stomach.

Did you know?

Increased intake of vitamin D has been shown to reduce fractures up to 25% in older people.

Rates of Childhood Overweight and Obesity Worldwide The highest rates occur in the most affluent re Rates of Childhood Overweight and Obesity Worldwide The highest rates occur in the most affluent re
functional magnetic resonance imaging functional magnetic resonance imaging
Cultures Ideal Body Types Cultures Ideal Body Types
Normal Partial Pressures Normal Partial Pressures
The functional role of pRB. The pRB protein product of RB1 The functional role of pRB. The pRB protein product of RB1
Synthesis of -Galactosidase and Permease by Haploids and Partial Diploids with Regulatory ... Synthesis of -Galactosidase and Permease by Haploids and Partial Diploids with Regulatory ...
Video: Baroreceptor Reflex

For a complete list of videos, visit our video library