Industrial Engineering

Database Management(IND356)

Course Code Course Name Semester Theory Practice Lab Credit ECTS
IND356 Database Management 5 3 0 0 3 4
Prerequisites ING231
Admission Requirements ING231
Language of Instruction French
Course Type Elective
Course Level Bachelor Degree
Course Instructor(s) Sadettin Emre ALPTEKİN ealptekin@gsu.edu.tr (Email)
Assistant
Objective Database systems, which form the base of todays’ information technology applications and their management is very important to comprehend information technology systems. This course as a selective course will help the students to appraise a database management system and how data is defined, updated and managed in the system. In this context the aim of this course is determined as:
• showing the students how database systems are evolved from first computer systems.
• helping the students to evaluate the advantages and disadvantages of various database systems.
• helping the students to design a database management system.
• helping the students to put into practice their designed database management system.
Content 1. week : Explanation of database management system concepts and their comparison to classic file systems.
2. week : Explanation of database management system concepts and their comparison to classic file systems.
3. week : Database models: relational model
4. week : Relational model (relational calculus,relational algebra)
5. week : Relational model (relational calculus,relational algebra)
6. week : Structured query language: SQL
7. week : Structured query language: SQL
8. week : Mid term
9. week : Physical organization of relational database system
10. week : Evaluation of relational operators
11. week : Query optimization
12. week : Concurrent access and transaction management
13. week : Security in database management systems
14. week : Recovering from database crashes
Course Learning Outcomes Upon successful completion of this course, the student could:
1. define the components of database management systems.
2. enumerate database models.
3. explain optimization and security issues in databases.
4. use a data manipulation language effectively.
5. use Microsoft Access database management system.
6. design a database application.
7. develop a database management system application.
Teaching and Learning Methods Lecture, discussion, question-answer.
References • Ramakrishnan and Gehrke, Database Management Systems, McGraw Hill, 2003.
• Date, C.J., An Introduction to Database Systems, Addison-Wesley, 2004.
Print the course contents
Theory Topics
Week Weekly Contents
Practice Topics
Week Weekly Contents
Contribution to Overall Grade
  Number Contribution
Contribution of in-term studies to overall grade 1 60
Contribution of final exam to overall grade 1 40
Toplam 2 100
In-Term Studies
  Number Contribution
Assignments 4 10
Presentation 0 0
Midterm Examinations (including preparation) 1 25
Project 1 25
Laboratory 0 0
Other Applications 0 0
Quiz 0 0
Term Paper/ Project 0 0
Portfolio Study 0 0
Reports 0 0
Learning Diary 0 0
Thesis/ Project 0 0
Seminar 0 0
Other 0 0
Toplam 6 60
No Program Learning Outcomes Contribution
1 2 3 4 5
1 Knowledge and understanding of a wide range of basic sciences (math, physics, ...) and the main concepts of engineering X
2 Ability to combine the knowledge and skills to solve engineering problems and provide reliable solutions X
3 Ability to select and apply methods of analysis and modeling to ask, reformulate and solve the complex problems of industrial engineering X
4 Ability to conceptualize complex systems, processes or products under practical constraints to improve their performance, ability to use innovative methods of design X
5 Ability to design, select and apply methods and tools needed to solve problems related to the practice of industrial engineering, ability to use computer technology X
6 Ability to design experiments, collect and interpret data and analyze results X
7 Ability to work independently, ability to participate in working groups and have a multidisciplinary team spirit X
8 Ability to communicate effectively, ability to speak at least two foreign languages X
9 Awareness of the need for continuous improvement of lifelong learning, ability to keep abreast of scientific and technological developments to use the tools of information management X
10 Awareness of professional and ethical responsibility
11 Knowledge of the concepts of professional life as "project management", "risk management" and "management of change" X
12 Knowledge on entrepreneurship, innovation and sustainability
13 Understanding of the effects of Industrial Engineering applications on global and social health, environment and safety.
14 Knowledge of the problems of contemporary society X
15 Knowledge of the legal implications of the practice of industrial engineering
Activities Number Period Total Workload
Class Hours 14 3 42
Working Hours out of Class 13 2 26
Assignments 4 2 8
Midterm Examinations (including preparation) 1 10 10
Project 1 30 30
Final Examinations (including preparation) 1 17 17
Total Workload 133
Total Workload / 25 5,32
Credits ECTS 5
Scroll to Top