Homework 2 - ′ MATH ′ department(A.3 Get S for students...

Info icon This preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
CSC4402 Homework 2 Due Wednesday 9-23-2009 A. Write Relational Algebra expressions (not SQL) for the following queries with respect to the data- base below (primary key attributes are boldfaced and underlined : D: ( DEPT DNAME BUDGET) for departments T: ( T # TNAME CITY DEPT) for teachers S: ( S # SNAME CITY DEPT DEGREE) for students C: ( C # CNAME DEPT T#) for courses E: ( S # C # GRADE) for enrollments Note: Here MATH , CSC are values of the attribute "DEPT" rather than "DNAME". (A.1) Get S#, SNAME for New Orleans students from CSC department. (A.2) Get C#, Cname for courses which are taken by a student from
Image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ′ MATH ′ department. (A.3) Get S# for students who are either from ′ Baton Rouge ′ or taking the course (C#=) ′ C3 ′ (or both). (A.4) get S#, T# pairs such that the student and the teacher are from the same city and the student takes a course taught by the teacher. (A.5) Get T# for teachers who have taught a course which is NOT taken by any student from ′ Baton Rouge ′ . B. Exercise question 2.5 (page 72) of the text book....
View Full Document

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern