Words form picture down below:

Given the dependency diagram, identify each bad relationship as partial transitive. Identify a revised design that elevates it to 2nf. the revised design should list the primary key, forign key (if any), and other atributes in each table.

QUESTION 21 staffNo sName position salary branchNo bAddress SL21 SG37 SG14 SA9 SG5 SL41 John WhiteManager 30000 B005 Ann Beech Assistant12000 B003 David Ford Supervisor 18000 B003 Mary Howe Assistant Susan Brand Manager 24000 B003 Julie Lee 22 Deer Rd, London 163 Main St, Glasgow 163 Main St, Glasgow 16 Argyll St, Aberdeern 163 Main St, Glasgow 22 Deer Rd, London 9000 B007 Assistant9000 Elevate the relation above to 3NF. For each resulting relation, list the primary key, foreign keys (if any) and other attributes