Course Description

This course is designed to provide an overall understanding of database management systems. It will emphasize relational database systems because of their widespread use. Database design techniques such as data modeling using entity-relationship diagrams as well as normalization to eliminate anomalies will be introduced. Database access and manipulation using SQL will be covered. A database design and manipulation project will be undertaken in order to allow the student to develop a fuller understanding of database usage.

Course Objectives

  • The student will be able to list and explain the fundamental concepts of a relational database system.
  • The student will be able to utilize a wide range of features available in a DBMS package.
  • The student will be able to analyze database requirements and determine the entities involved in the system and their relationship to one another.
  • The student will be able to develop the logical design of the database using data modeling concepts such as entity-relationship diagrams.
  • The student will be able to create a relational database using a relational database package.
  • The student will be able to manipulate a database using SQL.
  • The student will be able to assess the quality and ease of use of data modeling and diagramming tools.

Grading Policies expand

Inside Class expand

Beyond Class expand

Miscellaneous expand