Please enable JavaScript.

Coggle requires JavaScript to display documents.

Database Normalization - Coggle Diagram

- - - - User and Role both in same table. To resolve this we should create two separate table and link both of them with foreign key relationship
        
        Easy Language we can say any non-prime attribute fully doesn't depend on primary key put them in new table and link them
  - - - Transitive dependency occurs when an attribute depends on another attribute that is not its primary key but depends on a different attribute that is part of the primary key.
        
        Suppose you have a relation R with attributes (A, B, C, D) and functional dependencies: 1. A → B (A determines B) , 2. B → C (B determines C), 3. A → D (A determines D)
        
        Decompose into R1 (A, B, C)
        
        R2 (A, D)
  - - - Suppose you have a relation R with attributes (A, B, C, D) and functional dependencies: 1. A → B (A determines B) , 2. B → C (B determines C), 3. A → D (A determines D)
        
        R1 (A, B)
        
        R2 (B, C)
        
        R2 (A, D)
  - - - 1.Each piece of information (like a textbook) is stored in one place, not repeated all over the database
      - 2.There are clear and straightforward connections between the courses and their textbooks.