Define functional and multivalued dependencies, Database Management System

Assignment Help:

Define functional and multivalued dependencies.      

Ans:  A functional dependency is a assets of the semantics of the attributes in a relation. The semantics point out how attributes relate to one another, and identify the functional dependencies between attributes. While a functional dependency is available, the dependency is fixed as a constraint among the attributes. Refer a relation with attributes A and B, in which attribute B is functionally dependent on attribute A. If we know the value of A and we inspect the relation that holds this dependency, we will find out just only one value of B in all of the tuples which have a given value of A, at any moment in time. Note though, that for a given value of B there may be various different values of A. 

Multivalued Dependencies:  A multivalued dependency is an outcome of two independent 1: N relationships A: B and A: C being mixed in similar relation R(A,B,C)


Related Discussions:- Define functional and multivalued dependencies

Key, Q.   Explain the terms key constraints participation constraints and m...

Q.   Explain the terms key constraints participation constraints and mapping caradinalities in ER model.  Participation Constraints :   The participation of an entity set E i

List and describe the different types of indexes, Question 1 Indexes are o...

Question 1 Indexes are ocasionally defines on a single field of a file called an indexing field. List and describe the different types of indexes Question 2 Consider a book i

Problem about data mining for business intelligence, Do the 11.1 11.1 Cre...

Do the 11.1 11.1 Credit Card Use. Consider the following hypothetical bank data on consumers’ use of credit card credit facilities in Table 11.3. Create a small worksheet in Exce

Define outer union operation of the relational algebra, Define outer union ...

Define outer union operation of the relational algebra. Compute the outer union for the relations R and S given below. Outer Join - If there are any values in one tabl

Attributes, Attributes and its types explain?

Attributes and its types explain?

Database, why are older data models are being replaced by new data models

why are older data models are being replaced by new data models

B-tree, construct a b-tree for the following set of key values 2,3,5,7,11,1...

construct a b-tree for the following set of key values 2,3,5,7,11,17,19,23,29,31.assume that the tree is initial empty and the values are added in ascending order

Deletion anomalies-data redundancy, Deletion Anomalies: Loss of important ...

Deletion Anomalies: Loss of important Information: In some cases, useful information may be lost when a tuple is deleted. For instance, if we delete the tuple corresponding to stu

What are the types of storage devices, What are the types of storage device...

What are the types of storage devices? Primary storage Secondary storage Tertiary storage Volatile storage Nonvolatile storage

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd