Data Base Systems and Concepts

CIS*3530 (Winter 2004)

Instructor: Fei Song (THRN 1388, ext. 58067)

Email: fsong@cis.uoguelph.ca

Office Hours: 2-4 pm, Tuesday and Thursday

Web Page: http://teachweb.cis.uoguelph.ca/cs353/

Teaching Assistant: ta353@cis.uoguelph.ca; Office hour and location: TBA

Overview

This course provides an overview on the fundamental concepts of data base systems, including data base models and modeling, relational database theory, database design methodology, query processing, and maintenance issues such as concurrency control, security, integrity and recovery. Students will also learn the skills of system analysis, database design and implementation using a commercial database system. Topics include the following:

Entity-Relationship data modeling

Relational databases

Relational algebra and calculus

Advanced components in SQL

Functional dependencies and normalization

Transaction management and concurrency control

Query optimization

Other advanced database topics

Evaluation

Four assignments (4 x 10% = 40%)

Two Quizzes (2 x 10% = 20%)

Final Exam (40 %)

Note that some assignments include programming projects in SQL. Late submissions are accepted, but there will be a reduction of 20% marks for each day late.

Textbook and References

· (Textbook) H. Garcia-Molina, J. D. Ullman, and J. Widom. Database Systems: The Complete Book. Prentice-Hall, 2002.

· C. J. Date. An Introduction to Database Systems. 7^th Edition. Addison-Wesley Publishing Company, 2000.

· A. Silbershatz, H. F. Korth, and S. Sudarshan. Database System Concepts. 3^rd Edition. WCB/McGraw-Hill, 1997.

· ACM Transactions on Database Systems. Association for Computing Machinery.