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

Should i select imaging software that allows changes, Should I select imagi...

Should I select imaging software that allows changes? An imaging system should not give features to edit or alter images. Images generally are formed as safe and secure records

Descrine an data dictionary, Describe an data dictionary? A data dictio...

Describe an data dictionary? A data dictionary is a data structure which keeps meta data about the structure of the database ie. the schema of the database.

Which model is record based logical model, Which model is record based logi...

Which model is record based logical model? Network Modelis basically known as record based logical model.

What is association, What is association? Give an example of association ...

What is association? Give an example of association Association is used for establishing relationships among classes. Association describe links among/between classes. For exa

What are the aggregate objects in the data dictionary, What are the aggrega...

What are the aggregate objects in the data dictionary? Views Match codes Lock objects.

Define thomas write rule, Define Thomas write rule Thomas' write rule: ...

Define Thomas write rule Thomas' write rule: The Thomas' write rule is a modification of timestamp-ordering protocol for concurrency control. Assume that transaction T i issue

Include the create database command, Submit the SQL Statements necessary to...

Submit the SQL Statements necessary to create your database according to the following guidelines: Your SQL statements should exactly mirror your ERD. All primary keys,

What is an operand, What is an Operand? The data on which the operation...

What is an Operand? The data on which the operation is to be performed is known as an Operand

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