Moving to another question will save this response. Convert this E-R diagram to

Question

Moving to another question will save this response. Convert this E-R diagram to relations, resolving the dual use of the attribute "ID" in some reasonable way. Then identify which of the database schemas below is the most reasonable translation from the E-R diagram above into relations? Employees(ID, ssn, Name, dateOFBirth, age), Departments(ID, dname, location, budget), Works(empID, dpteID) Employees(ID, ssn, Name, dateOFBirth, age), Departments(ID, dname, location, budget, empID) Employees(ID, ssn, Name, dateOFBirth, age), Departments(ID, dname, location, budget), Works(empID, dpteID) Employees(ID, ssn, Name, dateOFBirth, age), Departments(ID, dname, location, budget, empID)

Explanation / Answer

Option 3)

Employees(ID, ssn, firstName, lastName, dateOfBirth), Departments(ID, dname, location, budget), Works(empID,dpteID)

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

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