Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Recent questions tagged 2nf
2
votes
2
answers
1
Function Dependency question
Consider a relation R(A,B,C,D,E,F,H) with A as the only key. Assume that the dependencies E->F and C-> DEH hold.on R. 1. Is R in 2NF? If not, decompose to 2NF. 2. is R in 3NF? if not, decompose to 3NF. //What does " with A as the only key" mean ?
Consider a relation R(A,B,C,D,E,F,H) with A as the only key. Assume that the dependencies E->F and C- DEH hold.on R.1. Is R in 2NF? If not, decompose to 2NF.2. is R in 3N...
karthikmenon
1.0k
views
karthikmenon
asked
Jun 23, 2018
Databases
database-normalization
databases
decomposition
2nf
bcnf-decomposition
+
–
1
votes
0
answers
2
Nmber of relation in 2NF
Question asked to find minimum number of tables required. My question is how can we decide the table's unless cardinality ratio is given ?
Question asked to find minimum number of tables required.My question is how can we decide the table's unless cardinality ratio is given ?
junaid ahmad
228
views
junaid ahmad
asked
Dec 1, 2017
Databases
2nf
databases
+
–
3
votes
2
answers
3
2NF decomposition
How is it option D??
How is it option D??
Parshu gate
3.5k
views
Parshu gate
asked
Nov 19, 2017
Databases
database-normalization
2nf
databases
decomposition
+
–
5
votes
3
answers
4
normalisation 2nf
The Second Normal Form states that it should meet all the rules for 1NF and there must be no partial dependences of any of the columns on the primary key , so i have doubt regarding this if a prime attribute determines another prime attribute in a separate functional dependency then still is this 2nf or not? I'm confuse little bit , please help me . thanks in advance
The Second Normal Form states that it should meet all the rules for 1NF and there must be no partial dependences of any of the columns on the primary key , so i have doub...
skyby
1.0k
views
skyby
asked
Jul 30, 2017
Databases
database-normalization
2nf
+
–
To see more, click for the
full list of questions
or
popular tags
.
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register