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

Database model, Why older data models are being replaced by new data modell...

Why older data models are being replaced by new data modelling 100 words accepted#

Data Relation diagram, Can you assist me in Database management system? I n...

Can you assist me in Database management system? I need help in my courses, please email me at and get back me soon...

Time stamp ordering, explain in detail about time stamp orderting/

explain in detail about time stamp orderting/

ER diagrams, explain exhaustively the problems associated with ER diagrams....

explain exhaustively the problems associated with ER diagrams. include illustrations in your answer

Having clause-data manipulation language, Having clause This clause...

Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim

What is object containment, What is object containment? References amon...

What is object containment? References among objects can be used to model dissimilar real-world concepts.

Explain the advantages of dbms over file oriented system, Explain the main ...

Explain the main advantages of DBMS over File Oriented System ?

What is called a query -execution engine, What is called a query -execution...

What is called a query -execution engine? The query implementation engine takes a query evaluation plan, implements that plan, and returns the answers to the query.

What is identity, What is Identity? Identity (or AutoNumber) is a colum...

What is Identity? Identity (or AutoNumber) is a column that automatically produces numeric values. A start and increment value can be set, but most DBA leave these at 1. A GUID

Relational schema, crete a data base relationship model Entity: ...

crete a data base relationship model Entity: Students; Professors; Dormitories buildings; Attributes of students: Name; Address; Dorm;

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