DBMS - Study24x7
Social learning Network
dbms Cover image
dbms
DBMS
  • Followers
  • Latest Feeds
  • Articles
  • Question
  • Course
  • About
  • Review
Interests
Databases IIT-JEE
Articles
Question
Course
About
Review
Gallery
DBMS
56 followers study24x7 26 Mar 2019 04:44 PM study24x7 study24x7
Boyce-Codd Normal Form (BCNF) | Database Normalization | DBMS:https://youtu.be/NNjUhvvwOrk
Databases
Like | 1 Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 04:43 PM study24x7 study24x7
Normal Form (4NF) | Multi-Valued Dependency | Database Normalizationhttps://youtu.be/OTCuykFHBeA
Databases
Like | 2 Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 04:42 PM study24x7 study24x7
Third Normal Form (3NF) | Database Normalization | DBMShttps://youtu.be/aAx_JoEDXQA
Databases
Like | 1 Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 04:42 PM study24x7 study24x7
Second Normal Form (2NF) | Database Normalization | DBMS https://youtu.be/R7UblSu4744
Databases
Like | 2 Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 04:41 PM study24x7 study24x7
First Normal Form (1NF) | Database Normalization | DBMShttps://youtu.be/mUtAPbb1ECM
Databases
Like Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 04:40 PM study24x7 study24x7
Basic Concept of Database Normalization - Simple Explanation for Beginners
https://youtu.be/xoTyrdT9SZI
Databases
Like Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 04:36 PM study24x7 study24x7
Basic concept of NORMALIZATION | DBMShttps://youtu.be/oylHRgBDfNc
Databases
Like Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 04:34 PM study24x7 study24x7
Functional Dependency and its properties in DBMS in HINDI | DATE BASE MANAGEMENT SYSTEMhttps://youtu.be/qn5neFBpU40
Databases
Like Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 04:33 PM study24x7 study24x7
functional dependency in dbmshttps://youtu.be/X3c1phdyjbU
Databases
Like Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 04:31 PM study24x7 study24x7
Closure Set of Attributes in DBMS in HINDI | How to find Closure Of Attributes algorithmhttps://youtu.be/fT0QMtgqPrU
Databases
Like Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 04:31 PM study24x7 study24x7
Functional Dependency Practice Problems with solutions in HINDI example exercise solutionhttps://youtu.be/y8XuGhEdslM
Databases
Like Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 04:30 PM study24x7 study24x7
Functional Dependency in DBMS in HINDI | DATE BASE MANAGEMENT SYSTEMhttps://youtu.be/wez3fXrjBAE
Databases
Like Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 02:39 PM study24x7 study24x7

Types of Functional Dependencies :
Trivial functional dependency
non-trivial functional dependency
Multi-valued dependency
Transitive dependency

Databases
Like Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 02:36 PM study24x7 study24x7

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....

See more

Databases
Like Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 11:08 AM study24x7 study24x7

Normalization :

Normalization.pdf
0 Downloads
Databases
Like Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 11:00 AM study24x7 study24x7

Boyce Codd normal form (BCNF): It is an advance version of 3NF that’s why it is also referred as 3.5NF. BCNF is stricter than 3NF. A table complies with BCNF if it is in 3NF and for every functional dependency X->Y, X should be the super key of the table.

Databases
Like Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 11:00 AM study24x7 study24x7

Third Normal form (3NF) :A table design is said to be in 3NF if both the following conditions hold:


Table must be in 2NF
Transitive functional dependency of non-prime attribute on any super key should be removed.
An attribute that is not part of any can...

See more

Databases
Like Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 10:50 AM study24x7 study24x7

Second normal form (2NF) :A table is said to be in 2NF if both the following conditions hold:
Table is in 1NF (First normal form)
No non-prime attribute is dependent on the proper subset of any candidate key of table.
An attribute that is not part of any candidate key is...

See more

Databases
Like Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 10:49 AM study24x7 study24x7

First normal form (1NF) :
As per the rule of first normal form, an attribute (column) of a table cannot hold multiple values. It should hold only atomic values.


Example: Suppose a company wants to store the names and contact details of its employees. It creates a ta...

See more

Databases
Like Comment Share
study24x7
Write a comment
DBMS
56 followers study24x7 26 Mar 2019 10:46 AM study24x7 study24x7

Normalization :
Here are the most commonly used normal forms:
First normal form(1NF)
Second normal form(2NF)
Third normal form(3NF)
Boyce & Codd normal form (BCNF)

Databases
Like Comment Share
study24x7
Write a comment
About
Ratings
5.0
out of 5 4 Ratings
5 study24x7
 
4.0
4 study24x7
 
0.0
3 study24x7
 
0.0
2 study24x7
 
0.0
1 study24x7
 
0.0
Related Pages
❮ ❯