Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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

1 answer below »
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.
Answered 23 days After Jun 13, 2022

Solution

Arun Shankar answered on Jul 07 2022
85 Votes
The functional dependencies are shown below :-
ProjName → ProjStartDate ProjName
ProjType → Priority, ProjBudget ProjTeam,
PersonName → PersonRole PersonName → PersonContact, PersonSkill
Priority → ProjBudget
ProjName → ProjStartDate ProjName
ProjType → Priority, ProjBudget...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Attach File