Computer Science 186 - Fall 1993 - Wang - Final

Computer Science 186 - Fall 1993 - Wang - Final - CS186,...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
file:///C:/Documents%20and%20Settings/Jason%20Raftery/Desktop/R. .. 1 of 4 5/12/2006 8:33 PM CS 186, Fall 93 Final Professor Unknown There are 10 questions to this exam. Credits for each question is indicated in brackets. There are a total of 100 points. Queries expressed in relational algebra and relational calculus must follow syntax used in class. Queries expressed in SQL must follow the syntax used in class or in the INGRES Manual. All SQL queries should contain NO duplicates in their outputs. It is not necessary to sort the outputs in any order. You are not allowed to use views for any questions. Problem #1 Consider the following relational database schema: STUDENT(name, regno, gpa, level, dept) COURSE(cno, cname, dept) TAKE(regno, cno) (1a)[5] Express in relational algebra the names of students who are taking a course offered by the EECS department. (1b)[5] Express in relational calculus the names of the students who are not taking any courses offered by the EECS department. Problem #2 Consider the following relational database schema: DEPT(dname, location) STUDENT(name, regno, gpa, level, dept) COURSE(cno, cname, dept) TAKE(regno, cno) (2a)[5] Express in SQL the names f the courses taken by any student who is from a department located in 'Evans Hall'. (2b)[5] Express in SQL the names of the departments which have no students with gpa better than 3.5 taking less than 4 courses. Problem #3
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/17/2009 for the course CS 186 taught by Professor Staff during the Spring '08 term at Berkeley.

Page1 / 4

Computer Science 186 - Fall 1993 - Wang - Final - CS186,...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online