This course covers the design and implementation of relational database systems. Emphasis is placed on the database design of real world business application using Entity Relationship modelling. SQL programming is covered in detail. Data Management concepts such as Transaction Management, Concurrency Control, Recovery, and backups are presented. XML-enabled databases are also studied. An overview of several specialized databases is introduced and the technical and managerial responsibilities of a database administrator are discussed.
By utilizing an abundance of real world business applications, students are introduced to database systems and designs used by organizations. Additionally students examine the characteristics of database transactions and how they affect database integrity and consistency. At the end of this course, students will be able to effectively design and implement enterprise database systems.