School of Engineering \ Industrial Engineering
Course Credit
ECTS Credit
Course Type
Instructional Language
Programs that can take the course
In this course, today’s information systems technologies and infrastructure are introduced. Students learn about the design and management of information systems, and investigate the effects of information systems on companies.
Textbook and / or References
1. Database Management Systems” by Raghu Ramakrishnan, J. Gehrke, 3rd Edition, McGraw- Hill
2. Database Processing: Fundamentals, Design, and Implementation (15th Edition/ 40th Anniversary Edition)"" by David M. Kroenke, David Auer, Scott L. Vandenberg, Robert C. Yoder. Pearson
3. Design of Industrial Information Systems”, Thomas Boucher, Ali Yalçın, Academic Press, Elsevier (BY) ISBN-13: 978-0-12-370492-4, ISBN-10: 0-12-370492-8 (textbook)
4. Management Information Systems: Managing the Digital Firm” (11th Edition) , Jane P. Laudon, Kenneth C. Laudon, Prentice Hall (LL)
The aim of this course is to provide students with fundamental knowledge of contemporary information systems and industrial information systems, and to help them develop skills in information systems development, data modeling, and database design, implementation, and querying.
1. To learn types and advantages of different Industrial Information Systems ( ERP, CRM etc.).
2. To understand the information systems development steps
3. To learn how to design, implement and query a database
4. To learn data and information modelling tools and languages such as UML (Unified Modelling Language) and IDEF (Integrated Definition).
5. Ability to express results written and orally
6. Ability to work within a team
Week 1: Introduction to Information Systems
Week 2: Relational Database Model (SQL)
Week 3: Relational Database Model (SQL)
Week 4: Data Modeling (ER Diagram)
Week 5: Data Modeling (ER Diagram & Normalization)
Week 6: Structured Analysis and Functional Architecture (IDEF & DataFlow)
Week 7: Informational Architecture and Logical Database Design
Week 8: Executing an Information System Design Project
Week 9: Use Case Preparation, Unified Modeling Language (UML)
Week 10: Unified Modeling Language (UML)
Week 11: Workflow Management Systems, Business Process Management (BPM)
Week 12: Project management - IS Requirement Analysis – Implementation
| Tentative Assesment Methods |
| Activities |
Number |
Weight (%) |
| Course Attendance/Participation |
- |
- |
| Laboratory |
- |
- |
| Application |
- |
- |
| Homework |
- |
- |
| Project |
1 |
20% |
| Presentation |
- |
- |
| Field Work |
- |
- |
| Internship |
- |
- |
| Course Boards |
- |
- |
| Quiz |
4 |
15% |
| Midterm Exam |
1 |
25% |
| Final Exam |
1 |
40% |
|
Total |
100% |
| Tentative ECTS-Workload Table |
| Activities |
Number/Weeks |
Duration (Hours) |
Workload |
| Course Hours (first 6 weeks) |
6 |
4 |
24 |
| Course Hours (last 6 weeks) |
6 |
4 |
24 |
| Laboratory |
- |
- |
- |
| Application |
- |
- |
- |
| Homework |
- |
- |
- |
| Project |
1 |
25 |
25 |
| Presentation |
- |
- |
- |
| Field Work |
- |
- |
- |
| Internship |
- |
- |
- |
| Course Boards |
- |
- |
- |
| Preparation for Quiz |
4 |
5 |
20 |
| Preparation for Midterm Exam |
1 |
20 |
20 |
| Final Exam |
1 |
2 |
2 |
| Preparation for Final Exam |
1 |
25 |
25 |
| Study Hours Out of Class (preliminary work, reinforcement, etc.) |
1 |
30 |
30 |
| Total Workload | | |
170 |
| Total Workload / 30 | | |
170 / 30 |
| | |
5.666667 |
| ECTS Credits of the Course | | |
6 |
|
Program Outcome
**
|
| 1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
|
Course Outcome
|
|---|
| 1 |
A, C
|
|
A, B
|
B
|
|
C
|
B
|
|
|
|
|
|
|
| 2 |
A, C
|
|
A, B
|
B
|
|
C
|
B
|
|
|
|
|
|
|
| 3 |
A, C
|
|
A, B
|
B
|
|
C
|
B
|
|
|
|
|
|
|
| 4 |
A, C
|
|
A, B
|
B
|
|
C
|
B
|
|
|
|
|
|
|
| 5 |
|
|
|
|
|
C
|
A, B, C
|
|
|
|
|
|
|
| 6 |
|
|
|
|
|
A, C
|
|
|
|
|
|
|
|