Given the University Schema above, specify the following queries using relationa

Question

Given the University Schema above, specify the following queries using relational algebra. Retrieve the name and Transcript of each senior student (class = 5) majoring in COSC. Transcript includes course name, course number, credit hours, semester, year, and grade for each course completed by the student. Retrieve the names and major departments of all straight A students (students who have a grade of A in all their courses) Retrieve the names and major departments of all students who do not have any grade of A in any of their courses.

Explanation / Answer

a.)

select ST.Name, CR.Course_Name, CR.Course_Number, CR.Credit_hours, SEC.Semester, SEC.Year, GR.Grade
From STUDENT ST, COURSE CR, SECTION SEC, GRADE_REPORT GR
WHERE ST.Class = 5
AND Major = 'COSC'
AND ST.Student_Number = GR.Student_Number
AND GR.Section_identifier = SEC.Section_identifier
AND SEC.Course_Number = CR.Course_Number;

b.)

select ST.Name, ST.Major
FROM STUDENT ST, GRADE_REPORT GR
WHERE ST.Student_Number = GR.Student_Number
AND GR.Grade = 'A';

c.)

select ST.Name, ST.Major
FROM STUDENT ST, GRADE_REPORT GR
WHERE ST.Student_Number = GR.Student_Number
AND GR.Grade NOT IN
(select ST.Grade
FROM STUDENT ST, GRADE_REPORT GR
WHERE ST.Student_Number = GR.Student_Number
AND GR.Grade = 'A');

There are the queries as per my knowledge there my be another case for writting queries.Please let me know if you find any difficulty in understanding these queries.

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.