This course provides an introduction to database design and implementation with a primary focus on the relational model. By the completion of this course the student will be able to appropriately use database design and implementation tools (the relational model, E-R models, normalization, and SQL) and apply knowledge of both technical and business issues related to database design and implementation to generate and evaluate alternate solutions to business situations. The course will also cover database dependability, reliability, availability, recovery, architectures, and distributed databases. Current topics in databases such as object-oriented and object-relational databases as well as data warehousing and data mining will also be presented. Projects will be completed using a "significant" relational database management system such as Oracle, DB2 or Microsoft SQL Server. Prerequisites: 67-271 and 67-272.
