List of all IE courses

Information
4 Credits
Available Fall term
Lecture/Lab

Prerequisites
None
Contact
David Porter
541.737.2446
420 Rogers Hall

Course Description

Framework for enterprise information systems. Engineering and scientific systems. Requirements definition, enhanced entity relationship modeling, logical modeling, structured query language, relational model, referential integrity.

Topics

  • Steps for Information Systems Project
  • Structured Query Language: Data Definition Language
  • Structured Query Language: Data Manipulation Language
  • Relational algebra
  • Relational calculus
  • Normalization
  • File organizations and performance
  • Database programming
  • Internet technology

Learning Outcomes

The student, upon completion of this course, will be able to:

  1. Able to develop a conceptual database design using the Entity-Relationship model.
  2. Able to transform an Entity-Relationship conceptual model to a relational model that is normalized to 3rd Normal Form (3NF).
  3. Able to construct a query of a relational database and represent the query with Relational Algebra operations and with Structured Query Language (SQL) commands.
  4. Able to apply the concepts of relational database computing to the design and development of a custom database.
  5. Able to identify practical database implementation issues and solutions.