CSPP 53001
DatabasesPrerequisites: Immersion
Catalog Description: This is the first course in the databases sequence for the professional program. The objective of the course is to introduce you to the principles and techniques of relational databases. The course focuses on three broad topics: modeling, implementation, and operation environment.
Long Description: A decent review of databases shall cover the following topics. Conceptual modeling an essential methodology of abstraction that enables database architects to produce powerful, cohesive, and robust database architectures. The prevailing technique for conceptual modeling is the ERD (Entity Relationship Diagram). The following topics are critical: entity as a set of things that are being tracked by the database; entity key as a unique identifier for each member of the entity; the m-m relationship; the 1-m relationship as a partial m-m; relationship cardinalities and participation role (optional v. mandatory); translation rules (from conceptual modeling to relational table definitions). SQL the universal standard of query language for relational databases. Concepts that fall under this topic include: relational algebra and calculus; subqueries; joins; database housekeeping (create table; insert into; delete; etc) Transaction processing A dicussion on how multiuser, distributed database systems work. The discussion covers: transaction commits; ACID; logs; locking; two-phase locking; etc. Integration This topic addresses the integration of relational database management systems with application platforms and frameworks. The objective of the discussion is to provide students with skills to build database-back-ended web applications. Emerging directions a discussion on XML and its mapping to relational models, OLAP, semistructured data sets, etc
Instructors:Quarter offered: Various
Last Verified by Leo Irakliotis on 5 May, 2005.