Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
DBMS Normalisation
sanyam53
asked
in
Databases
Jan 11, 2017
895
views
3
votes
3
votes
Consider a schema R(A, B, C, D) and functional dependencies {AB → C, C → D, D→ A}. Then the decomposition of R into
R1 (CD), R2 (AC) and R3 (BC) is in
a. 1NF but not 2NF
b. 2NF but not 3NF
c. 3NF but not BCNF
d. BCNF
databases
decomposition
database-normalization
sanyam53
asked
in
Databases
Jan 11, 2017
by
sanyam53
895
views
answer
comment
Follow
share this
share
0 Comments
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
2
Answers
2
votes
2
votes
Every relation with 2 attributes is in BCNF.
Thus, option D
Sushant Gokhale
answered
Jan 14, 2017
by
Sushant Gokhale
comment
Follow
share this
1 comment
by
Sanjay Sharma
commented
Apr 26, 2017
reply
Follow
share this
is every binary relation also in further higher normal forms like in 4nf ,5nf
0
0
Please
log in
or
register
to add a comment.
0
votes
0
votes
After decomposition , Each relation has two attributes.
So it is in BCNF, but Dependency is not preserved.
Arnab Bhadra
answered
May 24, 2017
by
Arnab Bhadra
comment
Follow
share this
0 Comments
Please
log in
or
register
to add a comment.
← Previous
Next →
← Previous in category
Next in category →
Related questions
2
votes
2
votes
2
answers
1
gatecrack
asked
in
Databases
Dec 10, 2018
605
views
Self doubt dbms Normalisation
Is minimal set of functional dependency for a functional dependency set is always unique???
gatecrack
asked
in
Databases
Dec 10, 2018
by
gatecrack
605
views
databases
decomposition
lossless-join
database-normalization
3
votes
3
votes
4
answers
2
KISHALAY DAS
asked
in
Databases
Dec 21, 2016
1,166
views
DBMS-Normalisation-Lossless Join Decomposition
KISHALAY DAS
asked
in
Databases
Dec 21, 2016
by
KISHALAY DAS
1.2k
views
databases
decomposition
database-normalization
lossless-join
0
votes
0
votes
1
answer
3
ROMITDUTTA
asked
in
Databases
Jul 5, 2023
225
views
2NF DECOMPOSITION
ROMITDUTTA
asked
in
Databases
Jul 5, 2023
by
ROMITDUTTA
225
views
databases
database-normalization
decomposition
normal-forms
1
vote
1
vote
0
answers
4
Raj Kumar 7
asked
in
Databases
Dec 24, 2018
1,100
views
Sel doubt
Relation R (A,B,C,D,E,F) Functional dependency: ABC -->DEF, BC-->EF, EF-->D. Decomposition: R1 (ABCDF), R2 (BCDE). Is this decomposition lossy? Is this decomposition preserve functional dependency? Plz explain how to check functional dependency is preserved or not in decomposition.
Raj Kumar 7
asked
in
Databases
Dec 24, 2018
by
Raj Kumar 7
1.1k
views
databases
database-normalization
decomposition
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
Recent Posts
Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes
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:...
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy