CS 3860 - Database Systems

• Design database models using entity-relationship modeling, relational modeling, and normalization techniques
• Use standard database languages (e.g. SQL) for querying, manipulating, and basic management of databases
• Design relational database applications
• Document database designs
• Describe the purposes and typical mechanisms for maintaining security and confidentiality
• Understand basic database integrity properties of atomicity, concurrency, isolation, and durability
• Understand CAP Theorem concepts of consistency, availability, and partitioning
• Understand and be able to apply transaction processing and integrity constraints
• Understand fundamentals of query processing and query performance optimization
• Be aware of modern trends in the area of database systems

• Understand and apply data structures and algorithms
• Use appropriate algorithms (and associated data structures) to solve complex problems
• Analyze the time complexity of algorithms, both sequential and recursive
• Use data structures in software design and implementation

• Introduction and prerequisite review
• Entity-relationship model and relational model
• Relational model
• SQL
• Functional dependencies, normalization, relational design, and query optimization
• Relational algebra and calculus, data definition and manipulation languages (SQL), aggregates, and updates
• Record storage, index structures, transactions, and concurrency
• Stored procedures, triggers, recovery, security, and database administration
• Advanced database topics

• Database introduction
• Data modeling
• SQL
• Application integration
• Design project design and implementation
• Design project demonstration