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. 
• Be able to analyze the time complexity of algorithms, both sequential and recursive. 
• Be able to 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