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 99 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

AISCAMPING

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

« previous next »
 

Did you know?

Certain rare plants containing cyanide include apricot pits and a type of potato called cassava. Fortunately, only chronic or massive ingestion of any of these plants can lead to serious poisoning.

Did you know?

You should not take more than 1,000 mg of vitamin E per day. Doses above this amount increase the risk of bleeding problems that can lead to a stroke.

Did you know?

In 2006, a generic antinausea drug named ondansetron was approved. It is used to stop nausea and vomiting associated with surgery, chemotherapy, and radiation therapy.

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

Did you know?

Persons who overdose with cardiac glycosides have a better chance of overall survival if they can survive the first 24 hours after the overdose.

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 groups of biomolecules functional groups of biomolecules
Where Earthquakes Occur— Convergent Boundaries Where Earthquakes Occur— Convergent Boundaries
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
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
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: Audiology

For a complete list of videos, visit our video library