CS3060 Database Systems

This course presents an up-to-date introduction to database systems including database system architectures, physical file organizations, data models, query languages, and design of relational and non-relational databases.

Prerequisite

CS3021 or Consent of Instructor

Lecture Hours

Lab Hours

Course Learning Outcomes

After completing this course, students will be able to do the following:

Explain the capabilities of different types of databases, such as relational, NoSQL, distributed, and object-oriented.
Explain which types of databases are best suited for various applications.
Interpret entity relationship diagrams.
Design a relational database schema and put it into third normal form.
Write SQL queries for a relational database.
Write software to execute database queries using SQL and JDBC.
Create a webpage that enables clients to access databases using servlets and JDBC.
Process distributed data using map-reduce via Hadoop.