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. 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

Secrets Of Analytical Leaders Insights From Information Insiders

Authors: Wayne Eckerson

1st Edition

1935504347, 9781935504344

More Books

Students also viewed these Databases questions

Question

Develop expertise as a facilitator of a training topic or module

Answered: 1 week ago

Question

Explain the nature of human resource management.

Answered: 1 week ago

Question

Write a note on Quality circles.

Answered: 1 week ago

Question

Describe how to measure the quality of work life.

Answered: 1 week ago