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 117 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
Thanks for the timely response, appreciate it

Sarahjh

  • Member
  • Posts: 370
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

Less than one of every three adults with high LDL cholesterol has the condition under control. Only 48.1% with the condition are being treated for it.

Did you know?

Your chance of developing a kidney stone is 1 in 10. In recent years, approximately 3.7 million people in the United States were diagnosed with a kidney disease.

Did you know?

Normal urine is sterile. It contains fluids, salts, and waste products. It is free of bacteria, viruses, and fungi.

Did you know?

The cure for trichomoniasis is easy as long as the patient does not drink alcoholic beverages for 24 hours. Just a single dose of medication is needed to rid the body of the disease. However, without proper precautions, an individual may contract the disease repeatedly. In fact, most people develop trichomoniasis again within three months of their last treatment.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

Mutualisms, such as those that occur among plants and pollinators, generally involve large numbers o Mutualisms, such as those that occur among plants and pollinators, generally involve large numbers o
Scientists have demonstrated functional hair regeneration from adult stem cells Scientists have demonstrated functional hair regeneration from adult stem cells
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
Two important changes occur in the upper airway in croup:The epiglottis swells, thereby occluding th Two important changes occur in the upper airway in croup:The epiglottis swells, thereby occluding th
Modification steps (1–4) that occur in maturation of E. coli tRNATyr from its transcript Modification steps (1–4) that occur in maturation of E. coli tRNATyr from its transcript
Functional divisions of vertebrate nervous systems Functional divisions of vertebrate nervous systems
Video: Spermatogenesis Animation

For a complete list of videos, visit our video library