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

rleezy04

  • Member
  • Posts: 322
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

The human body produces and destroys 15 million blood cells every second.

Did you know?

In 1844, Charles Goodyear obtained the first patent for a rubber condom.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

Illness; diuretics; laxative abuse; hot weather; exercise; sweating; caffeine; alcoholic beverages; starvation diets; inadequate carbohydrate consumption; and diets high in protein, salt, or fiber can cause people to become dehydrated.

Did you know?

Most childhood vaccines are 90–99% effective in preventing disease. Side effects are rarely serious.

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
Image of pitcher plant mosquito Wyeomyia smithii, showing segmentation and partial anatomy of circul Image of pitcher plant mosquito Wyeomyia smithii, showing segmentation and partial anatomy of circul
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
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
Partial genetic map of E. coli Partial genetic map of E. coli
Functional Groups of Carbon Functional Groups of Carbon
Video: Immune responses Animation

For a complete list of videos, visit our video library