Transitive Dependency and Intransitive Dependency in 3NF.

Varun Raj Akula asked in Databases Mar 12, 2022 edited Jul 2, 2022 by Varun Raj Akula

386 views

0 votes

Can anyone please explain about Statement 4 ? I know that transitive dependencies are allowed in 3NF as long as RHS is Prime Attribute. But, what is intransitive dependency. What is the role of it in 3NF?

database-normalization

Varun Raj Akula asked in Databases Mar 12, 2022 edited Jul 2, 2022 by Varun Raj Akula

by Varun Raj Akula

386 views

0 Comments

Please log in or register to add a comment.

Please log in or register to answer this question.

0 Answers

← Previous Next →

← Previous in category Next in category →

Related questions

0 votes

0 answers

Harsh Kumar asked in Databases Sep 15, 2018

624 views

Normalization - transitive dependency
In the books, it is written that a transitive dependency is one in which a non-key attribute is determining another non-key attribute. So, if ${R (A,B,C,D,E,F)}$ be a relation and ${ABC}$ ... about those dependencies in which the LHS is a combination of key and non-key attributes ? for example, what about ${ABD \to E}$ ?

Harsh Kumar asked in Databases Sep 15, 2018

by Harsh Kumar

624 views

database-normalization

4 votes

1 answer

learncp asked in Databases Dec 16, 2015

877 views

What is the best way to check for 3nd, BCNF, partial and transitive and partial dependencies ?
I am revising DBMS for the GATE exam... Often I find it confusing that which dependency should be considered as partial , which should be considered as transitive..due to which my deductions about the ... give me a resource from where I can learn about this clearly and get my doubts cleared . Thanks

learncp asked in Databases Dec 16, 2015

by learncp

877 views

databases
database-normalization

1 vote

1 answer

radha gogia asked in Databases Sep 25, 2018

2,249 views

Why 3NF is inadequate in below situations ?
Why 3NF is inadequate in situations where the relation: 1) has multiple candidates key 2) has candidate key that are composite 3) has overlapped candidate keys . Example needed , I could justify a bit for point 3 where there may be partial FD's present in case we have candidate key that are composite , but I am not sure

radha gogia asked in Databases Sep 25, 2018

by radha gogia

2.2k views

databases
database-normalization

1 vote

2 answers

GateAspirant999 asked in Databases Nov 12, 2016

595 views

Finding if decomposition is in 3NF
Consider the relation $R(A,B,C,D,E)$ with $FD\{ A\rightarrow C, D\rightarrow CE\} $. Which of the following decomposition is in 3NF? (A) $R_1(A,C); R_2(B,E); R_3(A,B,D)$ (B) $R_1(A,C); R_2(D,C,E); R_3(A,B,D)$ (C) Already is in 3NF (D) None of these

GateAspirant999 asked in Databases Nov 12, 2016

by GateAspirant999

595 views

databases
database-normalization

Subscribe to GATE CSE 2024 Test Series

Subscribe to GO Classes for GATE CSE 2024

Quick search syntax

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true

Subjects

All categories
General Aptitude (3.5k)
Engineering Mathematics (10.4k)
Digital Logic (3.6k)
Programming and DS (6.2k)
Algorithms (4.8k)
Theory of Computation (6.9k)
Compiler Design (2.5k)
Operating System (5.2k)
Databases (4.8k)
CO and Architecture (4.0k)
Computer Networks (4.9k)
Artificial Intelligence (79)
Machine Learning (48)
Data Mining and Warehousing (25)
Non GATE (1.4k)
Others (2.7k)
Admissions (684)
Exam Queries (1.6k)
Tier 1 Placement Questions (17)
Job Queries (80)
Projects (11)
Unknown Category (870)

64.3k questions

77.9k answers

244k comments

80.0k users

Recent Blog Comments

category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...

Send feedback
Rank Predictor
College Prediction
Useful Links
FAQ
Corrections
Discuss
Copyright
Request
Testimonials
Chat Logs
Chat
Badges
Search tips
Exam Category
Blog Category
Blog Tags
Privacy
Test Series
GATER
Refund Policy
Terms and Conditions
Contact Us

Developed by Chun