CMP653 - DATABASE MANAGEMENT SYSTEMS
| Course Name | Code | Semester | Theory (hours/week) |
Application (hours/week) |
Credit | ECTS |
|---|---|---|---|---|---|---|
| DATABASE MANAGEMENT SYSTEMS | CMP653 | Any Semester/Year | 3 | 0 | 3 | 9 |
| Prequisites | None | |||||
| Course language | English | |||||
| Course type | Elective | |||||
| Mode of Delivery | Face-to-Face | |||||
| Learning and teaching strategies | Lecture Discussion Preparing and/or Presenting Reports Project Design/Management | |||||
| Instructor (s) | Hayri Sever | |||||
| Course objective | Aim is to teach recent relational database examples, approaches and issues. analyze and optimize database queries, research about parallel and distributed databases, discuss database system architectures in business world. | |||||
| Learning outcomes |
| |||||
| Course Content | Object-relational and object oriented data models. Query processing, query optimization. Transaction processing. Associated control. Recovery system. Database system architecture. Distributed databases. Parallel databases. Application development and management. Advanced-level data types. Advanced topics on transaction processing. Data mining. Data warehouses. | |||||
| References | ? Database Systems: A Practical Approach to Design, Implementation, and Management, 5/E, by Thomas Connolly and Carolyn Begg, Fifth Edition; published by Addison-Wesley 2010. ? Database Management Systems (3rd edition) - by Raghu Ramakrishnan and Johannes Gehrke, McGraw Hill, 2003. | |||||
Course outline weekly
| Weeks | Topics |
|---|---|
| Week 1 | Object-relational and object oriented data models |
| Week 2 | Query processing, query optimization. |
| Week 3 | Transaction processing. Associated control. |
| Week 4 | Recovery system |
| Week 5 | Database system architecture. |
| Week 6 | Distributed databases. Parallel databases. |
| Week 7 | Midterm Exam |
| Week 8 | Application development and management. |
| Week 9 | Advanced-level data types |
| Week 10 | Advanced topics on transaction processing. |
| Week 11 | Data mining. Data warehouses |
| Week 12 | Student presentations |
| Week 13 | Student presentations |
| Week 14 | Project presentations |
| Week 15 | Study of final exam |
| Week 16 | Final exam |
Assesment methods
| Course activities | Number | Percentage |
|---|---|---|
| Attendance | 0 | 0 |
| Laboratory | 0 | 0 |
| Application | 0 | 0 |
| Field activities | 0 | 0 |
| Specific practical training | 0 | 0 |
| Assignments | 0 | 0 |
| Presentation | 1 | 10 |
| Project | 1 | 20 |
| Seminar | 0 | 0 |
| Midterms | 1 | 20 |
| Final exam | 1 | 50 |
| Total | 100 | |
| Percentage of semester activities contributing grade succes | 0 | 50 |
| Percentage of final exam contributing grade succes | 0 | 50 |
| Total | 100 | |
WORKLOAD AND ECTS CALCULATION
| Activities | Number | Duration (hour) | Total Work Load |
|---|---|---|---|
| Course Duration (x14) | 14 | 3 | 42 |
| Laboratory | 0 | 0 | 0 |
| Application | 0 | 0 | 0 |
| Specific practical training | 0 | 0 | 0 |
| Field activities | 0 | 0 | 0 |
| Study Hours Out of Class (Preliminary work, reinforcement, ect) | 14 | 6 | 84 |
| Presentation / Seminar Preparation | 1 | 30 | 30 |
| Project | 1 | 60 | 60 |
| Homework assignment | 0 | 0 | 0 |
| Midterms (Study duration) | 1 | 20 | 20 |
| Final Exam (Study duration) | 1 | 40 | 40 |
| Total Workload | 32 | 159 | 276 |
Matrix Of The Course Learning Outcomes Versus Program Outcomes
| D.9. Key Learning Outcomes | Contrubition level* | ||||
|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | |
| 1. Graduates should have a mastery of computer science as described by the core of the Body of Knowledge. | X | ||||
| 2. Graduates need understanding of a number of recurring themes, such as abstraction, complexity, and evolutionary change, and a set of general principles, such as sharing a common resource, security, and concurrency. | X | ||||
| 3. Graduates of a computer science program need to understand how theory and practice influence each other. | X | ||||
| 4. Graduates need to think at multiple levels of detail and abstraction. | X | ||||
| 5. Students will be able to think critically, creatively and identify problems in their research. | X | ||||
| 6. Graduates should have been involved in at least one substantial project. | X | ||||
| 7. Graduates should realize that the computing field advances at a rapid pace. | X | ||||
| 8. Graduates should conduct research in an ethical and responsible manner. | X | ||||
| 9. Graduates should have good command of technical terms in both Turkish and English. | X | ||||
| 10. Graduates should understand the full range of opportunities available in computing. | X | ||||
| 11. Graduates should understand that computing interacts with many different domains. | X | ||||
| 12. Graduates should develop the knowledge acquired at master level and apply scientific methods in order to solve scientific problems. | X | ||||
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest