COURSE UNIT TITLE

: INFORMATION SYSTEM DESIGN

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
END 3517 INFORMATION SYSTEM DESIGN COMPULSORY 4 0 0 6

Offered By

Industrial Engineering

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

PROFESSOR DOCTOR ALI SERDAR TAŞAN

Offered to

Industrial Engineering

Course Objective

To give the students ability of designing information systems according to the requirements.

Learning Outcomes of the Course Unit

1   Ability to use concepts related to information systems design
2   Ability to create a data model in information systems
3   Ability to design a database

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

END 2412 - INFORMATION SYSTEM ANALYSIS

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Systems Design
2 Systems Design
3 The Database Approach
4 Data Modeling and Analysis
5 Data Modeling and Analysis
6 Relational Database Management System
7 Relational Database Management System
8 Relational Database Management System
9 Database Design
10 Database Design
11 Database Design
12 Database Design
13 Normalization
14 Normalization

Recomended or Required Reading

Connolly, T. M., & Begg, C. E. (2005). Database systems: a practical approach to design, implementation, and management. Pearson Education.

Whitten, J. L., Bentley, L. D., & Dittman, K.C. (2004). Systems analysis and design methods. McGraw-Hill. (0-07-121521-2)

Planned Learning Activities and Teaching Methods

Instructor notes will be given using blackboard and visual presentations. Additionally, it will be further supported by application studies.

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 MTE MIDTERM EXAM
2 ASG ASSIGNMENT
3 FIN FINAL EXAM
4 FCG FINAL COURSE GRADE MTE*0.20+ASG *0.30+FIN * 0.50
5 RST RESIT
6 FCGR FINAL COURSE GRADE (RESIT) MTE*0.20+ASG *0.30+RST * 0.50


Further Notes About Assessment Methods

None

Assessment Criteria

Midterm (20%) + Assignment (30%) + Final Exam (50%)

Language of Instruction

Turkish

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

Tel: 301 76 19, e-mail: serdar.tasan@deu.edu.tr

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 14 4 56
Preparations before/after weekly lectures 12 3 36
Preparation for final exam 1 20 20
Preparation for midterm exam 1 16 16
Preparing assignments 1 20 20
Final 1 2 2
Midterm 1 2 2
TOTAL WORKLOAD (hours) 152

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11
LO.152
LO.254
LO.353