Introduction to Databases

4 ch (3C 2L) · Undergraduate

Topics include: 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; brief introduction to advanced topics such as data warehouses, big data, and XML. Note : Credit cannot be counted for both CS 1103 and INFO 1103.