Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Students (sid: integer, sname: string) Course (cid: integer, iid, cname: string) Instructors (iid: integer, iname: string) Grades (sid, cid, ggrade: string) The key fields are

image text in transcribed

Students (sid: integer, sname: string) Course (cid: integer, iid, cname: string) Instructors (iid: integer, iname: string) Grades (sid, cid, ggrade: string) The key fields are underlined, and the domain of each field is listed after the field name. Thus, sid is the key for Students, cid is the key for Courses, and iid is the key for Instructors. Based on the above schema, write the following queries in Relational Algebra and Domain Relational Calculus: 1. (8 Points) Find the snames of the students who registered in the course with cname "Database". 2. (8 Points) Find the snames of students who got a ggrade "A" in all courses. 3. (8 Points) Find the cids of courses taught by at least two different instructors. 4. (8 Points) Find the sids of students who never received a ggrade "D. 5. (8 Points) If grades are graded by 100 scale. Consider Scheme: Grades (sid, cid, ggrade: int) instead. Find the sids of students who received the highest grade

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation And Management

Authors: Peter Rob, Carlos Coronel

6th International Edition

061921323X, 978-0619213237

Students also viewed these Databases questions

Question

Approximately 3.3% of youths have ODD and 3.2% have CD.

Answered: 1 week ago