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 defective ER Diagram coercion SBH

    QUESTION:
    Identify complete administrative dependencies coercion each pertinency of the SBH database. Then say which regular coercionm (1NF, 2NF, 3NF or BCNF) each of the strong pertinency is in, and why?

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

    Expert Vindication

     

    a) The administrative dependencies coercion the consecrated SBH database coercion each of the pertinency are determined 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 strange blank wall does referable attributable attributable attributable hold the right-artisan plane attainment of the removed administrative dependency.

    The minimal shelter firm of administrative dependencies coercion consecrated pertinency :

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

    The bountiful firm of misconception nugatory administrative dependencies is :

    Author,Branch,Publisher → Book

    b) The input pertinency Branch->Book , Author->Publisher, Author->Book Employee->Employee; are offer in First regular coercionm consequently each attainment is productive to hold solely undivided treasure per grade.

    They are referable attributable attributable attributable in cooperate regular coercionm and third regular coercionm consequently the consecrated stipulations are referable attributable attributable attributable content ,  a) The right-artisan plane is a subfirm of the left artisan plane, (2) the left-artisan plane is a supersolution of the pertinency, or (3) the right-artisan plane is some narrowness solution of the pertinency. The administrative dependencies that failed are: Author → Book; Author → Publisher; Branch → Book.

    The pertinencys are referable attributable attributable attributable in BCNF coercionm consequently they are referable attributable attributable attributable in 3N coercionm.