Question

What is fuctional depandency in dbms 2mark?

Answer 1

Hey... !!! :))
___________
___________

Functional dependency is a relationship that exists when one attribute uniquely determines another attribute.

If R is a relation with attributes X and Y, a functional dependency between the attributes is represented as X->Y, which specifies Y is functionally dependent on X. Here X is a determinant set and Y is a dependent attribute. Each value of X is associated precisely with one Y value.

Functional dependency in a database serves as a constraint between two sets of attributes. Defining functional dependency is an important part of relational database design and contributes to aspect normalization.

Example:-

Cars

Suppose one is designing a system to track vehicles and the capacity of their engines.

One would write VIN → EngineCapacity because it would be inappropriate for a vehicle's engine to have more than one capacity. (Assuming, in this case, that vehicles only have one engine.)

Transversely, EngineCapacity → VIN is incorrect because there could be many vehicles with the same engine capacity.
______________
______________

I Hope it's help you... !!! :))

please tick the brainliest answer.