Home

Course Description

In this course, students are introduced to the concepts and characteristics of relational database systems. The organization of data within relational databases including normalization and integrity constraints are explained as well as the concepts related to relational design. The focus of the course is Structure Query Language (SQL), the language of relational database systems. Through hands-on experience both in class and off campus, SQL is practiced, concepts are reinforced and students gain proficiency in using SQL to code and maintain data in relational tables. In addition, students gain proficiency in manipulating relational data using an industry-standard relational database system. 

2 class hours, 2 lab hours, 3 credits

Course Objectives

Upon successful completion of the course, the student should be able to:

1. Understand the role of a database in an IS, and the relationships databases have with other parts of the IS.
2. Understand the organization of the data in the RDB, the concepts of the table structure, the primary and the foreign keys.
3. Create tables according to a given design, including choosing data types for columns and declaring the column and the table constraints (primary key, foreign key, NOT NULL, CHECK). 
4. Populate tables with data and manipulate the data (create, update, delete and retrieve).
5. Program data retrieval queries, including:
   1. Select data from one table for various retrieval conditions.
   2. Select data from several tables with the help of joins or subqueries, and for various retrieval conditions.
   3. Perform aggregate calculations on data from one or several tables.
   4. Populate tables with data from other applications and export data to other applications (including spreadsheets).