Projects:

Other:

Prerequisites: CSE 305.

Grading:

1. 3 individual projects (10%+15%+10%)
2. quizzes (5%)
3. 2 tests (30%)
4. comprehensive final (30%)

Academic integrity policy: I will follow the CSE department academic integrity policy.

Make-up policy: The request should be made sufficiently in advance of the test, for valid reasons. The make-up should be scheduled before the next class. No make-ups are available for quizzes.

Late submission policy: The assignments should be submitted electronically using submit_cse462 before the deadline. A one-day grace period is provided, with the credit reduced by 20%. An assignment will not be accepted more than one day past the due date. Exceptions will be made only for medical reasons. Questions about the grading have to be raised with the TA within a week after the graded assignment is returned.

Course objectives: Introduce the students to fundamental data management issues: data models, database design, query languages, indexing, query processing, trigger and transaction processing. At the end of this course each student should be able to design database applications using a variety of data models, write complex queries, and understand how they are evaluated.

Course summary:

1. Introduction and overview.
2. Database design: Entity-Relationship data model, relational data model, integrity constraints, triggers, functional and multivalued dependencies, normal forms.
3. Review and exam.
4. Relational query languages: relational algebra, SQL.
5. Object databases: object-oriented concepts, objects in SQL:1999 and SQL:2003.
6. Review and exam.
7. XML databases: data model, document schemas, XPath, XQuery.
8. Selected DBMS systems issues: indexing, query optimization, transactions, security.
9. Review.