ENIE 461 Engineering Information Systems (3)

 

Required course for majors in the industrial specialty.

 

Catalog Description

Introduction to and application of the basic concepts, design, development, and uses of engineering information systems.  Topics include architecture and components of engineering information systems, problem analysis, modeling, design, development, and system maintenance.  Theoretical and practical issues related to the manipulation of engineering information and design of queries is also discussed.  Examples of engineering information systems are provided.  Course culminates with a project.  Fall semester.

 

Prerequisites

ENGR 225 with grade of C or better.

 

Textbook/References

Hoffer, Jeffrey A., Joey F. George and Joseph S. Valacich. Modern Systems Analysis & Design, 3rd ed., Addison Wesley Longman, Inc. 1999.

        Microsoft Access Handbook (of your choice)

 

Course Objectives: (numbers in brackets indicates the relationship to engineering program outcomes)

·         Provide an understanding of both the theory and practice related to the analysis, modeling, design, development, validation, implementation, and manipulation of engineering information systems.

·         Introduce and practice using a database management software package to design information systems.

 

After successfully completing the course, students will be able to

·         Analyze situations that deal with information, identify their information needs, and define their requirements using SDLC and various modeling tools.  (4)

·         Explain basic file structures and indexing mechanics related to database systems (2)

·         Understand and illustrate use of process design  (4)

·         Define high-quality and usable information in relation to systems and processes  (4)

·         Define information and its relationships using data flow and entity relationship diagrams (2)

·         Use decision analysis (trees and tables) to illustrate information flow and action (2)

·         Use a software database package for implementing simple database applications  (3)

·         Independently search for solutions to database and information systems design problems

·         Independently learn how to use a database management software package

 

Class/Laboratory Schedule

Lecture 3 hours: Lecture meets twice per week, 75 minutes per meeting.

 

Topics Covered

Week

Topic

1.

 

2.

3.

 

4.

5.

6.

7.

8.

9.

10.

11.

12

13.

14.

15.

 

Introduction to Engineering Information Systems

The System Development Life Cycle

The Systems Thinking Process

Process Modeling;

Data Flow Diagramming

Logic Modeling

Conceptual Data Modeling

Determining System Requirements

Introduction to Database Design

Database Design

Relational Database Model

Introduction to Microsoft Access

Physical Files and Database Design

Designing Forms and Reports

Designing Interfaces and Dialogues

Issues to Consider

Implementation and Maintenance

 

 

Contribution to Professional Component

Contributes toward the 1.5 years of engineering topics as a 3 credit hour course in engineering sciences and engineering design.

 

Relationship of course to program outcomes

This course supports engineering outcomes 2, 3, and 4.

 

Prepared by:         Dr. Cecelia M. Wigal, 05/05/03