Using these tables solve the question :

the question is :

Normalization: Have a UNF table including all related attributes Test it up to 3NF: 1. Remove repeating groups. 2. Remove any partial FDs. 3. Remove any transitive FDs. Include all normalized tables

Data Elements Company : Contains the data of every branch of the company and it's location Department : Contains the data of the departments and in which branch they are Project : Contains the data about the projects and their No and names Staff : Contains the data of every staff in each branch and the projects they work on Employment History : Contains the data about employment history of each employ in each department and when they started and finished their work Dependent : Contains all the data about each staff dependent like their names, their sex , their DOB and their relationship with the staff