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. |
Theory Topics
| Week | Weekly Contents |
|---|---|
| 1 | Explanation of database management system concepts and their comparison to classic file systems |
| 2 | Explanation of database management system concepts and their comparison to classic file systems |
| 3 | Database models: relational model |
| 4 | Relational model (relational calculus,relational algebra) |
| 5 | Relational model (relational calculus,relational algebra) |
| 6 | Structured query language: SQL |
| 7 | Structured query language: SQL |
| 8 | Mid term |
| 9 | Physical organization of relational database system |
| 10 | Evaluation of relational operators |
| 11 | Query optimization |
| 12 | Concurrent access and transaction management |
| 13 | Security in database management systems |
| 14 | Recovering from database crashes |
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 | ||