COMP 229 - Database Systems

3 Credits: (3 lecture)

Course Description
This course covers the definitions and models of database management systems (DBMS) including advanced topics in the theory and practice of applying database technology to the solution of typical business problems. Topics include database design and implementation based on a thorough analysis of requirements and information modeling and the application of Structured Query Language (SQL) to data definition and manipulation.

Note Spring semester only.

Prerequisite COMP 210 or COMP 237 or COMP 242 or OADM 135 or permission of the instructor.

Text
Conger, S. (2014). Hands-on database (2nd ed.). New York City, NY: Pearson.

Objectives
The student will be able to:

A. Explain the characteristics that distinguish the database approach from the traditional approach of programming with data files.

B. Describe major Database Management System (DBMS) functions and their role in a database system.

C. Describe the modeling concepts and the notation of the entity-relationship model including its use in data modeling.

D. Demonstrate the concepts of entity integrity constraint and referential integrity constraint.

E. Explain the impact of normalization on the efficiency of database operations.

F. Create data definition and data manipulation queries using SQL.

G. Describe the issues specific to transaction execution in a multi-user database.

Content
A. History and motivation for database systems

B. Database Management System (DBMS) functions

C. Data modeling

D. Entity and referential integrity

E. Functional dependency and normal forms

F. Syntax and application of SQL to data definition and manipulation

G. Transactions and concurrency control

Student Evaluation
Objectives A through G will be measured/assessed using exams, quizzes, assignments, and database projects.