Introduction to Database Systems

Catalog description

This course helps students to understand the basic principles required to construct a functioning database free of data anomalies. A strong mathematical background may be required to manage advanced concepts of multi-valued dependency and representation theory, as well as an ability to conceptualize, design, and implement a database. The course focuses on relational database structures, with emphasis on entity relationship diagrams for data modeling, transaction properties, and functions. Students will study SQL for data description and data manipulation, as well as the use of modern APIs to access the database. (Prerequisite: CSCI345)