GATE CSE
First time here? Checkout the FAQ!
x
+1 vote
40 views
AB---->B

AC---->C

C------>B

 

Highiest normal form?
asked ago in Databases by (45 points) 1 | 40 views

It is in 1NF, not in 2NF.

AC is a candidate key, it can determine all A, B, and C.

The non-prime attribute will be B.

Which can be determined by the subset of the candidate key.

C $\rightarrow$ B

Not in 2NF.

@Hemant Parihar which form it is:-

{Prime, Non Prime} -> Non Prime.

Like,

AB---->B

I  think it should be 1NF.

ryt??

@Shubhanshu

If this is the only functional dependency then it is BCNF.

AB -> B (trivial).
This is trival fd but my point of u it should be in1 nf... Bacause if we minimize the fd it remain same...

1 Answer

0 votes

my answer

answered ago by Boss (8k points) 6 41 119

Related questions

+1 vote
0 answers
1
asked in Databases by Meenakshi Sharma Loyal (4.2k points) 6 40 79 | 20 views
0 votes
1 answer
3
asked in Databases by Nikhil Kumar Som (133 points) 1 3 7 | 40 views


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
Top Users Oct 2017
  1. Arjun

    23396 Points

  2. Bikram

    17078 Points

  3. Habibkhan

    8158 Points

  4. srestha

    6286 Points

  5. Debashish Deka

    5438 Points

  6. jothee

    4978 Points

  7. Sachin Mittal 1

    4772 Points

  8. joshi_nitish

    4344 Points

  9. sushmita

    3964 Points

  10. Rishi yadav

    3804 Points


Recent Badges

Great Question jothee
Notable Question Priyanka23
Great Question khushtak
Good Question Ishrat Jahan
Good Answer Arjun
Revival Arjun
Nice Question Kathleen
Nice Answer janakyMurthy
Renewal janakyMurthy
Renewal Bikram
27,316 questions
35,169 answers
84,075 comments
33,262 users