We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Database Normalization #6
Database Normalization #6
Sort by
recency
|
15 Discussions
|
Please Login in order to post a comment
This is my process of identifying the normal forms:
For 2NF, non-prime attributes must be dependent on CK:
For 3NF, non-prime attributes must be directly dependent on CK, not transitively dependent:
Relationship is in first normal form. serialno,date is candidate key here and proper subset of candidate key is belongs to non prime attribute that is sno-> description,dir. please verify it.
Hi, thank you for sharing this post, its really helpfull . Here i also want to share details about cheapest online shoping site gosaveshop where you can buy mens winter coats on sale and mens winter fashion clothes and all the home accessories from your fashion to home decoring with more than 70% discount.
Answer is 2
This breaks 3NF
description->director,serialno serialno->description serialno->director