Homeworks

Assignment description

Tips

Examples

Readings

Due

Answers

Homework 1 Look at DATEPART first
Datetime functions
Specific examples Lecture notes, book October 15th Answers
Homework 2 Use the following order:

1. Lecture notes
2. Book
3."Examples" column
4. Readings column

1. MSDN, follow examples section and links to W3C.org
Understanding XML

2. Decomposition, 1NF, 2NF, 3NF, BCNF, Functional Dependencies
Database Design Principles

Normalization Tutorial

3. E/R diagrams
Database Design Using E/R Model

Lecture notes,

XML
http://www.w3.org/XML/1999/XML-in-10-points
www.zvon.org/xxl/XMLTutorial/General/book_en.html

MSDN, XML Glossary with links within each of the cases here
MSDN, XPath (general picture, syntax and functions) here
MSDN, XML here

XQuery:
http://www.w3.org/TR/xmlquery-use-cases/
http://www.xmlportfolio.com/xquery.html

Galax:
http://db.bell-labs.com/galax/

Novemeber 5th Answers
Homework 3

Problem 1,2: MSDN, Table and Index Structure
Problem 3,4,5: Lecture notes, Book
Monday, November 24th Answers
Homework 4 Tips

Thursday, December 11, at 12pm Answers