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

CS3023 or Consent of Instructor

Lecture Hours

3

Lab Hours

1

Statement Of Course Objectives

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.