Skagit Valley College

Catalog Course Search Details

 Course Title:   Database Design and SQL

 Title Abbreviation:   DATABASE DESIGN & SQL

 Department:    CIS

 Course #:    241

 Credits:    5

 Variable:     No

 IUs:    5

 CIP:    110301

 EPC:    514

 REV:    2021


 Course Description  

Introduction to database management systems. Topics include database terminology, design objectives and procedures, normalization and relationships, and Structured Query Language.

 Prerequisite  

Prerequisite: working knowledge of, and experience with, Microsoft Access as presented in CIS 147 are strongly recommended.

Additional Course Details

Contact Hours (based on 11 week quarter)

Lecture: 55

Lab: 0

Other: 0

Systems: 0

Clinical: 0


Intent: Distribution Requirement(s) Status:  

Vocational Preparatory Required for ATA degree, Required for certificate  

Equivalencies At Other Institutions

Other Institution Equivalencies Table
Institution Course # Remarks
N/A

Learning Outcomes

After completing this course, the student will be able to:

  1. Comprehend the Relational Database Model.
  2. Explain Database Design Objectives.
  3. Understand Database Terminology.
  4. Execute Database Design Procedures.
  5. Normalize a Database and Create Relationships.
  6. Manipulate Data Using Query By Example and Structured Query Language.
  7. PROGRAM OUTCOME: Design a database that corrects flaws in existing legacy applications

General Education Learning Values & Outcomes

Revised August 2018 and affects outlines for 2019 and later.

Think

Definition: Think analytically, logically, creatively, and reflectively.

Course Contents

  1. Relational Database Model Comprehension.
  2. Database Design Objective.
  3. Database Terminology.
  4. Database Design Procedure.
  5. Normalization and Relationships.
  6. Data Manipulation Using Query By Example and Structured Query Language.