1. What is Functional Dependency? steps to solve functional dependency?  what will the functional dependency and keys for the above entity?

   
   

   
   

   1. Entity name: Employee

   
   

    Attributes:  SSN, Employee ID, Fname, Lname, Start date, Position, Phone number, DOB

   
   

   What will be 

   • Keys: 
   •   Functional dependencies: Left ,both side and right

   
   

   • Attribute closures 
   • Unique keys: 

   2. Entity name: Time sheet

       Attributes: Employee ID, Time sheet ID, Start time, End time, Date

   What will be 

   • Keys: 
   •   Functional dependencies: Left ,both side and right

   
   

   • Attribute closures 
   • Unique keys:

   3.  Entity name: Payment

        Attributes: Payment ID, Order ID, Price, Date

   
   

   What will be 

   • Keys: 
   •   Functional dependencies: Left ,both side and right

   
   

   • Attribute closures 
   • Unique keys: