Only answer 10.21 =) Consider the relation schema EMP_DEPT in Figure 15.3 (a) an

Question

Only answer 10.21 =)

Consider the relation schema EMP_DEPT in Figure 15.3 (a) and the following set G of functional dependencies on EMP_DEPT: G={San rightarrow {Ename, Bdate, Address, Dnumber}, Dnumber rightarrow {Dname, Dmgr_ssn}}. Calculate the closures {Ssn}^+ and {Dnumber}^+ with respect to G. Is the set of functional dependencies G in Exercise 10.20 minimal? If not, try to find a minimal set of functional dependencies that is equivalent o G. Prove that your set is equivalent to G. Two relation schemas suffering from update anomalies.

Explanation / Answer

the given functional dependencies are not minimal.

Ssn->dnum

Ssn->name,bdate,address,

Dnum->dmngrssn

Dnum->dname

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

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