Database Systems Design
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 but take 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.
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..


