7. Given the E-R diagram shown below, give a database schema (i.e. list of relat

Question

7. Given the E-R diagram shown below, give a database schema (i.e. list of relations) for it. The keys of each entity are shown in quotes. Research Assistant is a weak entity. Projects is a multivalued attribute in Professor Double lines mean total participation; single line, partial participation. Make sure to give the keys for each relation (primary and foreign). ssn Chairs dname bualdang salary Works Professor M- / We address number paame date-sta campus Vor Offery-- semester Teaches Research Assistant age Coursc level credits

Explanation / Answer

For Professor

Primary key- ssn

Foreign keys- raname,cname,dname

For Research Assistant

Primary key- raname

For Course

Primary key- cname

Foreign key- ssn

For Department

Primary key- dname

Foreign key- ssn,cname

Related Questions

Navigate

• Browse (All)
• Browse 7
• Subjects

---

---

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