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

bitingbit

  • Member
  • Posts: 323
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

In the United States, an estimated 50 million unnecessary antibiotics are prescribed for viral respiratory infections.

Did you know?

Although not all of the following muscle groups are commonly used, intramuscular injections may be given into the abdominals, biceps, calves, deltoids, gluteals, laterals, pectorals, quadriceps, trapezoids, and triceps.

Did you know?

Thyroid conditions may make getting pregnant impossible.

Did you know?

The average adult has about 21 square feet of skin.

Did you know?

Elderly adults are at greatest risk of stroke and myocardial infarction and have the most to gain from prophylaxis. Patients ages 60 to 80 years with blood pressures above 160/90 mm Hg should benefit from antihypertensive treatment.

A cross of sweet peas showing that independent assortment does not always occur A cross of sweet peas showing that independent assortment does not always occur
Exploring the functional activity of brain regions by using fMRI scans. Exploring the functional activity of brain regions by using fMRI scans.
Peptic ulcer. A peptic ulcer may occur in the stomach (gastric ulcer), as shown here, or in the duod Peptic ulcer. A peptic ulcer may occur in the stomach (gastric ulcer), as shown here, or in the duod
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
Normal Partial Pressures Normal Partial Pressures
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: Transferring genes into plants Animation

For a complete list of videos, visit our video library