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)

Login

Water insoluble enzymes can be prepared by using multifunctional agents that are bifunctional in nature and have

——- is not a data mining functionality?

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 _________

HBaseAdmin and ____________ are the two important classes in this package that provide DDL functionalities.

If every non-key attribute is functionally dependent on the primary key, then the relation will be in :

Functional managers are responsible ______________

Example of functional testing

Functional testing is a ------?

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

Binance Exchange Clone script — A Perfect Solution To Ente...

Role Of Blockchain in Industries

What are some key features and functionalities included in t...

Buy Ready Made Trust Wallet Clone And Launch Your Cryptowall...

Liver transplant cost in India

LoadRunner to JMeter which one should prefer as a Performanc...

Youtube Marketing

Why did you choose Software Testing as a career?

Benefits of Learning DATABASE MANAGEMENT

Types of Database and its Uses