We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. Databases
  3. Database Normalization
  4. Database Normalization #7
  5. Discussions

Database Normalization #7

  • elscili444_code
     + 0 comments
    movie(DESCRIPTION,serialno)
description->director,serialno
serialno->description

serial(SERIALNO,director)
serialno->director

customer(name,addr,MEMBERNO)
name,addr -> memberno
memberno -> name,addr

borrow(memberno,DATE,SERIALNO)
serialno,date -> memberno

    1NF valid 2NF valid 3NF valid BCNF <=> A->B were A not CANDIDATE KEY, even though name,addr -> memberno in customer looks invalid by the complementary axiom we have that name, addr is actually a key of customer!