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 105 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
:D TYSM

amynguyen1221

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

« previous next »
 

Did you know?

The immune system needs 9.5 hours of sleep in total darkness to recharge completely.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

About 3.2 billion people, nearly half the world population, are at risk for malaria. In 2015, there are about 214 million malaria cases and an estimated 438,000 malaria deaths.

Did you know?

Earwax has antimicrobial properties that reduce the viability of bacteria and fungus in the human ear.

Did you know?

When blood is exposed to air, it clots. Heparin allows the blood to come in direct contact with air without clotting.

Cryptorchidism. (a) In complete cryptorchidism, the testes of a newborn have failed to descend into Cryptorchidism. (a) In complete cryptorchidism, the testes of a newborn have failed to descend into
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
Effects of Therapy for Stuttering A functional MRI scan shows regions of the superior temporal lobe Effects of Therapy for Stuttering A functional MRI scan shows regions of the superior temporal lobe
Functional Groups of Vitamin C Functional Groups of Vitamin C
Partial map of the T4 genome Partial map of the T4 genome
Functional Classification of Glandular Epithelium Functional Classification of Glandular Epithelium
Video: Photosynthesis overview Animation

For a complete list of videos, visit our video library