a. Identify and list all functional dependencies (both partial dependencies and

Question

a. Identify and list all functional dependencies (both partial dependencies and transitive dependencies) and provide your justifications or assumptions for the dependencies (15 points) amine the data provided. Identify and list any multivalued dependencies that you may find. How many multivalued dependencies are present? Provide your justifications or (5 points) identified. b. Ex assumptions for the dependencies identified. List all candidate keys Based on your answers in a), b) and c), cast the data provided to INH. c. (5 points) e. Based on your answers in d), normalize the relations to 2NF. Provide justification/s or (10 points) f. Based on your answers in e), normalize the relations to 3NF. Provide justification/s or (10 points) d. assumptions for each step in your normalization process. assumptions for each step in your normalization process.

Explanation / Answer

Answer is as follows :

According to the Chegg Guidelines, We are allowed to answer only first three parts, so please repost others.

Functional Dependecies :

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}

if there is any query please ask in comments...

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.