Write the following queries in relational algebra

Assignment Help Basic Computer Science

Reference no: EM131058182

Write the following queries in relational algebra, using the university schema.

a. Find the names of all students who have taken at least one Comp. Sci. course.

b. Find the IDs and names of all students who have not taken any course offering before Spring 2009.

c. For each department, find the maximum salary of instructors in that department. You may assume that every department has at least one instructor.

d. Find the lowest, across all departments, of the per-department maximum salary computed by the preceding query.

Reference no: EM131058182

Questions Cloud

Established interpretation about the french revolution : What were some developments in contemporary French and other Western societies by the 1970s that according to Hobsbawn in his fourth chapter of Echos that facilitated popular acceptance of the attacks on the established interpretation about the Fr..

Find the name of the manager of the manager of jones : Find those employees who earn more than all employees living in the city "Mumbai."

Standard deviation of the data : A sample data set has n=50 observations. The mean of the data is x=46.5. the sum of squares is x^2=127793. What is the standard deviation of the data.

Importance of police patrol in modern policing : Explain the various lines of communications present within any given local law enforcement agency. Next, determine at least two (2) challenges and concerns that law enforcement might encounter with communication and suggest your strategy to mitiga..

Write the following queries in relational algebra : For each department, find the maximum salary of instructors in that department. You may assume that every department has at least one instructor.

Net present value of buying or leasing : Develop a simulation model to compare the net present value of buying or leasing the car for 24 months. To compare the two options a number of assumptions must be made. Assume that:

Find the company with the smallest payroll : Find the company with the smallest payroll.

Effects of emotions and social learning on behaviors : Based on this week's discourse and content, access an University Library and research one peer-reviewed article pertaining to social processing that was published within the last 10 years. Provide a summary explanation of the findings on social pr..

Huge quantities of gasoline from refineries : Tanker trucks are designed to carry huge quantities of gasoline from refineries to filling stations. A factory that manufactures the tank of the trucks claims to manufacture tanks with a capacity of 8550 gallons of gasoline. The actual capacity of..

User Account

All Pages