CS3610: Database Organization and Design
Credit Hours: 3.0
Terms Offered: Spring
Addresses the analysis, design, and implementation of relational database applications. The Structured Query Language (SQL) is covered in depth along with standard problem domain and data modeling techniques. Implementation techniques and considerations are discussed and practiced extensively. Key concepts include: analysis and design using a standard notations such as Unified Modeling Language (UML), data modeling to logical schema conversion techniques, normalization, client-server architectures, and web-based access to database systems. Additional advanced topics include system security transaction processing and data course concepts using state-of-the-art multi-user database software.
Outcome 1. Demonstrate proficiency with SQL (both Data Manipulation Language and Data Definition Language) and industry standard Relational Database Management Systems (RDBMS).
Outcome 2. Apply industry best practices such as Entity Relationship (ER) diagramming, ER translation into relational schemas, and schema refinement and normalization for designing a relational database schema.
Outcome 3. Build a database and its associated web application using current development tools and technologies, including standard Object-Relational Mapping (ORM) libraries.
Outcome 4. Articulate the Atomicity, Consistency, Isolation, and Durability (ACID) properties of a Relational Database Management System (RDBMS).
Outcome 5. Identify and explain the architectural components of Relational Database Management (RDBMS) Systems and the salient design characteristics of each component.