• Industry Engineering, Semester 2, position 3

The aim of this course is to prepare students for working with complex databases in production companies. The aim of this course is usаge of industrial engineering methods and techniques in the creation of different database queries and scripts. Also, the aim of course is usage of complex database for improvement of decision-making process and management of business-production system.

Upon successful completion of this course, students should be able to: - use SQL language, - write queries for application industrial engineering methods using SQL language (For example: The level of utilization of machine capacity, the efficiency of production processes, ABC analysis, etc.). - Analyze the results obtained by the queries established for business analysis, - Estimates of efficacy of queries a established for the different methods of industrial engineering.

1. Basic concepts of - database, databases, knowledge bases. Types of databases - hierarchical, network, relational model, object-oriented data model. Systems for database management. Standard SQL language. SQL data types. Queries. Examples of SQL functions. 2. Methods and techniques of industrial engineering - scripts in the SQL language. Defining the scripts for: rationalization of operating costs (QC diagram, critical point, ABC method) for calculating the machine capacity efficiency degree, and other scripts that involve application of industrial engineering methods and techniques in the analysis of operations of the relevant business-production system.

Design of database, tables and indexes. Using of SQL query. Operators and functions in the SQL language. For the relevant example in practice, by using SQL language, defining scripts for: rationalization of operating costs (QC diagram, critical point, ABC method) for calculating the degree of efficiency of machine capacity, and other scripts that involve application of industrial engineering methods and techniques in the analysis of operations of the relevant business-production system.

Enrolled 3rd semestar of Master study.

1. Handouts, 2. Computer classroom, 3. Software tool: МySQL, 4. Resuources form http://www.mysqul.com/ 5. Database from concrete enterprise, in order to get practice on real example.

Total assigned hours: 75

New material: 26
Elaboration and examples (recapitulation): 4

Auditory exercises: 0
Laboratory exercises: 30
Calculation tasks: 0
Seminar paper: 0
Project: 0
Consultations: 0
Discussion/workshop: 0
Research study work: 0

Review and grading of calculation tasks: 0
Review and grading of lab reports: 0
Review and grading of seminar papers: 0
Review and grading of the project: 0
Test: 10
Test: 0
Final exam: 5

Activity during lectures: 0
Test/test: 50
Laboratory practice: 0
Calculation tasks: 0
Seminar paper: 0
Project: 0
Final exam: 50
Requirement for taking the exam (required number of points): 25

Johnson, J., Database - Models, Languages, Design, Oxford University Press, Oxford, 1997. ; Beaulieu, A., Learning SQL, O'Relly Media, 2009.; Geherke, J., Database Management System, McGraw-Hill, New-York. 2003.