64 634
Assignments Done
99,2%
Successfully Done
In September 2018

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

Question #65035
• 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)
Expert's answer

Not answered

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions