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!


No comments. Be first!

Leave a comment

Ask Your question

New on Blog