CS 275 - Data Base Development I

4 Credit(s)

Prerequisite(s):

CIS 125DB or previous database experience with approval of the Instructor.

Course Description: Provides students with an introduction to the concepts, skills, and tools involved in relational database design, implementation, and testing. Students will be introduced to and use Structured Query Language (SQL) for creating a client/server database and data manipulation. Covers relational database concepts, data anomalies, and data normalization. Entity-Relationship diagrams will be covered and used as a tool for designing a database system.

Course Learning Outcomes:

CLO#1: Compare the relational model to other database models.
CLO#2: Demonstrate Structured Query Language (SQL) to create database structures and manipulate data. (ILO: Information Literacy)
CLO#3: Design a database system using Entity-Relationship Diagrams and Normalization methods. (ILO: Critical Thinking)
CLO#4: Examine database issues in a client/server environment.
CLO#5: Analyze, design, implement, and test a complete database system using Microsoft’s SQL Server database management system.

Typical Required and Recommended Equipment and Materials: SQL Server software.

ACTI Code and Course Type
100 Lower Division Collegiate

Length of Course:
A required state minimum of (40) and a standard RCC delivery of (44) lecture hours per term, not to exceed (48) hours per term.