DATABASE MANAGEMENT SYSTEMS (CSE530) Fall Semester, 2005 C. DAVID BUTLER, PHARM.D., M.B.A.

OFFICE: SEVER HALL, ROOM 221 DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING BOX 1045 WASHINGTON UNIVERSITY IN ST. LOUIS OFFICE HOURS: MW 2:00-4:00, 5:30-6:00 PM PHONE: 314.935.9824

CLASS: 4:00-5:30PM MW  |  LOCATION: Arts & Sciences Laboratory Science Building,  Room 201 | Teaching Assistants | Graders email account | LABS Week Monday Wednesday Comments 1 August 28 August 31 Chapter 1 (pp 1-21,24-30) | No class Introduction and History of DBMS 2 September 5 September 7 Chapter 2 (pp 33-55) | No class Labor Day Database environments, Data models Domains, datatypes and tuples 3 September 12 September 14 Chapter 3 (pp 67-86) | The relational model The relational model 4 September 19 September 21 Chapters 4 (pp 88-108) and 5 (pp 112-6) | Lab 2 is due Sept 30th Relational model, Relational algebra Relational algegra; Relational calculus; QBE; SQL: DML 5 September 26 September 28 Chapter 5 (pp 117-54) | Lab 2 is now due on Oct 5th SQL: Relational calculus; DDL SQL: DML 6 October 3 October 5 Chapter 6 (pp 157-93); SQL: DML Data Access: DML; Views; DDL for Transactions and Privileges 7 October 10 October 12 Chapter  9 (pp 281-94), Chapter 11 (pp 342-65) Exam 1 Database Analysis and Design; ER 8 October 17 October 19 Chapter 11 (pp 342-65), Chapter 12 (pp 371-8) and Chapter 16 (pp 463-72) Entity-Relationship Model ER Model to Relational Model 9 October 24 October 26 Chapter 13 (pp 387-411) and Chapter 14 (pp 415-28) ER Conversion, Functional Dependencies Functional Dependencies, Normalization 10 October 31 November 2 Chapter 15 (pp 437-56) | Chapter 17 (494-516) |  Individual Project First Due-date Normalization Design Methodology: Conceptual, Logical, Physical 11 November 7 November 9 Appendix C Design Methodology: Physical Design Methodology: Physical; Team Meetings 12 November 14 November 16 Suggested reading: Chapters 8 (pp 242-75), 19 Oracle DBMS, briefly Topic Presentation: Data Security, Privacy 13 November 21 November 23 Suggested reading: Chapter 20, 23 Topic Presentation: Transaction Management No class Thanksgiving break 14 November 28 November 30 Suggested reading: Chapters 23, 31-33 | December 1: Team Website Project due Topic Presentation: Data Warehouses Topic Presentation: OLAP 15 December 5 December 7 Suggested reading: Chapters 21, 31-34 Topic Presentation: Query Processing Topic Presentation: Data Mining 16 December 12 December 14 Exam 2 will focus on topics covered since Exam 1, utilizing  related material from before Exam 1 Exam 2 No Class 17 December 19 December 21 Final Exam Period: Friday, December 16 - Thursday, December 22 No Class

Required Text

Database Systems: A practical approach to design, implementation, and management, fourth edition by Thomas Connolly and Carolyn Begg.  Addison-Wesley Publisher, 2002.  ISBN: 0321210255

Suggested Texts

Practical Issues in Database Management: A Reference for the Thinking Practitioner by Fabian Pascal. Addison-Wesley Publisher, 2000.  ISBN 0201485559

Database Management Systems, Third Edition by Raghu Ramakrishnan and Johannes Gerhke. McGraw-Hill, 2002.  ISBN 0072465638

Fundamentals of Database Systems, Fourth Edition by Ramez Elmasri and Shamkant Navathe. Pearson Addison Wesley, 2003. ISBN: 0321122267

An Introduction to Database Systems, Eighth Edition by CJ Date. Pearson Education, 2003. ISBN: 0321197844

Database Systems: The Complete Book by Hector Garcia-Molina, Ueffrey Ullman and Jennifer Widom. Prentice Hall, 2001. ISBN: 0130319953

Team Project

Suggested Presentation Topics

Physical data storage and Access Paths
Meta Data and DBMS Monitoring
Data Warehouses
OLAP
Distributed Transaction Processing
Data Mining
Business Intelligence
Object-oriented Database Management Systems

*Your presentation will include one or more meetings with Dr. Butler to discuss and rehearse the material you plan to present, along with submission of presentation material (e.g., powerpoint slides) and three potential exam questions and answers on your topic by the day of presentation.

Website Project

Create an alternative site to The Orange Book with the described enhancements.

FDs Project

Use the DBMS of your choice.  Microsoft SQL Server 2000 and Microsoft Access are supported by the CEC.

Sample Data

This is for exploration.  You will need to assign column names that match between the tables and sql statements.

CEC support for Microsoft SQL Server 2000

Grading