Organization of Data

Catalog description

Introduction to concept of databases including the storage, manipulation, evaluation, and display of data and related issues. IST 110 is recommended as preparation for IST 210 . IST 210 Organization of Data (3) As the database management software becomes one of the critical components in modern IT applications and systems, a solid understanding of the fundamental knowledge on the design and management of "data" is required for virtually any IT professionals. In a business setting, such IT professionals should be able to talk to the clients to derive right requirements for database applications, ask the right questions about the nature of their entities and in-between relationships in their business scenarios, analyze and develop an effective and robust design to address business constraints, and react to the existing database designs as new needs arise. Modern IT professionals should be able to guide a company in the best use of the diverse database-related technologies and applications toward the "Big Data" era. As such, IST 210 aims to prepare students for obtaining fundamental understanding on the database concepts and practical skills to analyze and implement a well-defined database design. In particular, IST 210 provides an introduction to physical database design, data modeling, relational model, logical database design, SQL query language, and instructors' choices on database applications and advanced concepts. Students will learn to use a real-world commercial or open-source database management system, too. Upon taking IST 210 , students should be able to understand the implications and future directions of databases and database technologies.