CS338: Computer Applications in Business: Databases

Course Overview

Short Description

A user-oriented approach to the management of large collections of data. Methods used for the storage, selection and presentation of data. Common database management systems.

Course Objectives

The main objective of this course is to introduce students to fundamentals and use of database technology by studying databases from the viewpoint of a database user. It teaches the use of a database management system (DBMS) by treating it as a black box, focusing only on its functionality and its interfaces.

Prerequisites

One of CS 230, 234, 241, 330; Not open to Computer Science students.

Antirequisites

CS 348, 448, ECE 456

Marking

If you miss a midterm due to acceptable reasons (see university guidelines), its percentage will be added to the final exam. If you miss the final, you will need to take the exam in a future term consistent with university policy. Otherwise, there will be no makeup exams.

For each of the exams, there will be a deadline for appealing your grade (usually one week after they are returned in class). No appeals will be considered after this deadline unless there is a medical or other excuse for absence during the appeal period.

One bonus point will be granted for each answer to another's student question on Piazza that has been endorsed by a TA or the instructor. A maximum of five bonus points can be earned.

Working with a DBMS

Students will work with a state-of-the-art commercial DMBS. A number of systems can be used. The School supports DB2, but you can also download and use SQLite. Learning how to use these systems is your responsibility.

Textbook

Fundamentals of Database Systems, the Seventh or Sixth Edition by R. Elmasri and S. Navathe, Pearson, 2015.

Text is recommended, not required. Some copies are on reserve in the DC library.

Online Resources