cs411-sp07-hw2-part2 - CS411 Database Systems Spring 2007...

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

View Full Document Right Arrow Icon
CS411 Database Systems Spring 2007 HW #2 - Part 2 Due: 1:55pm CST, 03/06/07 Note: Print your name and NetID in the upper right corner of every page of your submission. Handin your stapled homework to Trisha Benson in 4322 SC. In case Trisha is not in oFce, slide your homework under the door. Problem 5 SQL Consider the following relations: Students(sid , sname, department) Courses(cid , cname, department) Register(sid , cid , semester , year , grade) Express the following queries in SQL . (5.1) ±ind the names of all CS students; (5.2) ±or each course, show its total number of registrations in “Spring” semester of 2006; (5.3) ±ind the courses with the highest total number of students from departments di²erent from where the course is o²ered; (5.4) ±ind the names of students who have taken courses in both CS and ECE; (5.5) ±ind the records of A+ in CS courses. ±or each such record, return the student name, course name, semester, and year.; Problem 6 View Continue Problem 5, (6.1) Create a view
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 09/14/2008 for the course CS 411 taught by Professor Winslett during the Spring '07 term at University of Illinois at Urbana–Champaign.

Page1 / 2

cs411-sp07-hw2-part2 - CS411 Database Systems Spring 2007...

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