Skagit Valley College logo

Catalog Course Search Details

This course has been changed from the previous catalog, the changed field(s) are highlighted in red:

 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:    2013


 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.

General Education Learning Values & Outcomes

Revised August 2008 and affects outlines for 2008 year 1 and later.

2. Critical Thinking

Definition: The ability to think critically about the nature of knowledge within a discipline and about the ways in which that knowledge is constructed and validated and to be sensitive to the ways these processes often vary among disciplines.

Outcomes: Students will be able to . . .
2.1 Identify and express concepts, terms, and facts related to a specific discipline.
2.2 Analyze issues and develop questions within a discipline.
2.3 Identify, interpret, and evaluate pertinent data and previous experience to reach conclusions.

6. Individual Awareness & Responsibility

Definition: Understanding, managing, and taking responsibility for one’s learning and behavior in varied and changing environments.

Outcomes: Students will be able to . . .
6.2 Demonstrate standards of professionalism in manner, appearance, and setting appropriate to the context, including the classroom, workplace, and community.

8. Mathematical Reasoning

Definition: Understanding and applying concepts of mathematics and logical reasoning in a variety of contexts, both academic and non-academic.

Outcomes: Students will be able to . . .
8.2 Correctly apply logical reasoning and mathematical principles to solve problems.
8.3 Interpret information and reasoning expressed mathematically (for example in spreadsheets, diagrams, charts, formulas, etc.).
8.4 Communicate mathematical information effectively.

10. Technology

Definition: Understanding the role of technology in society and using technology appropriately and effectively.

Outcomes: Students will be able to . . .
10.2 Demonstrate an understanding of legal, ethical, and environmental issues in the use and misuse of technology.

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.