• HOME
• ABOUT US
  • Name Address
  • General Description
  • Governance
  • Academic Calendar
  • Degree Programmes
  • List of Programmes in English
  • General Admission and Registration Procedures
  • Credit Mobility and Recognition of Prior Learning
  • ECTS Credit Allocation
  • Academic Guidance
  • Contacts
• Degree Programmes
  • Third Cycle Programmes (Doctorate Degree)
  • Second Cycle Programmes (Master's Degree)
  • First Cycle Programmes (Bachelor's Degree)
  • Short Cycle Programmes (Associate's Degree)
• GENERAL INFORMATION FOR STUDENTS
  • Cost of Living
  • Accommodation
  • Meals
  • Medical Facilities
  • Facilities for Disabled Students
  • Insurance
  • Financial Supports
  • Student Affairs Office
  • Practical Information for International Students
  • Language Courses
  • Work Placement Possibilities
  • Sports, Social and Cultural Facilities
  • Student Associations and Clubs
  • About İzmir - Turkey
• INTERNATIONAL RELATIONS
  • International Relations Office
  • Registration Procedures
  • Agreements
  • Coordinators
  • Documents
  • List of Programmes in English
  • ECTS / DS Labels

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 *** Resit Exam is Not Administered in Institutions Where Resit is not Applicable.

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/LO PO.1 PO.2 PO.3 PO.4 PO.5 PO.6 PO.7 PO.8 PO.9 PO.10 PO.11 LO.1 5 2 LO.2 5 4 LO.3 5 3