Database Systems Design

User Generated

Sbttl1

Computer Science

Description

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.

Unformatted Attachment Preview

(10-point) Convert the following ER diagram into a relational database schema: S FirstName S LastName S D student S_Major takes CID course C Room C_Name C_InstName
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi.. I have finished the assignement. Thank you for giving me that opportunity to work with you.

ER diagram into a relational database schema

1. Find names of all students who take at least two courses taught by Peterson but
take only one course from Davidson.

Relational Algebra
S.S_ID∏S.S...

Similar Content

Related Tags