Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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- Student(s) instructor with ID 15151 taught. We are interested in ID(s) and name(s) of this\those student(s).

B- Student(s) that got a grade A for both courses: CS-315 and CS-347.

C- Course section(s) taught by 2 instructors during the same semester and year.

D- Course ID(s) and name(s) that were never offered.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Are these written ground rules?

Answered: 1 week ago

Question

Have ground rules been established for the team?

Answered: 1 week ago