MSIT 630 Database Systems (3 Credits)
Methodologies and principles of database analysis and design are presented. Conceptual modeling and specifications of databases, database design process and tools, functional analysis, the entity-relationship model, and advanced semantic modeling methods are discussed. Topics include theories of database systems, including the architectures of database systems, logical and physical database organizations, data models for database systems (network, hierarchical, relational, and object-oriented model), relational algebra and calculus, query languages, normal forms, null values and partial information, relational database design utilizing dependencies, view design and integration, concurrency control, query optimization, client-server database applications, distributed databases, object-oriented databases, and the current research and development trends of database analysis, design, modeling, and applications.