IE 412
INFORMATION SYSTEMS ENGINEERING

Information
4 Credits
Available Fall term
Lecture/Lab
OSU Catalog
Prerequisites
None
Contact
David Porter
(541) 737-2446
Rogers 420

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:

  • Scope an information systems project and use modern tools to determine functional requirements
  • Design conceptual, logical, and physical database models
  • Illustrate Entity-Relationship diagram
  • Demonstrate skills in defining relational database and manipulating queries using SQL
  • Explain the role of DBMS as a back-end of enterprise database system
  • Name the contemporary Internet application development techniques