Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    london uk
    Posts
    5

    Angry Unanswered: i need help with relaitonal algebra

    I was wondering if someone can help me..

    I need to find 3 differnt ways of writing the following SQL in relational algebra:

    SELECT sname
    From Student, Course, Attendance
    WHERE Student.Student# = Attendance.Student# and
    Course.Course# = Attendance.Course# and
    Course.cname = "advance database" and
    Student.degreetype = "professional Pathway"

    The query is : find student names that are taking professional pathway degree and are attending the advance database course.

    Student (Student#, sname, address, dob,degreetype)
    Course(Course#, cname, syllabus, day, time)
    Attendance(Student#, Course#, year)

  2. #2
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    I hope this will work out for U,

    1. SELECT sname
    From Student
    , Course
    , Attendance
    WHERE
    Student.Student# = Attendance.Student# and
    Course.Course# = Attendance.Course# and
    Course.cname Like 'advance database' and
    Student.degreetype like 'professional Pathway';


    2. SELECT sname
    From Student
    , Course
    , Attendance
    WHERE
    Student.Student# = Attendance.Student# and
    Course.Course# = Attendance.Course# and
    Course.cname in ('advance database') and
    Student.degreetype in ('professional Pathway');
    SATHISH .

  3. #3
    Join Date
    Nov 2003
    Location
    london uk
    Posts
    5

    i want in relational algebra

    Hi Satish,

    I actaully want to SQL written in relational algebra!!

    Originally posted by satish_ct
    Hi,

    I hope this will work out for U,

    1. SELECT sname
    From Student
    , Course
    , Attendance
    WHERE
    Student.Student# = Attendance.Student# and
    Course.Course# = Attendance.Course# and
    Course.cname Like 'advance database' and
    Student.degreetype like 'professional Pathway';


    2. SELECT sname
    From Student
    , Course
    , Attendance
    WHERE
    Student.Student# = Attendance.Student# and
    Course.Course# = Attendance.Course# and
    Course.cname in ('advance database') and
    Student.degreetype in ('professional Pathway');

  4. #4
    Join Date
    Oct 2003
    Location
    Switzerland
    Posts
    140
    Sorry for my lack of knowledge, but what is relational algebra like ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •