• 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)
Numbers and figures are an essential part of our world, necessary for almost everything we do every day. As important…
APPROVED BY CLIENTS
"assignmentexpert.com" is professional group of people in Math subjects! They did assignments in very high level of mathematical modelling in the best quality. Thanks a lot
Comments
Leave a comment