CIS 335 - Data Base Management

Core for Accounting Major, CIS Major & Minor; Elective for Supply Chain Management
Prerequisite: CIS 240 or CIS 300
Available in: Fall, Spring, and Summer
Credits: 3
Type: Data Base

Course Description

Fundamental concepts of database processing; conceptual, logical, and physical design of databases; the use of SQL and DBMS technology for relational database implementation; and general business database management issues.

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. understand advantages and disadvantage of the database approach to data management, the components of a database system, entity-relationship models, and normalizations
2. apply entity-relationship models, normalization, and indexes to conceptual data modeling, the logical database design, and physical database design
3. understand client/server architecture and distributed databases in organizations
4. understand the issues and terminology used in data warehousing
5. use SQL Plus environment to write SQL queries to create and retrieve data from ORACLE relational databases