Introduction to Databases

4 ch (3C 2L) · Undergraduate

Learn about the motivation for and capabilities of database management systems; the role of databases in a three-tier application architecture; relational data model; relational algebra; functional dependencies and normalization; SQL language, including creating, loading, updating, modifying, and querying database tables; data integrity, security and privacy; entity relationship data modeling; CRUD analysis; stored procedures; accessing a database using an API such as JDBC. Gain exposure to selected advanced topics such as data warehouses, big data, and XML. NOTE: Credit can only be obtained for one of CS 1543, CS 1103, INFO 1103.