Register

NIELIT 2018-63

• recategorized by
1,460 views
0 votes
0 votes

Identify the true statement from the given statements.

  1. Lossless, dependency-preserving Decompositoin into $3$ NF is always possible
  2. Any relation with two attributes is BCNF
  1. $1$
  2. $2$
  3. $1$ and $2$
  4. None of these
• recategorized by
User Avatar

2 Answers

0 votes
0 votes
Both the statements are true.
(1) TRUE: Lossless, dependency preserving decomposition into 3NF is always possible but not in BCNF. In BCNF lossless is mandatory but dependency preserving is not mandatory.
(ii) TRUE: Any relation with two attributes is in BCNF
User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
2 answers
1
Arjun asked Dec 7, 2018
2,009 views
NIELIT 2018-34
Identify the true statement from the given statements: Number of child pointers in a B/B+ tree node is always equal to number of keys in it plus one B/B+ tree is defined by a term minimum degree. And minimum degree depends on hard disk block size, key and address size (1) (1) and (2) (2) None of these
Identify the true statement from the given statements:Number of child pointers in a B/B+ tree node is always equal to number of keys in it plus oneB/B+ tree is defined by...
User Avatar
2 votes
2 votes
3 answers
2
Arjun asked Dec 7, 2018
968 views
NIELIT 2018-36
______ is NOT a part of the ACID properties Inconsistency Consistency Atomicity Isolation
______ is NOT a part of the ACID propertiesInconsistencyConsistencyAtomicityIsolation
User Avatar
1 votes
1 votes
2 answers
3
Arjun asked Dec 7, 2018
1,368 views
NIELIT 2018-42
____ symbol is used to denote derived attributes in ER model Dashed ellipse Squared ellipse Ellipse with attribute name underlined Rectangular Box
____ symbol is used to denote derived attributes in ER modelDashed ellipseSquared ellipseEllipse with attribute name underlinedRectangular Box
User Avatar
4 votes
4 votes
3 answers
4
Arjun asked Dec 7, 2018
3,694 views
NIELIT 2018-49
The following table has two attributes $X$ and $Y$ where $X$ is the primary key and $Y$ is the foreign key referencing $X$ ... $(4,3)$ and $(6,4)$ $(2,4)$ and $(7,2)$ $(3,2)$ and $(9,5)$ $(3,4), (4,5)$ and $(6,4)$
The following table has two attributes $X$ and $Y$ where $X$ is the primary key and $Y$ is the foreign key referencing $X$ with on-delete cascade.$\begin{array}{|c|c|} \h...
User Avatar
Link Copied!