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 is only given for one of CS1103, CS 2513, CS 2533, INFO 1103 and INFO 2103.
Prerequisites: CS 1073. |
