CIS 250 - Database Theory and Design

5.0 Credits
Designed to recognize data as a business resource. Database models are discussed from both a programmer’s and a user’s viewpoint. Roles of database designer and administrator will be examined. Prerequisite: Twenty credits towards an ATA degree or certificate or CIS 116, or equivalent experience.

Course Objectives
Upon successful completion of this course, students will be able to:

Describe fundamental principals of database theory and design. [COMMUNICATE]
Research and analyze business data requirements. [REASON]
Identify high-level business rules for data modeling. [REASON]
Document high-level business rules for data modeling. [COMMUNICATE]
Create and refine conceptual and logical data models. [REASON]
Validate conceptual and logical data models. [COMMUNICATE]
Select unique identifiers and normalize the data model. [REASON]
Understand the role of SQL in the business and database contexts. [REASON]
Recognize the basic components and issues of database application design. [REASON]