Design and Analysis of Database Systems | BS in Applied Computer Science

Course Details

*Note: This course description is only applicable for the Computer Science Post-Baccalaureate program. Additionally, students must always refer to course syllabus for the most up to date information.

Credits: 3.0
Prerequisites: CSPB or CSCI 2270 Computer Science 2: Data Structures with minimum grade C-.
Minimum Passing Grade: C-
Textbook: "Database Systems: The Complete Book, 2nd Edition", Garcia-Molina, H., Ullman, J. D., and Widom, J. (domestic, or international edition)

Brief Description of Course Content

Analyzes design of data systems, including data stored in file systems, database management systems and physical data organizations. Studies calculus of data models, query languages, concurrency and data privacy and security.

Specific Goals

Specific Outcomes of Instruction

Understand the theoretical underpinnings of modern databases
Be capable of choosing appropriate models and their related databases
Gain familiarity with the underlying mechanisms of various database implementations
Develop troubleshooting and optimization skills for Relational Database Management Systems

Brief List of Topics to be Covered

Relational Algebra and Algebraic Query Languages
Structured Query Language (SQL)
Data Modelling and Normalization
Entity Relationship Models and E/R Design Techniques
Keys, Constraints and Indexes
Transactions and Optimization
Hardware and implementation issues
NoSQL, Key-Value and Column Databases
Introduction to the CAP Theorem

Mathematical Concepts Used

Discrete Mathematics, Algebra, Set Theory, Boolean Algebra, Algorithmic Complexity (Big O Notation)

Return to Course List

Search

Other ways to search:

CSPB 3287 - Design and Analysis of Database Systems

Course Details

Brief Description of Course Content

Specific Goals