Sign Up

Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Please type your username.

Please type your E-Mail.

Please choose the appropriate section so the question can be searched easily.

Please choose suitable Keywords Ex: question, poll.

Please choose an appropriate title for the question so it can be answered easily.

Sign InSign Up

IGNOU Answers

IGNOU Answers Logo IGNOU Answers Logo
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Categories
    • All Questions
    • Commerce
    • Computer Science
    • Economics
    • English
    • General Queries
    • Political Science
    • Public Administration
    • Psychology
    • Sociology
    • Others
  • Tags
  • Users
  • Contact Us
Home/ Questions/Q 248
Next
In Process
Adv
vishal_19_official
  • 0
vishal_19_official
Asked: December 14, 20192019-12-14T20:57:00+05:30 2019-12-14T20:57:00+05:30In: Computer Science

Justify “Any relation which is in BCNF is in 3NF but converse is not true”.

  • 0
Justify “Any relation which is in BCNF is in 3NF but converse is not true”.
  • 1 1 Answer
  • 0 Followers
  • 0
  • Share
    Share
    • Share on Facebook
    • Share on Twitter
    • Share on LinkedIn
    • Share on WhatsApp

1 Answer

  • Voted
  • Oldest
  • Recent
  1. admin
    2019-12-15T16:02:20+05:30Added an answer on December 15, 2019 at 4:02 pm

    Consider the schema and functional dependency set of Empdept given below:

    Empdept (emp# ,Dept#, Manager#, Dept_Name , Dept_Loc)

    Emp#Dept#  manager# manager#  Dept #

    Normalisation:

    1st normal form: the relion is already in 1nf as each cell is single valued.

    2nd Normal form: A relation is in second normal form if it is 1NF and every non key attribute is fully dependent on each candidate key of the relation. Thus R is also in 2NF.

    3rd Normal form: A relation is in second normal form if it is 2NF and every non key attribute is non-transitively dependent on each candidate key of the relation. This above relation is in 3NF as every non key attribute is non-transitively dependent on each candidate key of the relation.

    Here primary key is emp# and candidate key is (emp# ,Dept#, Manager#)

    BCNF Normal form: A relation is in second normal form if it is 3NF and if X->A in R and A is not in X, then X is a candidate key. The above relations satisfy this condition.

    The above relation is not in BCNF as in Fd manager#  Dept # , dept# is dependent on manager# but manager#is not in candidate key.

    • 0
    • Reply
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
Leave an answer

Leave an answer
Cancel reply

Browse

Sidebar

Ask A Question

Stats

  • Questions 319
  • Answers 318

Related Questions

  • calculate Physical address is CS=3560H and IP=101AH and SS=2067H and ...

  • Give any one example of a Mobile APP using which ...

  • Please provide us Solved Assignments of BCSL-063 2020-21

  • Please solved assignments of BCS040, BCS041, BCS042, MCS024, BCSL043, BCSL044, ...

  • Explain the process of designing a secure e commerce portal

  • Popular
  • Answers
  • Anonymous

    I need MCS-014 Assignment solution. ...

    • 14 Answers
  • himanshu

    i want answers of assignment ...

    • 11 Answers
  • Anonymous

    Can anyone provide answers of ...

    • 8 Answers
  • Vandana

    Calculate the physical address ...

    • 6 Answers
  • Anonymous

    What does the IGNOU BCA ...

    • 6 Answers
  • admin
    admin added an answer Just click on the image to see in full screen. April 29, 2022 at 1:42 pm
  • Fyor
    Fyor added an answer I wanna see first photo in full size because below side is missing. Can you send me? April 29, 2022 at 1:41 pm
  • admin
    admin added an answer Puritans opposed to drama during the Jacobean drama age. They were one of the reasons behind the decline of drama in the age of John Webster. They had been opposing… April 29, 2022 at 1:24 pm
  • admin
    admin added an answer A true Christian can only be awarded by divine and never failing judgement or by Christ himself. In St. Peter’s words on Christian speech, Milton made changes effectively. It suggests… April 29, 2022 at 1:17 pm
  • admin
    admin added an answer Tragedy requires a tragic hero who generally performs deeds after which the hero luck suffers a decline and resulted to death. The tragedy is a mixed composition of corrupt characters… April 29, 2022 at 1:12 pm

Top Members

admin

admin

  • 2 Questions
  • 1k Points
Pooja Sharma

Pooja Sharma

  • 7 Questions
  • 39 Points
Roushani Kumari

Roushani Kumari

  • 1 Question
  • 34 Points

Trending Tags

Free Assignments Free Solved Assignments IGNOU BCA Solved Assignments IGNOU BCOM Solved Assignments

Explore

  • Home
  • Categories
    • All Questions
    • Commerce
    • Computer Science
    • Economics
    • English
    • General Queries
    • Political Science
    • Public Administration
    • Psychology
    • Sociology
    • Others
  • Tags
  • Users
  • Contact Us

Footer

IGNOU Answers

About

IGNOU Answers is a social Questions & Answers platform which will help you to find answers to your questions..

Question Tags

BA Sociology ESO-11 Export Procedures and Documentation fst-01 International Business Finance ma psychology mpc-004 mpc-005 question The Study of Society

Categories

  • Commerce
  • Computer Science
  • Economics
  • English
  • General Queries
  • Others
  • Political Science
  • Psychology
  • Public Administration
  • Science
  • Sociology

Useful Links

  • Home
  • Contact Us
  • Privacy Policy
  • Buy Assignments
  • IGNOU Updates

© 2021 IgnouAnswers.com. All Rights Reserved
Created With Love by KHOJINET.

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.