COURSE OBJECTIVES COURSE OVERVIEW This course is intended to provide you with an understanding of the current theory and practice of database management systems. To help you more fully appreciate their nature, the course provides a solid technical overview of database management systems, using a current database product as a case study. In addition to technical concerns, more general issues are emphasized. These include data independence, integrity, security, recovery, performance, database design principles, and database administration. COURSE OBJECTIVES At the completion of this course, students should be able to do the following: 1. Understand the role of a database management system in an organization. 2. Understand basic database concepts, including the structure and operation of the relational data model. 3. Construct simple and moderately advanced database queries using Structured Query Language (SQL). 4. Understand and successfully apply logical database design principles, including E-R diagrams and database normalization. 5. Design and implement a small database project using Microsoft Access. 6. Understand the concept of a database transaction and related database facilities, including concurrency control, journaling, backup and recovery, and data object locking and protocols. 7. Describe and discuss selected advanced database topics, such as distributed database systems and the data warehouse. 8. Understand the role of the database administrator.