Functional Dependecies :

Project Number -> Project Name

Employee Number -> Employee Name,Job Class

Project Number,Job Class -> Charge/Hour, Hours Build

Charge/Hour, Hours Build -> Total Hours

So here,

Part a)

Partial Dependency : Partial Dependency is that , if a relation x -> y than y is depedennt on the part of x not on the full combination of x. Where x is super key or candidate key.

So in the given example Project Name depend Upon Project Number

and Employee Name, Job class depends upon Employye Number.

But according to given schema the candidate key is (Projcet No, Employee No.)

So the above two defined relations, they are depend upon part of candidate key, not on the full candidate key.

So , on the above relations partial dependency exist.

Transitive Dependency : Transitive dependency is that if x -> y and y -> z than x -> z.

So in given relation

Project Name is deopend on Project Number i.e Project Number -> Project Name

Employee Name, Job class depends upon Employye Number. i.e. Employee Number ->

Employee Name, Job Class

But Project Number,JobClass -> Charge/Hour, Hours Build

So there exist Employee Number -> Job Class and Job Class -> Charge/Hour, Hours Build

So also Employee Number -> Charge/Hour, Hours Build

that leads to transitive dependency.

Part b)

Multivalued Dependecy : Multivalued Dependency is that where more than value are present for one record.

So in this there are multiple record of same employees.For e.g. In same table employye number 105 come two times with same details of Emoloyee Name and Job Class.

That leads to Multivalued Dependency.

Part c)

From above the generated candidate key is:

{Projecrt Number , Employee Number }⁺ -> {Projecrt Number ,Project Name, Employee Number ,Employee Name, Job Class, Charge/Hour, Hours Build , Total Hours}

One more keys is there : {Projecrt Number , Employee Number, Job Class}

{Projecrt Number , Employee Number, Job Class }⁺ -> {Projecrt Number ,Project Name, Employee Number ,Employee Name, Job Class, Charge/Hour, Hours Build , Total Hours}

PROJECT NAME EMPLOYEE TOTAL CHARGE NUMDER NUMBER EMPLOYEE NAME BILLED 037.00 Evergreen Anne K. RamorasSystems Analyst Darlene M. Smithson DSS Analyst Amber Wave $105.00 Anne K. Ramoras Delbert K Joenbrood Applications Designer Rolling Tide Travis B. Bawangi John G. News* Ralph B. Washington Systems Analyst Darlene M. Smithson DSS Analyst Applications Designer Starflight