Database Systems Design

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):

  1. Find names of all students who take at least two courses taught by Peterson but take only one course from Davidson.
  2. Find S_IDs of the students who take all courses taught by Davidson.
  3. 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..

order custom paper