Specify queries c, d, and e of Exercise 6.18 in both tuple and domain relational calculus.

What will be an ideal response?


(c) For each section taught by professor King, retrieve the course number, semester, year, and number of students who took the section.
This query cannot be done in basic relational calculus as it requires a COUNT function.

(d) 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.
Tuple relational Calculus:
{s.Name, c.CourseName, c.CourseNumber, c.CreditHours, t.Semester, t.Year, g.Grade |
STUDENT(s)
AND COURSE(c) AND SECTION(t) AND GRADE_REPORT(g) AND s.Class=5 AND
s.Major='COSC' AND s.StudentNumber=g.StudentNumber AND
g.SectionIdentifier=t.SectionIdentifier
AND t.CourseNumber=c.CourseNumber}
Domain relational Calculus:
{aefgklp | (EXISTS b) (EXISTS c) (EXISTS d) (EXISTS n) (EXISTS o) (EXISTS j)
(EXISTS i)
(STUDENT(abcd) AND COURSE(efgh) AND SECTION(ijklm) AND
GRADE_REPORT(nop) AND
c=5 AND d='COSC' AND b=n AND i=o AND j=f)}

(e) Retrieve the names and major departments of all straight A students (students who have a grade of A in all their courses).
Tuple relational Calculus:
{ s.Name, s.Major | STUDENT(s) AND (FORALL g) ( NOT(GRADE_REPORT(g)) OR
NOT(s.StudentNumber=g.StudentNumber) OR g.Grade='A' ) }
Domain relational Calculus:
{ ad | (EXISTS b) ( STUDENT(abcd) AND (FORALL e) (FORALL g) (
NOT(GRADE_REPORT(efg)) OR NOT(b=e) OR g='A' ) ) }

Computer Science & Information Technology

You might also like to view...

The statement cin >> *p;

A) stores the keyboard input into the variable p. B) stores the keyboard input into the pointer called p. C) is illegal in C++. D) stores the keyboard input into the variable pointed to by p. E) None of the above

Computer Science & Information Technology

Understanding elements of the ____________________ window helps you find files and keeps them organized.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

The analyst should inventory computer hardware, including the:

What will be an ideal response?

Computer Science & Information Technology

Manuel is working on a project in Visual Studio. He wants to keep this program showing on the entire desktop, but he also needs to have several other applications open so that he can research the project. ? What feature in Windows 10 will allow Manuel to view Visual Studio on the full desktop and have other applications open at the same time?

A. Task View B. Snap Assist C. PowerShell D. Live tiles

Computer Science & Information Technology