1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

BCNF question

Discussion in 'Database' started by Assi9, Oct 21, 2009.

  1. Assi9

    Assi9 New Member

    Hello friends. I come to you with another noob-level question. You see I've never normalised any table up to BCNF. I have drawn up some tables for my assignment, could you help me normalise them to BCNF, please? Here are just two of them:

    Lecturer(Lecturer_ID, Date_Hired)
    Consultant(Consultant_ID, Full_Name, Address, Phone, Hourly_Rate)

    Please, please help.
     
  2. nimesh

    nimesh New Member

    Isn't there any connection between the two tables?
    I mean can a consultant be a lecturer? or vice-versa?
     
  3. Assi9

    Assi9 New Member

    Oh, hi Nimesh! How are you doing? Once again you save me. Well, Lecturer and Consultant aren't related. Consultant actually refers to external consultants who have participated in administrative projects by the college. Those two tables are part of many more entities. Consultant is actually related to Admin_Project while Lecturer is related to the Academic_Department entity.
     
  4. nimesh

    nimesh New Member

    These look pretty simple ones, I don't see any issue for not being in BCNF form.
     
  5. Assi9

    Assi9 New Member

    Thanks again Nimesh!
     
  6. nimesh

    nimesh New Member

    :welcome:
     

Share This Page