Register

DATABASE

445 views
0 0 votes

A table R is in 3NF if whenever a nontrivial functional dependency X-->A holds in R then X and A must satisfy which condition?

2 Answers

0 0 votes

https://en.wikipedia.org/wiki/Third_normal_form

 a table is in 3NF if and only if, for each of its functional dependencies X → A, at least one of the following conditions holds:

  • X contains A (that is, X → A is trivial functional dependency), or
  • X is a superkey, or
  • Every element of A-X, the set difference between A and X, is a prime attribute (i.e., each attribute in A-X is contained in some candidate key)
Voting & Accepting an answer helps improve the community
← Previous · DATABASENext → · DATABASE
← Previous in category · DATABASENext in category → · DATABASE
Position:
Show:

Related questions

0 0 votes
0 0 answers
113
113 views
krishna_panjiyar 1 asked Jul 27
113 views
Fundamentals of Database Systems, Ramez Elmasri
Design an ER schema for keeping track of information about votes taken in the U.S. House of Representatives during the current two-year congressional session. The databas...
0 0 votes
0 0 answers
283
283 views
GO Classes asked Feb 17
283 views
GATE DA 2026 | Database Management & Warehousing | Memory Based | Question 65
Find correct query for counting Teamsize.SQL Query $1$ SQL Query $2$ SQL Query $3$ SQL Query $4$  
1 1 vote
0 0 answers
266
266 views
GO Classes asked Feb 17
266 views
GATE DA 2026 | Database Management & Warehousing | Memory Based | Question 64
Consider two relations $R$ and $S$ with attributes $p$ and $s$.The following tuple relational calculus (TRC) query is given:\[\{\, t \mid t \in R \ \land\ (\exists z \in...
0 0 votes
0 0 answers
235
235 views
GO Classes asked Feb 17
235 views
GATE DA 2026 | Database Management & Warehousing | Memory Based | Question 63
Relational Algebra Question.The query was like, $\pi (\sigma\dots\bowtie\dots)\bowtie(\sigma\dots\bowtie\dots)$Asking : no. of tuples in output.zero tuple one tuple two t...