Moving to another question will save this response. Convert this E-R diagram to
ID: 3794615 • Letter: M
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)