Description

3 credit/unit hours – Three hours of lecture weekly; one term

This course introduces elementary relational database concepts, including but not limited to database modeling and Structured Query Language (SQL).

Learning Objectives

Upon completion of this course the student will be able to:

  • Understand the purpose, philosophy, and motivation behind databases;
  • Understand the capabilities of relational databases;
  • Perform data modeling;
  • Consider special database designs;
  • Implement a database design;
  • Perform basic database administrator functions; and
  • Demonstrate appropriate and ethical behavior and good work habits

Main Topics

1.0 Introduction to databases
2.0 Data modeling
3.0 Database design
4.0 Database implementation with the relational model – SQL
5.0 Multi-user databases
6.0 Enterprise databases