Functional dependency in DBMS :The attributes of a table is said to be dependent on each other when an attribute of a table uniquely identifies another attribute of the same table.For example: Suppose we have a student table with attributes: Stu_Id, Stu_Name, Stu_Age. Here Stu_Id attribute uniquely identifies the Stu_Name attribute of student table because if we know the student id we can tell the student name associated with it. This is known as functional dependency and can be written as Stu_Id-Stu_Name or in words we can say Stu_Name is functionally dependent on Stu_Id.Formally:If column A of a table uniquely identifies the column B of same table then it can represented as A-B (Attribute B is functionally dependent on attribute A)

Question

Functional dependency in DBMS :The attributes of a table is said to be dependent on each other when an attribute of a table uniquely identifies another attribute of the same table.For example: Suppose we have a student table with attributes: Stu_Id, Stu_Name, Stu_Age. Here Stu_Id attribute uniquely identifies the Stu_Name attribute of student table because if we know the student id we can tell the student name associated with it. This is known as functional dependency and can be written as Stu_Id->Stu_Name or in words we can say Stu_Name is functionally dependent on Stu_Id.Formally:If column A of a table uniquely identifies the column B of same table then it can represented as A->B (Attribute B is functionally dependent on attribute A)

Lalitesh sharma · Accepted Answer

Functional dependency in DBMS :The attributes of a table is said to be dependent on each other when an attribute of a table uniquely identifies another attribute of the same table.For example: Suppose we have a student table with attributes: Stu_Id, Stu_Name, Stu_Age. Here Stu_Id attribute uniquely identifies the Stu_Name attribute of student table because if we know the student id we can tell the student name associated with it. This is known as functional dependency and can be written as Stu_Id->Stu_Name or in words we can say Stu_Name is functionally dependent on Stu_Id.Formally:If column A of a table uniquely identifies the column B of same table then it can represented as A->B (Attribute B is functionally dependent on attribute A)

[ Functional dependencies are a generalization of]

[A function that has no partial functional dependencies is in _______ form :]

[ Domain constraints, functional dependency and referential integrity are special forms of _________]

[Example of functional testing]

[Functional managers are responsible ______________]

[Functional testing is a ------?]

[Functional parts of computer are]

[The functional unit of Kidney is–]

[Q. Functional Finance is associated with]

[Q. “Functional Finance” is associated with:]

Featured Courses

Popular Pages

SAT (Scholastic Assessment Test)

Study24x7

Henry Harvin

CBSE Study Materials

Digital Marketing - Learn SEO, PPC, SMO,...

Defence

UPSC & State PSC

SSC Preparation Strategies & Study Mater...

Banking/IRDA

DEFENCE EXAM PREPARATION

Get the App

[Buy Ready Made Trust Wallet Clone And Launch Your Cryptowal...

[MongoDB]

[LoadRunner to JMeter which one should prefer as a Performan...

[Youtube Marketing]

[Benefits of Learning DATABASE MANAGEMENT]

[Types of Database and its Uses]

[RELATIONAL DATABASE MANAGEMENT SYSTEM]

[OBJECT ORIENTED DATABASE]

[TO CREATE RELATIONAL DATABASE FEW STEPS TO FOLLOW]

[Popular Database Software : A Brief Introduction]