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 Level: Lower Division Collegiate

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.