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 & 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 is only given for one of CS 1103 and INFO 1103.
Prerequisite: CS 1073 |
