Скачать или смотреть MEMBERSHIP TEST IN NORMALISATION . EQUALITY BETWEEN TWO SETS IN NORMALISATION.

IN THIS video we solve problems based on normalization.
when functional dependency of any relation given and in functional dependency there is any dependency like x determine prime attribute .then how to find candidate key . we solve problems based on functional dependency and how to identify candidate key?
in this video , other topic is MEMBERSHIP TEST.

MEMBERSHIP TEST----- Let F be the FD set , x determine y any functional dependency. then x determine y is logically implied in F only if X closure should contain y.

other topic is
EQUALITY OF TWO SETS-------
Let F and G are two functional dependency sets . Then , we have to check
1. F covers G:---- All functional dependency of G are logically implied in F.
2. G covers F:---- All functional dependency of F are logically implied in G.

If 1st true and 2nd false then F is superset of G.
If 1st false and 2nd true then G is superset of F.
If 1st true and 2nd true then F is logically equivalent to G
If 1st false and 2nd is also false then it is non comparable.

link of my videos-
   • what is Relational DBMS? What is Candidate...   ------- this is for what is relational DBMS? WHAT IS CANDIDATE KEY? WHAT IS PRIMARY KEY? WHAT IS ALTERNATIVE KEY AND SUPER KEY?

   • what is normalisation? how to eliminate or...   ------ WHAT IS NORMALISATION ? HOW TO ELIMINATE AND REDUCE REDUNDANCY?

   • INTRODUCTION TO DBMS   ------ INTRODUCTION TO DBMS
   • What is Foreign key? what is Foreign key o...   ------- WHAT IS FOREIGN KEY?
   • What is relational algebra? Introduction o...   ------ WHAT IS RELATIONAL ALGEBRA ? INTRODUCTION OF RELATIONAL ALGEBRA OPERATIONS.