Database Management
ealptekin@gsu.edu.tr
Content
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.
Course 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.
Weekly Contents
| 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 |
Assessment System
| Activities | Number | Contribution |
|---|---|---|
| Contribution of in-term studies to overall grade | 1 | 60 |
| Contribution of final exam to overall grade | 1 | 40 |
| Total | 2 | 100 |
| Activities | 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 |
| Total | 6 | 60 |
Relation of Proficiency
| 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 | |||||
ECTS
| 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 | ||