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

hollysheppard095

  • Member
  • Posts: 339
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

Excessive alcohol use costs the country approximately $235 billion every year.

Did you know?

Most women experience menopause in their 50s. However, in 1994, an Italian woman gave birth to a baby boy when she was 61 years old.

Did you know?

All adults should have their cholesterol levels checked once every 5 years. During 2009–2010, 69.4% of Americans age 20 and older reported having their cholesterol checked within the last five years.

Did you know?

Every flu season is different, and even healthy people can get extremely sick from the flu, as well as spread it to others. The flu season can begin as early as October and last as late as May. Every person over six months of age should get an annual flu vaccine. The vaccine cannot cause you to get influenza, but in some seasons, may not be completely able to prevent you from acquiring influenza due to changes in causative viruses. The viruses in the flu shot are killed—there is no way they can give you the flu. Minor side effects include soreness, redness, or swelling where the shot was given. It is possible to develop a slight fever, and body aches, but these are simply signs that the body is responding to the vaccine and making itself ready to fight off the influenza virus should you come in contact with it.

Did you know?

The term pharmacology is derived from the Greek words pharmakon("claim, medicine, poison, or remedy") and logos ("study").

The functional structure of the peripheral nervous system. (A) Afferent or sensory neurons carry sen The functional structure of the peripheral nervous system. (A) Afferent or sensory neurons carry sen
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 Functional groups
Rates of Childhood Overweight and Obesity Worldwide The highest rates occur in the most affluent re Rates of Childhood Overweight and Obesity Worldwide The highest rates occur in the most affluent re
Does pregnancy occur during breastfeeding? "هل يحدث حمل أثناء الرضاعة Does pregnancy occur during breastfeeding? "هل يحدث حمل أثناء الرضاعة
Orientation and structure of a nephron, the functional unit of the kidney. Orientation and structure of a nephron, the functional unit of the kidney.
Video: B cells and antibodies

For a complete list of videos, visit our video library