Credits and Contact Hours

3 credits, 43 hours

Course Instructor Name

Dr. Mohammad Jeragh

Textbook

• Database Management Systems, Raghu Ramakrishnan and Johannes Gehrke, 3rd Edition
• Fundamentals of Database Systems, R. Elmasri and S.B. Navathe, 5th Edition
• Database System Concepts, Avi Silberschatz, Henry Korth and S. Sudarshan

Catalog Description

Advanced topics in commercial and research oriented databases systems including catalogs, physical storage techniques, query processing, optimization, transaction management, concurrency control, disaster recovery, security, integrity, extended data types, triggers and rules, distributed databases, warehouses and parallelism.

Prerequisite

CpE-341

Specific Goals for the Course

Upon successful completion of this course, students will be able to:

• Understand the importance of database systems in modern enterprises and in producing more reliable software systems. (Student outcomes: 2)
• Know the difference between theoretical database models and commercial database systems
• Program in SQL, Embedded SQL, triggers and GUI. (Student outcomes: 2)
• Improve and fine tune database systems performance through normalization, index creation and query optimization. (Student outcomes: 2)
• Interface a database to the Internet using the latest in commercial middle-ware technologies. (Student outcomes: 2, 4)
• Learn the importance of security and integrity and how to implement it in commercial database systems and how to set and reset access permissions to database objects. (Student outcomes: 2, 4)
• Understand the importance of transaction and how to implement processing and concurrency control in database systems and how to grantee the consistency of a database relation. (Student outcomes: 2)
• Build and implement a solution to a real life problem using commercial database systems. (Student outcomes: 2)
• Practice teamwork which includes division of their roles and tasks, communication and discussion of ideas among team members to complete the project. (Student outcomes: 5)
• Document their work in a written report and present their work formally in front of class mates. (Student outcomes: 4)

Topics to Be Covered

• Catalogs
• Physical storage techniques
• Query processing
• Optimization
• Transaction management
• Concurrency control
• Disaster recovery
• Security
• Integrity
• Extended data types
• Triggers and rules
• Distributed databases
• Warehouses
• Parallelism