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