l.Consider the following ER diagram, which shows employees work in ditterent uep

Question

l.Consider the following ER diagram, which shows employees work in ditterent uepaiu Translate this ER diagram into a relational model (a collection of tables). Assume that it is a many-to-one relationship. That means many employees can work in one department, but one employee cannot work in many departments. Show the schemas (definitions of the tables), and clearly mark the keys in the schemas. (20 pts) cleary mark the keys in the schemas the tables), and since name ssn lot did udge "-w )-pepartments Employees orks I

Explanation / Answer

Employee

Ssn(Primary Key)

name

Iot

Departments

Did ( Primary key)

dname

budget

Works_In

Ssn(Primary Key)

Did

Since

Ssn(Primary Key)

name

Iot

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

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