Answer to Question #65035 in Databases | SQL | Oracle | MS Access for Barry Fitzgerald

Question

• Find the student names for all students who are in the BSIT program
• Find the faculty names for all faculty whose rank is associate professor
• Find the faculty names for all faculty who have taught CS251
•
• Assume that we have the followingER Model:
• Student takesCourse; Faculty teachesCourse; Studentis_inProgram
• We can transform all the Entities and Relationships into the following database tables:
• (1) Tables for Entities:
• Student ( Student_idAutoNumber, FNameShortText, LNameShortText)
• Course (Course_idAutoNumber, CNameShortText)
• Faculty(Faculty_idAutoNumber, FNameShortText, LNameShortText, Rank ShortText)
• Program (Program_idAutoNumber,PNameShortText)
• (2) Tables for Relationships:
• teaches(TeachesR_idAutoNumber, Faculty_idNumber, Course_idNumber)
• takes(TakesR_idAutoNumber, Student_idNumber, Course_idNumber)
• is_in(Is_InR_idAutoNumber, Student_idNumber, Program_idNumber)