Express each of the following queries in relational algebra

- Be sure that the resulting relation lists just the attributes that are given in the instruction. - Do not include unnecessary relations in your queries.

Consider the Schema diagram for a university database shown in Figure 2.8 on page 47 of the textbook. 1. Why does the following query fail to list all of the students who have taken/are taking a course taught by Dr. Brandt? ( 5 points) student.name,student.ID (student takes teaches name= "Brandt" (instructor)) 2. Find the names of all instructors in the History department. (5 points) 3. Find the titles of courses in the Computer Science department that have 3 credits. (5 points)