Homework Solution: Employee Branch Publisher Holds Work-shift Author Book Figure 1: Sample incomplete ER Diagram for SBH…

    Employee Branch Publisher Holds Work-shift Author Book Figure 1: Sample incomplete ER Diagram for SBH QUESTION: Identify all functional dependencies for each relation of the SBH database. Then state which normal form (1NF, 2NF, 3NF or BCNF) each of the existing relation is in, and why?
    Employee Branch Publisher Holds Work-shift Author Book Figure 1: Sample incomplete ER Diagram for SBH

    Expert Answer

     
    a) The functional dependencies for the given SBH database for each of the relation are determined as ,

    Employee Branch Publisher Holds Work-shift Author Book Figure 1: Sample meagre ER Diagram control SBH

    QUESTION:
    Identify complete administrative dependencies control each affinity of the SBH database. Then particularize which usual controlm (1NF, 2NF, 3NF or BCNF) each of the existing affinity is in, and why?

    Employee Branch Publisher Holds Work-shift Author Book Figure 1: Sample meagre ER Diagram control SBH

    Expert Exculpation

     

    a) The administrative dependencies control the consecrated SBH database control each of the affinity are fast as ,

    Branch->Book ; Administrative dependency is necessary

    Author->Publisher ; Administrative dependency is necessary

    Author->Book; Administrative dependency is necessary

    Employee->Employee;

    The consecrated Funtional dependencies are necessary  if the odd seclusion does referable attributable attributable attributable comprise the right-laborer edge indication of the removed administrative dependency.

    The minimal overspread firm of administrative dependencies control consecrated affinity :

    F_min { Author->Book, Publisher ; Branch->Book }

    The unmeasured firm of misapprehension trifling administrative dependencies is :

    Author,Branch,Publisher → Book

    b) The input affinity Branch->Book , Author->Publisher, Author->Book Employee->Employee; are introduce in First usual controlm consequently each indication is conducive to comprise solely individual estimate per tier.

    They are referable attributable attributable attributable in remedy usual controlm and third usual controlm consequently the consecrated stipulations are referable attributable attributable attributable satisfied ,  a) The right-laborer edge is a subfirm of the left laborer edge, (2) the left-laborer edge is a superguide of the affinity, or (3) the right-laborer edge is some insufficiency guide of the affinity. The administrative dependencies that failed are: Author → Book; Author → Publisher; Branch → Book.

    The affinitys are referable attributable attributable attributable in BCNF controlm consequently they are referable attributable attributable attributable in 3N controlm.