7. Given the E-R diagram shown below, give a database schema (ie. list of relati

Question

7. Given the E-R diagram shown below, give a database schema (ie. 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 inres Double lines mean total participation; single line, partial participation. Make sure to give the keys for each relation (primary and foreign). ssn Chairs dname salary building M WorksDepartmentaddress ProfessorW number paame date-sta campus or Offersemester Teaches cname Research Assistant age Course level credits

Explanation / Answer

If you need any help, give me comment...

Professor(ssn: int, pname: string, age: int, salary: real, dname: string, due_start: date);
ProfProjects(ssn: int, project: string);

ReasearchAssistant(ssn:int, raname: string, age: int);
Department(dname:string, addr_building:string, addr_campus:string, addr_number: int, ssn: int);

course(cname: string, level: int, credits: int, dname: string, semester: int);
prof_teches_course(ssn int, cname string);

Related Questions

Navigate

• Browse (All)
• Browse 7
• Subjects

---

---

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