New material: database design problems

http://www.cse.buffalo.edu/~chomicki/462/solutions-design.pdf

New material: XML, E-R

XML databases:
http://www.cse.buffalo.edu/~chomicki/462/handout-xml.pdf

E-R example schema (courtesy of Demian Lessa):
http://www.cse.buffalo.edu/~chomicki/462/demian-er.pdf

Recitation #8 Slides

The slides for the eighth recitation (r8) are available through the link below:

http://www-student.cse.buffalo.edu/~dlessa/cse462-SP10/r8.pdf

Recitation #7 Slides

The slides for the seventh recitation (r7) are available through the link below:

http://www-student.cse.buffalo.edu/~dlessa/cse462-SP10/r7.pdf

Hint for Question 1.4 of Project 1

I am providing the results for a query similar to query 1.4. This may help you check whether you got the query right:

 List the authors having at least 20 papers, each of 
 which is directly cited by at least 20 other papers:

 Michael Stonebraker
 Jeffrey D. Ullman
 David J. DeWitt
 Philip A. Bernstein
 Won Kim
 Rakesh Agrawal
 Catriel Beeri
 Michael J. Carey
 Yehoshua Sagiv

Deadline extended

The deadline for Project #1 has been extended to Monday, March 8.