Written Assignment (Homework) #2(10-point) Convert the follo
You Are Eligible For 15% Discount This Month!
Written Assignment (Homework) #2(10-point) Convert the following ER diagram into a relational database schema:NOTE : I have uploaded the diagram for you (90-point) Express the following queries on the above schema in both relational algebra(20-point each) and relational calculus (10-point each):Find names of all students who take at least two courses taught by Peterson buttake only one course from Davidson.Find S_IDs of the students who take all courses taught by Davidson.Find all instructors (C_InstNames) who currently teach at least three courses.Please submit legible answers.
Leave a Reply
Want to join the discussion?Feel free to contribute!