CS307 Database Management
This course introduces the concepts and design principles used in database systems. It provides an overview of principles of physical and logical database design, data models, query languages, translation of requirement to data and query design, relational design theory, file structures, transaction management, entity relationships; centralized and distributed systems; data dependencies, concurrency, integrity, reliability, confidentiality, security, and applications in a relational database. The course will utilize UML as a design tool, and include a final unit on issues concerning data warehouses and data marts, federated databases, non-relational databases, and/or databases in a web environment. Prerequisite: CS 117 or approval of the program chair.
Prerequisite
CS117