Question: Using the provided database answer the questions using relational algebra classroom building string room_number number capacity number department dept_name string building string budget number course

Using the provided database answer the questions using relational algebra

  • classroom
    • building string
    • room_number number
    • capacity number
  • department
    • dept_name string
    • building string
    • budget number
  • course
    • course_id string
    • title string
    • dept_name string
    • credits number
  • instructor
    • ID number
    • name string
    • dept_name string
    • salary number
  • section
    • course_id string
    • sec_id number
    • semester string
    • year number
    • building string
    • room_number number
    • time_slot_id string
  • teaches
    • ID number
    • course_id string
    • sec_id number
    • semester string
    • year number
  • student
    • ID number
    • name string
    • dept_name string
    • tot_cred number
  • takes
    • ID number
    • course_id string
    • sec_id number
    • semester string
    • year number
    • grade string
  • advisor
    • s_id number
    • i_id number
  • time_slot
    • time_slot_id string
    • day string
    • start_hr number
    • start_min number
    • end_hr number
    • end_min number
  • prereq
    • course_id string
    • prereq_id string

A- Building(s) student(s) Brown had classes in the Spring 2010 semester.

B- Name(s) and ID()s of student(s) that instructor(s) Gold taught.

C- Student(s) whose name(s) are the same as name(s) of some instructor(s). We are interested in ID(s) and name(s) of this\those student(s).

D- Course(s) for which only one section was created in the Spring 2009 semester.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!