Question

ClientID Name IName Phone C707 Jhony Irving 347-123-9899 C747 Riya Riply 718-321-8989 C787 Michael Jay 516-213-8899 C777 Layla Cool 613-919-2002 Street City ZIP Gender 187 NY 1001 M 199 PA 1002 F 202 LA 1003 M 105 AZ | 1004 F

• List the functional dependencies
• Is it in 1NF? Why? If it is not, normalize it to 1NF.
• Is it in 2NF? Why? If it is not, normalize it to 2NF.
• Is it in 3NF? Why? If it is not, normalize it to 3NF.

Answer 1

Dear Student ,

As per requirement submitted above kindly find below solution.

• Given table client is in the First Normal Form (1NF)
  • Because all columns in the table are atomic in nature
  • This means each row in the table has same number of columns
  • Also this table does not contains any duplicate column or multivalued column
  • This means a single column does not have more than one value
  • In the given table ClientID is the primary key.

NOTE :PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.