CIS 335 - Data Base Management

Core for Accounting Major, CIS Major & Minor; Elective for Supply Chain Management
Prerequisite: CIS 240 or CIS 300 with a grade of 'C' or better
Available in: Fall, Spring
Credits: 3
Type: Data Base

Course Description

Fundamental concepts of database processing; conceptual, logical, and physical design of databases; the use of SQL for data retrieval and relational database implementation; and database management for the enterprise.

Course Objectives

The general goal of this course is to provide adequate technical detail while emphasizing the organizational and implementation issues relevant to the management of data in an organizational environment. Topics include relational data modeling, logical database design, physical database design, client/server systems, data warehousing, and database administration. Upon completion of the course, the student should be able to:

1. describe three-schema architecture, client/server architecture, and Internet databases;

2. apply entity-relationship models, normalization, and indexes to conceptual data modeling, the logical database design, and physical database design;

3. understand relational database and data warehousing concepts;

4. write SQL statements to create and maintain a database and retrieve information from ORACLE relational databases.