This course provides an introduction to database applications, including storing, retrieving and analyzing data using database systems, as well as programming and tuning database systems for applications. The course concentrates on the relational model, but also introduces the XML data
processing.
 

Topics

• Storing data in relational tables

• Simple SQL queries

• Advanced SQL queries and database management

• Using relational databases in transaction processing systems

• Database design -- relational model and ER model

• Improving database design for transaction processing

• Improving database design for data analysis

• Inside database management systems: a glance

• Semi-structured data and XML

• Web search and information retrieval

Textbook

Silberschatz, Korth, and Sudarshan: Database Systems Concepts (5th edition), McGraw Hill

References

• Lewis Bernstein and Kifer: Database and Transaction Processing: An Application-Oriented Approach, Addison Wesley, 2002.
• Garcia-Molina, Ullman and Widom: Database Systems: The Complete Book (Errata), Prentice Hall, 2002.
• John. J. Patrick: SQL Fundamentals, 2/E, Prentice Hall, 2002.
• Martin Fowler: UML Distilled: A Brief Guide to the Standard Object Modeling Language, 3/E, Addison Wesley Professional, 2004.

Grading

• 3 assignments (15%)
• 1 project (15%)
• 2 one-hour exams (20%)
• Final exam (50%)