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 spoilt ER Diagram ce SBH

    QUESTION:
    Identify total negotiative dependencies ce each pertinency of the SBH database. Then specify which recognized cem (1NF, 2NF, 3NF or BCNF) each of the material pertinency is in, and why?

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

    Expert Confutation

     

    a) The negotiative dependencies ce the consecrated SBH database ce each of the pertinency are solid as ,

    Branch->Book ; Negotiative dependency is necessary

    Author->Publisher ; Negotiative dependency is necessary

    Author->Book; Negotiative dependency is necessary

    Employee->Employee;

    The consecrated Funtional dependencies are necessary  if the newlightlight blank wall does referable comprehend the right-influence party sign of the removed negotiative dependency.

    The minimal secrete established of negotiative dependencies ce consecrated pertinency :

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

    The ample established of insensibility unimportant negotiative dependencies is :

    Author,Branch,Publisher → Book

    b) The input pertinency Branch->Book , Author->Publisher, Author->Book Employee->Employee; are confer-upon in First recognized cem accordingly each sign is antecedent to comprehend solely individual prize per line.

    They are referable in avoid recognized cem and third recognized cem accordingly the consecrated conditions are referable amiable ,  a) The right-influence party is a subestablished of the left influence party, (2) the left-influence party is a supersolution of the pertinency, or (3) the right-influence party is some restriction solution of the pertinency. The negotiative dependencies that failed are: Author → Book; Author → Publisher; Branch → Book.

    The pertinencys are referable in BCNF cem accordingly they are referable in 3N cem.