Try to map the ER and EER schema of Figure 8.7 into a relational schema. State...

 

Transcribed Image Text:

Try to map the ER and EER schema of Figure 8.7 into a relational schema. State any assumptions you make if you have. STAFF Position Salary Name Ssn EMPLOYEE Rank FACULTY Sex Project PERSON ALUMNUS Degrees Year Degree Major Percent_time Address STUDENT ASSISTANT Birth_date Major_dept STUDENT GRADUATE STUDENT Degree program Course RESEARCH ASSISTANT TEACHING ASSISTANT Figure 8.7 A specialization lattice with multiple inheritance for a UNIVERSITY database. UNDERGRADUATE STUDENT Class Try to map the ER and EER schema of Figure 8.7 into a relational schema. State any assumptions you make if you have. STAFF Position Salary Name Ssn EMPLOYEE Rank FACULTY Sex Project PERSON ALUMNUS Degrees Year Degree Major Percent_time Address STUDENT ASSISTANT Birth_date Major_dept STUDENT GRADUATE STUDENT Degree program Course RESEARCH ASSISTANT TEACHING ASSISTANT Figure 8.7 A specialization lattice with multiple inheritance for a UNIVERSITY database. UNDERGRADUATE STUDENT Class

Answer rating: 100% (QA)

The relational schema can be designed in various formats The question specified did not specify in w... View the full answer