CptS 451: Introduction to Database Systems

Catalog Information

Course Number:

451

Credits:

Offered:

Fall

Pre-Requisites

CptS 223: Advanced Data Structures

CptS 224: Programming Tools

computer organization, data structures, high-level programming language, file systems.

Dependent Courses:

CptS 551 Database Systems

Class Information

Objectives:

To give students the necessary theoretical background for relational database design and the ability to effectively query a database. To have students achieve a practical knowledge of databases by designing and implementing a relational database.

Structure:

quizzes (14)
lecture assignments (14)
lab assignments (12)
final exam (300 points)
extra credit (1 graded extra credit assignment @100 points)

Topics:

Intro to DBMS
Intro to database development
the relational data model part I
the relational data model part II
structured query language part I
structured query language part II
entity relationship diagrams part I
developing data models part I
developing data models part II
normalization
advanced SQL queries
views
stored procedures
triggers

Requirements

Textbooks/References:

Michael V. Mannino, database Design, Application, Development & Admin, 3rd Edition, McGrawHill, 2007

Professor/Coordinator:

Carl Hauser

ABET Program Outcomes (click to expand)

ABET Program Outcome I:

Recognize the need for, and have the ability to engage in life long learning.

ABET Program Outcome F:

An understanding of professional and ethical responsibility.

ABET Program Outcome C:

Ability to design a system, component, or process to meet desired needs.

ABET Program Outcome A:

Ability to apply knowledge of mathematics, science and engineering.

Contact us: webmaster@eecs.wsu.edu | Telephone: 509 335 6602 Fax: 509 335 3818 | Accessibility | Copyright | Policies
School of Electrical Engineering and Computer Science, PO BOX 642752, Washington State University, Pullman, WA, 99164-2752 USA

The School of Electrical Engineering and Computer Science

CptS 451: Introduction to Database Systems

ABET Program Outcome I:

ABET Program Outcome F:

ABET Program Outcome C:

ABET Program Outcome A: