a) Consider the following functional dependencies of a PROJECT database. ProjName → ProjStartDate ProjName, ProjType → Priority, ProjBudget ProjTeam, PersonName → PersonRole PersonName →...

a) Consider the following functional dependencies of a PROJECT database. ProjName → ProjStartDate ProjName, ProjType → Priority, ProjBudget ProjTeam, PersonName → PersonRole PersonName → PersonContact, PersonSkill Priority → ProjBudget Currently, the database is implemented in UNF as follows. PROJECT (ProjName, ProjStartDate, Priority, ProjType, ProjBudget, (ProjTeam, ProjTeamLeader, (PersonName, PersonRole, PersonContact, PersonSkill))) You need to normalize the PROJECT un-normalized form to arrive at a suitable database design, which satisfies the third normal form. Clearly show your transformation stages and state assumptions whenever necessary.