At the end of this course, the students; 1) Can explain the basic concepts of information system. 2) Can create the database and its components (table, form, query, report). 3) Can write basic queries (select, delete, update, insert) on the database as SQL 4) Can design information system prototype 5) Can explain basic concepts of production information systems 6) Can implement the basic functions of a sample ERP software (warehouse, shift, inventory, BOM definition, MPS-MRP)
MODE OF DELIVERY
Face to face
PRE-REQUISITES OF THE COURSE
No
RECOMMENDED OPTIONAL PROGRAMME COMPONENT
None
COURSE DEFINITION
Information management in production systems, Information and knowledge. Design principles in production information systems. E-R models and normalization. Design of relational databases and Access, query design, SQL queries and DDL, DCL, and DML, single and multiple tables. Forms, macros and reports in Access. Visual Basic database programming by using data control. Database programming by using DAO. Database programming by using ADO and Access modules. ASP interface. Applications with MRP, MRPII and ERP.
COURSE CONTENTS
WEEK
TOPICS
1st Week
Introduction to information systems: Basic Concepts, Establishment of information systems, tools used in the development of information systems Management of information system projects, management information system, concepts of production information system
2nd Week
Database Design and Management: Basic concepts, data types, table creation applications in Access and MySQL, Normalization Operations. Form creation applications on Access.
3rd Week
Database Design and Management: SELECT command and Access and MySQL applications
4th Week
Database Design and Management: SELECT, INSERT command and Access and MySQL applications
5th Week
Database Design and Management: DELETE and UPDATE commands and Access and MySQL applications
6th Week
Database Design and Management: Reports on Access and VB script applications
7th Week
Database Design and Management: VB script applications on Access
8th Week
Midterm
9th Week
Introduction to production information systems, basic concepts, basic information about MRP, MRPII and ERP systems
10th Week
Implementation of sample ERP system: Examination of basic operations such as factory, user, warehouse, inventory identification
11th Week
Implementation of sample ERP system: Supplier, customer, purchasing agreements, GKK criteria, shift, production departments, machinery, business center identification procedures
12th Week
Implementation of the sample ERP system: Identification BOM, product route, order, stock-supply policies
13th Week
Implementation of the sample ERP system: Opening, displaying, reviewing and approving work orders
14th Week
Implementation of the sample ERP system: Creation of sample databases Implementation of the sample ERP system: Business Intelligence application.
RECOMENDED OR REQUIRED READING
K. C. LAUDON-J. P. LAUDON, Management Information Systems, Prentice Hall, Upper Saddle River 2010. Access Database Design and Programming (2002), Steven Roman ve Ron Petrusha, O'Reilly and Assc.