Create 3 threads - one thread per case. Name it with the name of violation, as in "1NF Violation", or "2NF Violation", or "3NF Violation"
Do not resolve your own cases.
A. Create 3 threads each one provide example according to the condition below.Â
   1. Case 1 - Violation of 1NF - give example of a relation that has repeating groups.Â
         For example if I am posting case 1, I will create a thread "Violation of 1NF" and give this relation:
               Orders (Ordernum, Orderdate, (PartNum, NumOrdered, Price))
   2. Case 2 - Violation of 2NF - give example of a relation that has partial dependency
          For example if I am posting case 2, I will create a thread "Violation of 2NF" and give this relation:
            (Ordernum, Orderdate, PartNum, PartDescription, NumOrdered, Price) with dependency PartNum -> PartDescription among others
   3. Case 3 - Violation of 3NF - give example of a relation that has transitive dependency
          For example if I am posting case 3, I will create a thread "Violation of 3NF"and give this relation:
           (Customer, CustomerName, CreditLimit, RepNum, RepName) where dependency RepNum->RepName exists